Auto shutdown of Oracle for Windows reboot

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Tue, 13 May 2008 10:57:06 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450B9B0260@NT15.oneneck.corp>


I'm having some trouble getting Oracle to shutdown cleanly for our scheduled weekly Windows reboots.  

Win2K3 x64 SP2
Oracle 10.2.0.3 64 bit  

I followed Metalink note 231495.1 to add a script to the Windows Group Policy to run the "net stop" commands at shutdown to stop the Oracle services, which in turn will gracefully shutdown the database according to my registry settings of ORA_SID_SHUTDOWN=TRUE, ORA_SID_SHUTDOWN_TIMEOUT=300 and ORA_SID_SHUTDOWNTYPE=immediate.  

It works as expected when I shutdown from the Windows GUI by clicking Start > Shutdown. However, if I shutdown via the shutdown.exe command, the "net stop" commands don't get executed and therefore Oracle doesn't get shutdown cleanly.  

Anyone else seen this and have any ideas how to fix it?  

Thanks,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 13 2008 - 12:57:06 CDT

Original text of this message