RE: Oracle service starts but the instance does not

As Gidhin said, there is a registry key that controls whether the instance starts with the service. You can, if you don't want to muck about in the registry, type

oradim -edit -sid XXXX -startmode auto

That will change the reg key for you.

stephan

Stephan Uzzell | Senior Database Administrator | Managed Services |MICROS Systems, Inc. Direct: 443.285.8000x2345 | Mobile: 443.864.1725 | suzzell_at_micros.com | www.micros.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter (ESS) Sent: Thursday, 12 June, 2014 10:30
To: oracle-l
Subject: Oracle service starts but the instance does not

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 - 22:44:23 CEST