RE: Oracle service starts but the instance does not
Date: Fri, 13 Jun 2014 19:37:57 +0000
Message-ID: <5415b219d86545fb8a2fbe113af394c2_at_BLUPR07MB051.namprd07.prod.outlook.com>
In addition, the "Administration Assistant for Windows" is a GUI application from Oracle that you can use to set the database instance to start with the service; it is installed along with the database.
-joel
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Uzzell, Stephan
Sent: Thursday, June 12, 2014 4:44 PM
To: 'peter.schauss_at_ngc.com'; oracle-l
Cc: Uzzell, Stephan
Subject: RE: Oracle service starts but the instance does not
Hi Peter,
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
Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.
--
http://www.freelists.org/webpage/oracle-l Received on Fri Jun 13 2014 - 21:37:57 CEST