Re: SHUT IMMEDIATE !!!! PROBLEM !!(URGENT!!)

From: Ronald <ronr_at_wxs.nl>
Date: Wed, 3 Feb 1999 20:20:12 +0100
Message-ID: <01HW.B2DE5FFC00025327127BBD30@news.wxs.nl>

On Tue, 2 Feb 1999 18:27:44 +0100, Doug Cha wrote (in message <36b73590$0$16676_at_nntp1.ba.best.com>):
>
>
> No, a shutdown immediate is really a shutdown normal after terminating all
snip
> Sang Ryung Lee <srlee_at_shinsegi.com> wrote:
snip
>> do shutdown immediate, DB waits until all of transactions roll back. If >> some transaction is being processed,you should waits until the transaction snip

>>> hi!, i am trying to shutdown immediate but it hangs for >1 hrs. in 
>>> alert_log : 'Hutdown instance (normal) SHUTDOWN: waiting fro logins to 
>>> complete. this has happended >5 times. Shutdowm aborts solves the problem.

snip

If everything else fails, do 'startup force' followed by a 'shutdown'. This just chops all oracle server processes, starts them again, performs recovery when needed and closes the database.

Ronald  -  Unix SA               http://home.wxs.nl/~ronr/professional.html

        -  Oracle DBA            http://www.tresco.nl  
        -  Middleware programmer/
                      designer   mailto:R.Rood_at_tresco.nl

Received on Wed Feb 03 1999 - 13:20:12 CST