Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A strange phenomonon in shutdown with Normal
and earlier - we also had these features with 6 . (I have however erased all memories of 5...)
One thing also to check is whether you have any job queues running - I have
been caught by this before, particularly if the interval is short!
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:3a7cf7ed$1_at_news.iprimus.com.au...
> 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 Wed Feb 07 2001 - 00:21:49 CST