Re: Oracle 8i on W2k Service Starting

From: Pieter Claerhout <Pieter_Claerhout_at_creoscitex.com>
Date: Sat, 16 Jun 2001 10:06:16 GMT
Message-ID: <scGW6.37160$mR5.4940122@afrodite.telenet-ops.be>

I had a similar problem, and it could be fixed by changing a setting in the registry.

If you look under HKLM\Software\Oracle, you'll see keys for every ORACLE_HOME you have. For each home, there is a parameter called AutoStart (if I remember well). Make sure that one is set to true. If not, the Oracle services will start, but the database will never be opened automatically.

Cheers,

Pieter

"Paul Tatam" <paul.tatam_at_basingstoke.dot.gov.dot.uk> wrote in message news:3b2249c6_2_at_nnrp1.news.uk.psi.net...
> I have installed Oracle 816 on a Windows 2000 Server (SP2), I can create a
> database ok, however when the server is reloaded the Oracle service for
the
> database goes into a state of 'Starting', and it never starts. At this
> point I can use sqlplus to call 'startup open', and the database is then
> available to the users, however the service will still show starting.
>
> I have a few goes at re-installing oracle and recreating the database but
> get the same result each time.
>
> Any help much appreciated.
>
> Paul Tatam
>
>
>
Received on Sat Jun 16 2001 - 05:06:16 CDT