Re: Oracle 8.0.5 autostart

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 - 07:18:17 CST