Re: database doesnt shutdown , help needed

Sorry but I'm running hp-ux 11.00 with 8.1.7.0.0

Also dont have DBSNMP running on this. Just DBMS_JOBS for statspack. I think this is causing intermitent issues with Shutdown.

Thanks
Bruce

daniel" <test_at_test.com> wrote in message news:<a809p7$2kv$1_at_news5.svr.pol.co.uk>...
> 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 Tue Apr 02 2002 - 07:20:49 CST