RE: Auto shutdown of Oracle for Windows reboot
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "Yong Huang" <yong321@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 May 2008 11:32:58 -0700
Yong,
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
