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

From: Don <don_at_xxx.com>
Date: Mon, 09 Jul 2001 17:16:56 -0400
Message-ID: <mo7kkt4shp7j58i3kql4nem5lkc600euii_at_4ax.com>


On Mon, 09 Jul 2001 22:40:45 +0200, Alain Schartz <alain.schartz_at_cc.lu> wrote:

>You mentionned your use of DBA Studio, so I suppose you are using an
>Enterprise Manager Installation (on an NT server?). If this is the
>case, check if you have the Oracle Assistant service running (on the
>server). This service is permanently logged into your database and
>thus prevents a normal shutdown. Nevertheless, a shutdown immediate
>should work without any problems, as this kills every active session
>before shutting down the DB.
>
Thanks

>N.B. You do not have to reboot the server to clear a pending shutdown,
>just log into another SQL*Plus (or svrmgr) session and perform a
>shutdown abort. This frees the lock.
>
 ...and thanks ....I'll try both methods
>Hope this helps,
>Alan
>
>On Mon, 09 Jul 2001 08:15:34 -0400, Don <don_at_xxx.com> 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 09 2001 - 23:16:56 CEST

Original text of this message