RE: hanging shutdowns

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 28 Feb 2006 10:07:13 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410506909437@usahm236.amer.corp.eds.com>

If a shutdown immediate hangs then what I do is usually just open another sqlplus /nolog session, connect / as sysdba, and issue "shutdown abort". Works like a charm.

To prevent shutdown immediate from hanging and since we run the databases on backend servers and the applications from an application server we follow a simple procedure:

stop production batch
run a script to kill all remotely connect users connect to Oracle and shutdown immediate

We have not had a shutdown hang in ages.

HTH -- Mark D Powell --

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dougie McGibbon Sent: Monday, February 27, 2006 6:52 PM
To: 'Oracle-L_at_Freelists'
Subject: Re: hanging shutdowns

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

ps -ef | grep smon

kill -9 ...

Kill off smon and the rest of the oracle processes follow.

Dougie McGibbon
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 28 2006 - 09:07:13 CST