Hello,
> I'm reading that win2k supports shutdown scripts (w/the group policy mmc
> snap-in). Is anyone using these to shutdown their win2k-hosted oracle
> databases? Right now our netadmins are running shutdown scripts as a
> manual
> step, but if it's susceptible of scripting, we'd like to do it that way
> instead. Are there any gotchas?
>
I have a TAR open with OSS regarding the shutdown behaviour of 8.1.7.x on
Win2K.
We have several Win2K servers running 8.1.7.3 or 8.1.7.4 which do not
stop the database correctly during a server reboot. Investigation has
shown that while a 'net stop oracleservice<DB_NAME>' command entered
into a command prompt completes successfully, shutting down / rebooting
the server without first stopping the database service results in an
instance recovery having to be performed during startup.
The alert log shows that during a shutdown / reboot, there is *no*
attempt made to stop the database. I have configured the servers and
databases according to the various Metalink documents and the settings
have been verified by OSS.
This behaviour only occurs on our Win2K servers that run 8.1.7.3 and
8.1.7.4: other Win2K servers that run 8.1.7.2 and earlier do not
exhibit the problem. Interestingly, we do have a single Win2K/8.1.7.4
server that does stop the database correctly during a server shutdown /
reboot.
OSS have recreated the error using 9iR2 on Win2K and have reported that
the database stop during a server shutdown / reboot appears to work more
reliably on NT. Investigation by Oracle Development suggests that the
problem lies with the Service Control Manager (SCM) in Win2K that handles
the starting and stopping of the system services.
OSS have advised me to get in touch with Microsoft to persue the matter
further. I have (unsuccessfully) attempted to persuade OSS to liase with
Microsoft directly but they have so far refused. I digress ...
Finally, to answer your question, a workaround provided to me by OSS is
to use the Group Policy Editor to have Win2K run a VBS script during a
server shutdown. The code provided is:
Set WshShell = WScript.CreateObject("WScript.Shell")
Return=WshShell.Run("sqlplus ""shutdownusr/passwordl as sysdba"" @C:\orashut",
1, true)
I received the code only yesterday and as yet haven't tested it. As I
would rather not have a password held in a text file on the server, I
first plan to test the use of the GP shutdown script with the 'net stop'
command (as described above) as this works correctly interactively and
obviates the need for a user id and password to stored in a file.
Before testing the use of the GP shutdown script, I advise you to
investigate if the database(s) on your Win2K server are stopped
correctly during a server shutdown / reboot. If the databases are
stopped in the correct manner, then it is one less thing for you to
worry about :)
I'll do some of my own testing with the GP shutdown script and post
feedback to the list. Please note that it will take me some weeks to
provide the feedback as I am about to start a major installation of
a new set of databases and servers for a customer of ours. I just
love those night shifts and long hours ;)
---
nigel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nigel Cemm
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
