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

From: Khushalani, Vikram <Vikram.Khushalani_at_MWAA.com>
Date: Tue, 26 Mar 2002 10:18:37 -0800
Message-ID: <F001.00433A39.20020326101837@fatcity.com>

Peter,

On the NT - the placement of the String/Key values matters. So try setting these parameters in the Registry in your current '\home' hive under \oracle. For example if you have a single Oracle Home on your Server/Machine then it would be something like 'home0', so your entries would be:

HKLM\software\Oracle\home0\ora_<sid>_shutdown="TRUE"
                          \ora_<sid>_shutdown_type="i"
                          \ora_<sid>_shutdown_timeout="300"

HTH,
Vikram Khushalani
Oracle DBA

-----Original Message-----
Sent: Tuesday, March 26, 2002 10:48 AM
To: Multiple recipients of list ORACLE-L

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).
--

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

Author: Khushalani, Vikram
INET: Vikram.Khushalani_at_MWAA.com

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