Re: shutdown immediate hangs

"Karen Abgarian" <abvk_at_ureach.com> wrote in message news:3D8AB59A.441AF1D2_at_ureach.com...
> 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.
>

You'll have to explain why doing a shutdown abort is a 'misuse', but knocking up a totally unsupported script that kills off processes in a thoroughly unsupported way is OK.

It doesn't compute, captain.

HJR
> 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 - 02:05:24 CDT