Re: Unable to shutdown the database

From: joel garry <joel-garry_at_home.com>
Date: Fri, 2 Nov 2012 08:57:05 -0700 (PDT)
Message-ID: <67d79a28-12b6-46e3-8805-19aa23e69640_at_b4g2000pby.googlegroups.com>



On Nov 2, 12:46†am, zigzag..._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).

Are those 3 steps a leftover from older versions where the agents would keep attaching? For some cold backup?

Your symptoms sound like some client attaches automatically (or perhaps a persistent user kept trying and happened to hit it just right), keeping you from shutting down. Check all your crons, including remote ones, and all scheduled jobs, and any oms. Didn't you have problems shutting dbconsole at one time? Those java processes can be maddening.

When you shutdown, you might want to have another sysdba session open, to check for what transactions are hanging it up. Sometimes an existing dbconsole session can help too.

Startup force does a shutdown abort and then startup. Both abort and force should only be used in unusual situations. I seem to be in the minority thinking an abort is dangerous, though. The general problem is, if you have any problems in your redo stream, you'll not be able to startup. I'm perhaps over sensitive about it, from the long ago days when standbys in recovery were delicate.

jg

--
_at_home.com is bogus.
"Second nature, backed by decades of experience. Some things canít be
bottled. " http://www.utsandiego.com/news/2012/nov/02/tp-beer-ambassador-dr-bill-leaves-few-brews/
Received on Fri Nov 02 2012 - 16:57:05 CET

Original text of this message