Oracle-L: Re: Automatic shutdown of Oracle on NT

From: Schauss, Peter <SCHAUPE_at_mail.northgrum.com>
Date: Tue, 26 Mar 2002 07:48:25 -0800
Message-ID: <F001.004334F7.20020326074825@fatcity.com>

OK. I followed Jared's suggestions and set the following:

HKLM\software\Oracle\ora_<sid>_shutdown="TRUE"
                    \ora_<sid>_shutdown_type="i"
                    \ora_<sid>_shutdown_timeout="300" (5 minutes)

HKLM\system\CurrentControlSet\Control\WaitToKillService="300000"

Whether it was necessary or not, I rebooted the machine after changing the settings.

When I go to settings->services and stop OracleService<SID> it still does a shutdown-abort. The dialog box returns in less than 20 seconds.

FWIW, when I do a shutdown-immediate from DBA studio, it takes about 90 seconds.
After shutting the database down in this fashion, the settings->services dialog box still showed OracleService<SID> as "started". In order to restart
the instance, I had to stop the service and restart it.

What am I missing here?

Thanks,

Peter Schauss
Northrop Grumman Corporation
516-346-3148
schaupe_at_mail.northgrum.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Schauss, Peter
INET: SCHAUPE_at_mail.northgrum.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Tue Mar 26 2002 - 09:48:25 CST