Re: Unable to shutdown the database

From: <zigzagdna_at_yahoo.com>
Date: Mon, 5 Nov 2012 20:41:00 -0800 (PST)
Message-ID: <fe3ae1c4-b561-47aa-ae6e-0b2f667c9201_at_googlegroups.com>

On Friday, November 2, 2012 3:46:22 AM UTC-4, zigz..._at_yahoo.com wrote:
> I am on Oracle 11.1.0.7 on HP UNIX 11i. I have been using following procedure to shutdown database for a long
>
> time:
>
>
>
> 1. shutdown abort
>
> 2. startup
>
> 3. shutdown immediate
>
>
>
> Today (after Sandy hurricane where my datacenter lost network connectivity), I noticed:
>
>
>
> In the last step, database does not close, I have been waiting for 30 minutes and gave up. My database is only 50GB.
>
> Any idea, why?
>
>
>
> When I could not do step 3, I did again following steps:
>
>
>
> 1. shutdown abort
>
> 2. startup
>
>
>
> Database comes up and I do not see any errors. I can access all my data. Can anyon eexplain, database will not shutdown without abort(why I have to wait forever, how I can troubleshoot).

I can give you 10 different links which say there is nothing wrong with shutdown abort. I agree that one should try shutdown immediate first; but sometimes it takes forever!!! Received on Tue Nov 06 2012 - 05:41:00 CET