Re: database doesnt shutdown , help needed

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 - 05:54:06 CST