Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5 autostart

Re: Oracle 8.0.5 autostart

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 22 Mar 2002 06:41:56 +1100
Message-ID: <a7dd3j$epa$1@lust.ihug.co.nz>


It's either corrupt, or there are permission problems on that directory. Assuming you have multiple controlfiles, copy one of the others into that directory. Then check that the relevant users and groups have rights (for testing, set permissions to 'EVERYONE' having full read - write access, and see if that helps).

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"John" <jriker1_at_yahoo.com> wrote in message
news:e6bb5a8d.0203210518.1362e931_at_posting.google.com...

> The only thing of interest in the alert log, which I guess is the
> problem is the below. Problem is, the control1.dbf file does exist,
> and opening the database thru DBA Studio works everytime.
>
> ALTER DATABASE MOUNT
> Thu Dec 27 10:44:37 2001
> ORA-00202: controlfile: 'd:\oracle\prd8\cntrl\control1.dbf'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> Thu Dec 27 10:44:37 2001
> ORA-205 signalled during: ALTER DATABASE MOUNT...
>
> Thanks.
>
> JR
>
>
> "Simon Gottesman" <sgotte_at_prodigy-nospam.net> wrote in message
news:<kNMj8.2740$n27.573602870_at_newssvr16.news.prodigy.com>...
> > Hello John,
> > Look for an oradim.log in OracleHome/Database/. Perhaps your alert log
also
> > contains pertinent information.
> > Hth,
> > Simon
> >
> > "John" <jriker1_at_yahoo.com> wrote in message
> > news:e6bb5a8d.0203130536.34ba54d3_at_posting.google.com...
> > > Thanks. Tried the oradim80 option. Didn't help. In the registry
> > > it's set to autostart, as well as all services. When the machine
> > > reboots, the database is not open. Is there a log somewhere that
> > > would show me why this is happening? Thanks.
> > >
> > > JR
> > >
> > > Atul Agrawal <atul_ce_at_yahoo.com> wrote in message
> > news:<3C8E77F4.6BC23979_at_yahoo.com>...
> > > > > i think could also set the oracle service for your sid, to start
> > > > > automatically on boot...
> > > >
> > > > this can be done by chaging the option in the services found in
control
> > > > pannel.
> > > >
> > > > alternatively,
> > > >
> > > > if you think you are grownup enough to change registry, you could do
one
> > > > thing is
> > > > find the autostart key in your registry for your sid, and enter the
> > > > value yes for it..
> > > >
> > > > i think this shoul dsolve the problem...
> > > >
> > > >
> > > >
> > > >
> > > > > I have a server that has this tendency to restart itself. It's
> > > > > running Oracle 8.0.5 on Windows NT. The server does not seem to
open
> > > > > on it's own. Any help in how to get this database to start on
boot
> > > > > would be much appreciated.
> > > > >
> > > > > JR
> > > >
> > > > --
> > > >
> > > > Atul Agrawal | Atul Agrawal
> > > > Masters Student, CS Deptt. | 3501, St Paul Street,
> > > > Johns Hopkins University | Apt # 1018,
> > > > 3400, N Charles Street, NEB 224 | Baltimore,
> > > > Baltimore, MD 21218. | MD 21218.
> > > > |
> > > > Hello: 410-516-8291 (Lab) | Hello: 410-366-6852 (Resi)
Received on Thu Mar 21 2002 - 13:41:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US