RE: Auto shutdown of Oracle for Windows reboot
Date: Fri, 16 May 2008 11:32:58 -0700
I checked the path and verified it is running C:\WINDOWS\system32\shutdown.exe and when I look at the properties of the file it has the description "Windows Remote Shutdown Tool", a Microsoft Copyright and version number 5.2.3790.3959. The Windows version is Server 2003 Enterprise Edition x64, SP2.
I've already bumped up WaitToKillServiceTimeout, but it doesn't help since the database is never even getting the shutdown command at all.
Thanks for the other suggestions, but I've already spent too much time on this so I've decided to settle for the following workaround:
I've implemented the netstop.cmd Group Policy shutdwown script as mentioned in the Metalink note - this will take care of manual shutdowns via the GUI, and I've scheduled the same script to run via Windows Scheduled Tasks every weekend prior to the remotely scheduled shutdown script, so that will take care of the regularly scheduled reboots. Between those two solutions, we should be covered for over 90% of all shutdowns/reboots. The database will still be crashed if anyone runs a manual shutdown via shutdown.exe without manually shutting down the database or stopping its services first, but we'll just live with that risk, which is fairly low considering most people only use the GUI for manual shutdowns and in 8 years of working with Oracle on Windows I've never seen it fail to complete crash recovery after a server restart.
Thanks again for all your help and have a great weekend! 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.Received on Fri May 16 2008 - 13:32:58 CDT