Re: database doesnt shutdown , help needed

please refer to note: 1039146.6 on Metalink about a very similar problem. refer to bug fix/patch list:

 8173 [BUG:1841387] SHUTDOWM IMMEDIATE may take > 60 seconds with no active transactions

Anyone like to shed any light on this? please answer if you have had a similar problem.

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<yvDo8.3251$e5.19613_at_news.indigo.ie>...
> It will not shut down if sessions are connected.
>
> Check v$session table before you shutdown. You will have connections that
> are open.
> (the oracle Reference manual contains details of v$session)
>
> Please note this is bad. When you restart the DB it must roll forward and
> back, so you are taking a backup of an unstable system....
>
> Please note this also includes SQLPLUS that are connected but not apparently
> doing anything.
> "Bruce" <bduff_at_condenast.co.uk> wrote in message
> news:2df6b834.0203280227.61aa5103_at_posting.google.com...
> > Hi there,
> >
> > Each night my backup of my production 8.1.7.0.0 database has been
> > playing up. The database runs in noarchivelog mode.
> >
> > However it sometimes (and I mean intermittently) does not shutdown
> > before it does the copy of the files etc and stays like that until I
> > manually do a shutdown abort, startup restrict, shutdown normal etc.
> > Then the script carries on and copies the files etc. The dbase then
> > gets restarted. The database is using shutdown immediate. I generate a
> > trace file as well using 'Alter session set events '10400 trace name
> > context forever, level 1'; The contents of which is not mega helpful I
> > must admit.
> >
> > The alert log says: "SHUTDOWN: waiting for active calls to complete.
> >
> > I'm beginning to think I may have to write some logic in the backup
> > script about this but want some clarification from anyone out there if
> > they have seen this same problem on this release of the database.
> >
> > Please let me know if you have seen this issue before.
> >
> > Thanks and have a good Easter....
Received on Thu Mar 28 2002 - 11:11:32 CST