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

From: Michael Bierenfeld <michael.bierenfeld_at_ibsgmbh.de>
Date: Wed, 20 Jan 1999 13:03:43 +0000
Message-ID: <36A5D42F.4A2923D2@ibsgmbh.de>

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

Hello,

one possible solution would be to kill each user process on the server side. If the users are connected via SQL*Net the user-processes can be easily identified by the "ps" command.

A user process looks like this : "oracleV732 (local=no)". Kill the corresponding PID.

You might come in trouble with open Transactions but hopefully the commits in your applications are setted correctly ;-)

Regards

Michael Received on Wed Jan 20 1999 - 07:03:43 CST