Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database shutdown on NT

Re: Database shutdown on NT

From: Andy Hardy <Andy_Hardy_at_camk.demon.co.uk>
Date: 1997/09/09
Message-ID: <TjmBDJAyjRF0MwhI@camk.demon.co.uk>#1/1

In article <3414103d.4284310_at_dbn-news.iafrica.com>, frank <fdowns_at_npb.co.za> writes
>

 [snip my stuff]
>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'.
>>

 [end of snip]
>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
>

Frank,

Thanks for this. It confirms what support said about Oracle 8.

Unfortunately, I'm only on 7.3.3...

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG
Received on Tue Sep 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US