Re: Database shutdown on NT

On Wed, 3 Sep 1997 09:21:23 +0100, Andy Hardy <Andy_Hardy_at_camk.demon.co.uk> wrote:

>Hi,
>
>I recently had to call Oracle support regarding an ORA-600 problem I
>had.
>
>During the course of conversation, support asked how I'd been shutting
>down the database. I said that I'd been using the Control
>Panel/Services. His reply was that this was the equivalent of a kill -9
>on Unix and was 'not a good thing'. Apparently Oracle 8 has changed the
>behaviour to be equivalent to a 'shutdown immediate'.
>
>Does the above sound correct?
>
>If so, how do you get a correct shutdown performed automatically when
>you shutdown NT? I'm sure that I'll almost always forget to go into
>svrmgr to shutdown the databases before I just ask NT to shutdown!
>
>Ideas?
>
>--
>Andy Hardy

Andy, I managed to find some information regarding your query in the Oracle 8 documentation.

It goes as follows . . .

"You can immediately shut down the Oracle8 database by stopping the service OracleServiceORCL. This automated procedure is equivalent to manually entering the following two commands:

C:\> SVRMGR30
SVRMGR> SHUTDOWN IMMEDIATE This causes the database to terminate and roll back active transactions, disconnect clients, and shut down."

I hope this helps

Frank Downs
Natal Parks Board
South Africa Received on Mon Sep 08 1997 - 00:00:00 CDT