Re: how to start Oracle 8i DB automatically

Anand wrote:

> Hi,
> I am using Oracle 8i on an Win2K machine. The problem is that each
> time I boot my machine I have to manually start the database by using
> DBA Studio.
> I looked into Administrative Tools->Services. All Oracle related
> services mentioned there are set to Automatic except
> OracleManagermentServer (here it is "manual").
> My DB is named "Demist" and there is a service named
> "OracleServiceDemist" and its status-type is set to "Automatic", but
> status is set to "Starting" by default (whereas for other services it
> is "Started").
> Please help!
> Thanks and Regards,
> Anand

I've seen this once before and solved it by using ORADIM to drop the Windows services and recreate them.

This can be done without affecting the database or needing to reinstall anything.

Go to the $ORACLE_HOME\bin and type oradim at the DOS prompt. (you can not do this in the GUI).

Follow the instructions and you will likely end up with something like:

oradim -delete -sid Demist

followed by

oradim -new -sid Demist -intpwd Oracle -startmode a -pfile blah blah blah

but the above is just off the top of my head so get the full syntax by first typing just "oradim".

Daniel Morgan Received on Wed Jul 10 2002 - 13:39:32 CDT