firstly a shutdown waits for connections to complete where as a shutdown
immediate does not, also you don't specify the os so i'll guess that you are
using nt and you have left the inteligent agent running, this can often hang
for a while even in shutdown immediate..!!you may want to stop the ia first
--
Regards,
Daniel.
"Bruce" <bduff_at_condenast.co.uk> wrote in message
news:2df6b834.0203280911.2edd3a1_at_posting.google.com...
> 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 - 17:46:33 CST
