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

No, a shutdown immediate is really a shutdown normal after terminating all connections and rolling them back. Everyone look at your own alert.log files and you'll see that shutdown immediate = shutdown normal.

-Doug

Sang Ryung Lee <srlee_at_shinsegi.com> wrote:

: As your alert_log file said, I think  you did shutdown " normal" instead
: of  "immediate".
: If  your DB has the transactions being processed when you do shutdown
: immediate, DB waits until all of transactions roll back.
: If some transaction is being processed,you should waits until the
: transaction is finished or the transaction rollback.

: S.R. Lee

: naveen_arora_at_my-dejanews.com wrote:

:> 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.
:> but i dont want to do it every time.
:> i am rnning oralce 7.3.2 on UNIX in multi-master configuration.
:> thanks for any help.
:> naveen
:>
:> -----------== Posted via Deja News, The Discussion Network ==----------
:> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Feb 02 1999 - 11:27:44 CST