Re: database doesnt shutdown , help needed

Hi Guys

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???

Did you stay on the base release of 8.1.7.0.0 or did you have to patch when you hit various problems???

Thanks and have a great weekend.
Bruce

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a7uvgg$g50$1_at_lust.ihug.co.nz>...
> I've gotten to the point on these shutdowns-that-never-happen where I make
> sure I stop the Intelligent Agent before attempting the shutdown (assuming
> this is an o/s scripted shutdown-backup you're doing). For some reason,
> having that hanging around the place can make a difference.
>
> Regards
> HJR
> --
> ------------------------------------------
> Resources for Oracle : www.hjrdba.com
> ============================
>
> "Bruce" <bduff_at_condenast.co.uk> wrote in message
> news:2df6b834.0203280226.707746c4_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 post a thread if you have seen this issue before. If you need
> > more info let me know.
> >
> > Thanks and have a good Easter....
Received on Thu Mar 28 2002 - 11:13:50 CST