Re: shutdown immediate hangs

I wonder why nobody has responded with an opinion on WHY does oracle wait, sometimes indefinitely for shudown immediate. Likely this has to do with the famous question of when exactly PMON cleans up the sessions and releases the resources after you issue a KILL SESSION command.

It seems to be very popular to shutdown abort and then startup and shutdown normal.
Even though this works, this is a misuse and it is natural to seek a more graceful solution.

The contraindications of killing the sessions in a script are many but have a common root:
they are difficult to implement properly. A few years ago I wrote such a script, it was
several dozens lines of code. I am not willing to dig it up, but I can certify that it is possible.
The advantage is that you can do shutdown immediate or even normal instead of
shutdown abort.

Regs
AK

Kenneth, Koenraadt wrote:

> On Thu, 19 Sep 2002 12:51:46 +0200, cris <veronesic_at_libero.it> wrote:
>
> >Niall Litchfield wrote:
> >
> >> 1. issue shutdown ABORT then immediately startup and shutdown normal.
> >
> >I was thinking about adding to my script a line that kills all the
> >active oracle<sid> processes immediatly before to do the shutdown. Is
> >this a safe way to proceed or are there contraindications?
> >
>
> Safe : NO!!
> Contraindications : Dozens!
>
> Do as Niall says. "Shutdown abort" will kill those processes in a safe
> way.
>
> - Kenneth Koenraadt
>
> >Thank you.
> >Kind regards, Cristian
> >
Received on Fri Sep 20 2002 - 00:46:26 CDT