Re: shutdown immediate hangs

>
> 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
I will try to explain why I think so.

As you know, when an instance starts up after a shutdown abort, it performs an instance recovery. We know that this has always worked but still, it is a recovery.
It could be compared to what Windows is doing on startup when you use your reset button.
It is abnormal and I do not like my software to stop and start in an abnormal way.
By the way, abort/startup/shutdown will not work if you happen to run a hot backup at the time.
There might be other interesting things related to aborting.

If you come up with an script that kills sessions, you are also not doing a nice thing,
but that thing is for the application or in general for processes accessing your database.
However, you have the database server shutdown cleanly. I do not think that the word
"unsupported" is relevant.

Of course, both options are far from perfection. A better way to shutdown would be
to shutdown your application and any processes accessing your database in a way supported and
provided by these processes and the application. And then to shutdown NORMAL.

Regs
AK Received on Sat Sep 21 2002 - 01:26:05 CDT