Re: Database Shutdown Normal ...hangs ....why?
From: M. Moiz <moiznet2002_at_yahoo.com>
Date: 9 Jul 2001 10:21:03 -0700
Message-ID: <53b2483d.0107090921.149fc19e_at_posting.google.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 ???
Date: 9 Jul 2001 10:21:03 -0700
Message-ID: <53b2483d.0107090921.149fc19e_at_posting.google.com>
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 ???
Could be cauz one or more of the tables are fragmented...
Also check for any misplaced parameters in the init.ora file... Received on Mon Jul 09 2001 - 19:21:03 CEST