Re: NT shutdown

On Thu, 29 Jul 1999 08:58:53 -0700, Pete Sharman <psharman_at_us.oracle.com> wrote:

>It depends on what version you're talking about. In Oracle7 it did a
>shutdown abort, since there were no hooks to tell Microsoft to wait while the
>database went down and services only got 20 seconds to do clean shutdowns.
>In Oracle8, there have been some parameters added to the registry (names are
>something like ORA_sid_SHUTDOWN_TIMEOUT and ORA_sid_SHUTDOWNTYPE) where you
>can change this. The shutdown type setting is the one that says immediate,
>abort etc.
>
>HTH.
>
>Pete
>

Actually, creating the key ORA_SHUTDOWN with a value of TRUE (it does not exist by default) only stops the database if you manually stop the service within control panel. Shuting down NT stills crashes the database.

You can verify this by reviewing the alert log. If you stop the service (after creating the registry entry) you can see where the database was shutdown immediate. If you simply shutdown NT, there will be nothing about the shutdown in the alert log but it will report a crash recovery when the database starts back up again.

Why it works one way and not the other makes no sense.

--
Mark Wagoner
To reply, remove no.spam from my e-mail address Received on Fri Jul 30 1999 - 07:56:52 CDT