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

From: Robert Fazio <rfazio_at_home.com.nospam>
Date: Mon, 09 Jul 2001 22:22:11 GMT
Message-ID: <n8q27.10179$Y6.3135282_at_news1.rdc2.pa.home.com>


Shutdown Normal Waits for all connections to exit, not commit, but exit. You could have people logged into the system for that period. Use shutdown immediate instead.

"Don" <don_at_xxx.com> wrote in message
news:oc7jktsb5n33iatpa0kv4t9rupn0an6upf_at_4ax.com...
> 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 Tue Jul 10 2001 - 00:22:11 CEST

Original text of this message