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: 31 Jan 2005 12:33:05 -0800
Message-ID: <1107203585.037471.322010@c13g2000cwb.googlegroups.com>

DA Morgan wrote:
> premmehrotra_at_hotmail.com wrote:
>
> > 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.
> >
> > Can anyone tell me how to overcome this problem. I use
> > shutdown abort (to force shutdown independt of anything running,
> > then startup and then shutdown immediate...).
> >
> >
> > Should I change startup to startup restrict eventhough I do not see
> > that is the cause.
> >
> >
> >
> > Thanks a lot,
> >
> > Prem
>
> No DBMS_JOBs? No Advanced Queuing?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)

Yes, none of that. Looks like some bug in Oracle to me. Received on Mon Jan 31 2005 - 14:33:05 CST

Original text of this message

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