Re: Auto shutdown of Oracle for Windows reboot
Date: Wed, 14 May 2008 08:59:25 -0700 (PDT)
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.
> 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?