Re: Database Shutdown Normal ...hangs ....why?

Shutdown Normal waits until all current connections/transactions are complete. One of the most common problems here is that the 'Intelligent Agent' used in Enterprise Manager is still connected.

Many DBAs use (create their own) script to list all connections before shutting down.

/Hans

Don wrote:

> I have an 8.1.6 server that I am trying to shut down under normal
> circumstances. It just hangs and doesn't complete the shut down
> through DBA Studio. I have left the normal shut down going over a
> weekend and it is still not completed. Once this is started I can't
> cxl the shutdown normal process....(I have to reboot to get the db up
> again).
>
> It will only complete a shut down using "SHUTDOWN ABORT".
>
> - it is in "NO ARCHIVE" mode
> - it is usually on 24 hours a day..(though that is not a requirement)
> - there are no users on the system when i am attempting the normal
> shut down
>
> i am trying to get a clean shutdown to begin a backup and recovery
> plan and start archiving.
>
> any ideas why shutdown normal would hang ???
  Received on Mon Jul 16 2001 - 05:35:08 CEST