Re: Oracle service starts but the instance does not

From: gidhin joy <gidhin_at_gmail.com>
Date: Thu, 12 Jun 2014 21:39:39 +0530
Message-ID: <CA+y_VGAp9n6PKQf4zjAXU6Pe6_BKs-Hky9Kxb4YpPDmuKuFeGw_at_mail.gmail.com>

Came across similar issue in the past. To start instance along with  windows service, I had to change value for the registry parameter ORA_<SID>_AUTOSTART to TRUE.

Path – hkey local machine > software > oracle > key_oracle_home

Thanks,

Gidhin

On 12 June 2014 19:59, Schauss, Peter (ESS) <peter.schauss_at_ngc.com> wrote:

> Environment: 32 bit Oracle 11.2.0.3 on Windows Server 2003 Enterprise
> Edition SP2
>
> I have 18 small Oracle instances running on this server (don't ask). All
> of the OracleService<sid> services are set to Startup Type= Automatic.
> When the server was restarted after Microsoft patches last night, one of
> the instances did not restart even though the Services screen showed that
> its service was running. The alert log had no entries between the time
> that the server went down for reboot and the time that I restarted it
> manually.
>
> Is there any way for me to determine what happened?
>
> Thanks,
> Peter Schauss
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 12 2014 - 18:09:39 CEST