Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: shutdown mmediate gets hung

Re: shutdown mmediate gets hung

From: <premmehrotra_at_hotmail.com>
Date: 1 Feb 2005 06:54:31 -0800
Message-ID: <1107269671.514774.66610@f14g2000cwb.googlegroups.com>

Goran wrote:
> <premmehrotra_at_hotmail.com> wrote in message
> news:1107190455.737530.190960_at_z14g2000cwz.googlegroups.com...
> >I am on oracle 8.1.6.2 on HP UNIX 11i.
> >
> > I am using following code to shutdown my database every Sunday:
> > svrmgrl <<eof
> > connect internal
> > shutdown abort
> > startup
> > shutdown immediate
> > exit
> > This shutdown has been working fine until now, but this week end
> > shutdown immedaite got stuck (see alert.log below):
> > Sun Jan 30 15:06:31 2005
> > Shutting down instance (immediate)
> > License high water mark = 2
> > Sun Jan 30 15:06:31 2005
> > ALTER DATABASE CLOSE NORMAL
> > Sun Jan 30 15:06:31 2005
> > SMON: disabling tx recovery
> > Mon Jan 31 05:33:08 2005
> >
> > Eventhough ALTER DATABASE CLOSE NORMAL was issued at 15:06:31, it
did
> > not shutdown the database.
> >
> >
> > There was nothng running between startup and shutwon immediate.
> >
>
> Smon process probably cleans up unused (temp) extents. If it's HPUX,
use
> "top" to make sure that smon uses some (or much) cpu time. It can
take *a
> lot* of time if you use dictionary managed tablespaces with
improperly sized
> extents.
> It is quite normal behaviour and has little to do with version
(supported or
> unsupported) of Oracle. It is not a bug.
> Either wait for it to finish, or abort the instance.. if you abort
the
> instance, smon will normally continue doing it's job after you
startup the
> instance.
>
> Regards...

So, if i underatnds you correctly:
after shutdown abort
when I do startup
smon will be cleaning tempory segments in the bakground while startup is running, if I
do shutdown immediate
smon has to finish cleanup, so shutdown immediate could hang

I am hoping when startup is issued, Oracle will complete its recovery before it lets you do shutdown immediate.

Prem Received on Tue Feb 01 2005 - 08:54:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US