Re: Shutting down NT system. Is DB shutdown or crashed?

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: Thu, 10 May 2001 17:09:06 +0800
Message-ID: <9dedqn$jva$2@news.seed.net.tw>

"Syltrem" <syltrem_at_videotron.ca.spammenot> ¼¶¼g©ó¶l¥ó news:u0SJ6.9519$Co.868190_at_wagner.videotron.net...
> Hi!
>
> When you shutdown an NT system, how do you ensure that the Oracle DB is
> shutdown properly?
>
> Other than connecting manually and doing a shutdown immediate, that is. I
> would like the process of shutting down Oracle to be automatic.
>
> Thanks!

Oracle does a SHUTDOWN ABORT when NT shutdowns. It may crashed. You can check the Alert Log.
If Oracle safely shutdowned (normal, transactional, immediate), there would be a "Completed: alter database close normal" message, otherwise, Oracle shutdowned abort.

So, you'd better shutdown Oracle manually before you shotdown NT.

By the way, on the newer version, in the Oracle Administration Assistant tool you can choose the shutdown mode when service is stoped. However, it is not the shotdown mode when NT shutdowns. Received on Thu May 10 2001 - 04:09:06 CDT