Re: shutdown in svrmgrl is hanging

TJI I have had a similar problem on one of my servers. We ordinarily do a shutdown abort/startup/shutdown cycle (ignores the users, etc.) A while back we had to do just the abort.

The reason has to do with the rollbacks and transaction logs. The database was not coming down, even with no users other than the one svrmgrl. (Actually, it was NT, so svrmgr30.)

Oracle told us that there are clean up operations that can also occur on shutdown that can take a while on a heavily used system. We now have to do 'therapeutic shutdowns' periodically (keep the users off, do a shutdown normal and let it just run to the end.) It has taken up to 17 hours (!!!!!) to finally come down. (This is on a 150GB NT 8.0.5 db.)

You might consider a therapeutic shutdown if your users will give you a window.

In article <20000714.5594000_at_p200.nodomain>,   Jerry Gitomer <jgitomer_at_erols.com> wrote:
>
>
> When your database hangs doing a shutdown the best alternative
 is to=20
> do a=20
> "STARTUP FORCE" followed by a SHUTDOWN IMMEDIATE.
>
> Startup force does a shutdown abort (which brings the database
 down=20
> instantly) and
> then does a startup (which will initiate any rollbacks needed to
 clean=20
> things up after
> the shutdown abort). Once your database is up and running again
 the=20
> shutdown immediate
> should bring it down within a matter of seconds. Voila! A cleanly=20
> shutdown database.
>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 7/13/00, 12:38:43 PM, Steve Parker <steve_at_naweb.com> wrote
 regarding =
>
> shutdown in svrmgrl is hanging:
>
> > hello...
 

> > After issuing the shutdown command in svrmgrl, it just hangs forever
> > (since last night).... Just before that, I shut down a smaller DB
> > just fine...
 

> > Does anyone have any idea what would cause the shutdown process to
> > totally hang??
 

> > Thanks,
> > steve
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.