Re: A strange phenomonon in shutdown with Normal

Oracle didn't design it like that, and if this what you have to do, then it suggests that something is wrong.

Shutdowns *do* take time... shutdown normal will wait for all connections to terminate themselves before the shutdown takes place, and can therefore theoretically takes weeks or even months to eventuate. Shutdown immediate will boot all Users off whatever they are doing -but will then take time to roll transactions back before beginning the shutdown. I've known a shutdown immediate take 6 hours or so for all outstanding transactions to be rolled back.

Incidentally, the Listener and the Intelligent Agent also count as Users for those purposes, so even (on training courses, for example) when you can positively, absolutely guarantee that no-one is connected to your database and no transactions are pending, it *still* takes a few minutes for a shutdown immediate to take effect.

Have patience, therefore. And consult your logs and trace files to discover whether there really is a problem that needs to be worked at.

In any event, you say that "immediate" is working for you, and normal isn't: check v$session to see who is logged in, use alter system kill session '<sid>,<serial#>' to terminate those sessions, and then see how long it takes. Normal *will* sit there for ever unless all Users get themselves out. And it's been that way since at least Oracle 7.1

Regards
HJR "Zhenming" <zmwang_at_maloca.com> wrote in message news:aL5f6.358$0T2.25146107_at_nr1.ottawa.istar.net...
> I find in order to shutdown my database in Oracle8.1.6 on NT4.0, I have to
> first shutdown with abort, and then start it again, and then I can
 shutdown
> with normal.
> Even if you shutdown with normal option, and then start it again, you can
> not shutdown with normal again, you have to shut it down with abort first,
> and start again, and then shutdown normally. However, you can shutdown
 with
> immediate.
> I don't know why Oracle design in this way. In previous versions, I have
> never happened to be like this.
>
> Zhenming
>
>
Received on Sun Feb 04 2001 - 00:34:27 CST