RE: hanging shutdowns

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Mon, 27 Feb 2006 15:42:16 -0800
Message-ID: <024501c63bf7$710a9e40$7400000a@flbp7000a>

I usually take the server out of the rack and drop it on the floor a few times. It seems to stop Oracle.

No seriously, you should NEVER have to reboot the host just because shutdown immediate is hangint! You should to do 2 things:

To shut it down, log in as sysdba a new SQL*Plus session and:

SQL> alter system checkpoint;
SQL> shutdown abort;

If you need a consistent database (like for a backup), then startup restrict and shutdown immediate again.

2. If you would like to find out why your immediate shutdown is slow, look at Metalink note 164504.1. Basically it says to turn on a 10046 trace at level 12 and run the shutdown. This should show you what the shutdown is waiting on.

Jeremiah Wilton
ORA-600 Consulting
Recoveries - Seminars - Hiring
http://www.ora-600.net

-----Original Message-----

From: Roger Xu

What should I do if "shutdown immediate" hangs? Last time, I had to reboot the Solaris Server.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 27 2006 - 17:42:16 CST