Re: Automatic Oracle shutdown on NT?

What version of Oracle?
In the 7.x series, you have to shut down the database before you shutdown the service. Shutting down the service first is sort of like a shutdown abort.

In Oracle 8, they added some stuff to services to call a batch file (basically) and shutdown the database when the service shutsdown.

You can do the same thing by writing a command file and calling it before you shutdown.

Would not suggest just shutting down the NT Server before making sure your database (which is probably why you have the NT box in the first place) is gracefully exited.

Just my 2 cents worth.

On 22 Dec 1997 00:26:47 GMT, Bill Canning <bill.canning_at_SanDiegoCA.NCR.COM> wrote:

>Has anyone solved the problem of Oracle shutting down automatically when
>NT is shutdown?
>
>My Oracle instances startup automatically under NT, but a check
>of the alert
>log shows they are crashing on NT shutdown and needing instance recovery
>on startup.
>
>On further investigation, I find that shutting down the service
>manually from
>the Services menu is also not enough. The alert log indicates
>the instance is
>not actually stopped.
>
>Manual shutdown using oradim73 or svrmgr23 works correctly.
>
Received on Sat Dec 27 1997 - 00:00:00 CST