Re: Auto shutdown of Oracle for Windows reboot

Brandon, see Note:231495.1. It seems that even if you shutdown Windows cleanly, the DB shutdown behavior set by the Oracle registry is still not guaranteed. Maybe later versions of Oracle and/or Windows changed that.

Yong Huang

> Subject: Auto shutdown of Oracle for Windows reboot
> Date: Tue, 13 May 2008 10:57:06 -0700
> From: "Allen, Brandon" <Brandon.Allen_at_OneNeck.com>
>
> 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
      

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