Re: Oracle 8.0.5 autostart

bear in mind dba studio uses a different init<sid>.ora to start the db with where as when you start it u use the normal one!

daniel...

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a7dd3j$epa$1_at_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 - 14:07:49 CST