Re: Oracle 8.0.5 autostart

So if I copied the init.ora file that I used in DBA studio over the one used to start the database, it should then work? One other thing to note, I can start it with instance manager physically on the oracle box. Thanks.

JR

"daniel" <test_at_test.com> wrote in message news:<a7degg$tfc$1_at_newsg1.svr.pol.co.uk>...
> 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 Fri Mar 22 2002 - 12:47:04 CST