Re: Oracle shutdown abort on NT

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 10 Sep 1999 23:33:08 +0100
Message-ID: <937003227.911.2.nnrp-01.9e984b29@news.demon.co.uk>

That's the way NT works.

The Registry entries are there for OracleService, but when NT shuts down it doesn't try to stop the service properly, it just kicks Oracle to death.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Hop Pham wrote in message <7rbjhu$cth$1_at_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.
Received on Fri Sep 10 1999 - 17:33:08 CDT