Oracle shutdown abort on NT

From: Hop Pham <pham_hop_at_bah.com>
Date: Fri, 10 Sep 1999 14:40:54 -0700
Message-ID: <7rbjhu$cth$1@news.bah.com>

I implemented various NT registry settings to enable Oracle immediate shutdown on NT, but Oracle still does a shutdown abort whenever NT shuts down. For the default sid ORCL, I set Oracle shutdown immediate timeout to 60 sec., and NT service shutdown timeout to 10 min:

[HKEY_LOCAL_MACHINE]\software\oracle\

        ORA_ORCL_SHUTDOWN:REG_EXPAND_SZ:TRUE
        ORA_ORCL_SHUTDOWN_TIMEOUT:REG_EXPAND_SZ:60



    [HKEY_LOCAL_MACHINE]\system\currentcontrolset\control\


        WaitToKillServiceTimeout:REG_SZ:600000

And rebooted NT for the registry settings to take effect. When I re-started NT again, Oracle alert log did not show any immediate shutdown, and indicated crash recovery at startup (nothing unusual showed in NT event log). However, if I manually stop NT's OracleServiceORCL service, Oracle alert log will indicate immediate shutdown.

Any ideas, folks? The environment is Oracle 8.0.5 on NT server w/sp 3. Thanks in advance for any assistance.

Hop Pham
pham_hop_at_bah.com Received on Fri Sep 10 1999 - 16:40:54 CDT