RE: DATABASE HANGS WITH SHUTDOWN IMMEDIATE

From: Josh Collier <collier_jw_at_comcast.net>
Date: Thu, 27 Apr 2006 16:24:15 -0700
Message-Id: <20060427232419.4EDA0308EE5@turing.freelists.org>

SMON is going to need to do the work regardless of what you do. Use locally managed tablespaces.  

Josh C.

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ahmed Ullah
Sent: Thursday, April 27, 2006 3:36 PM
To: oracle-l_at_freelists.org
Subject: DATABASE HANGS WITH SHUTDOWN IMMEDIATE

Hello all:  

We have Oracle 9.2.0.5 database ( single Note RAC ). There were some heavy batch jobs running which cuased the db hang ( only sys connection was working ).  

We tried to bring down the database after cleaning all sessions. It did not go down with SHUTDOWN IMMEDIATE. We had to abort it. I tried to bring down the DB three times with SHUTDOWN IMMEDIATE it never went down.  

SMON was trying to cleanup the used extents ( Metalink Note - 1076161.6 ) as we could see in the alert log file - Waiting for smon to disable tx recovery.  

SQL> select count(block#) from fet$;  

COUNT(BLOCK#)

---

           38  

fet$ - free extents  

SQL> select count(block#) from uet$;  

COUNT(BLOCK#)

---

        52905  

uet$ - used extents  

We can share the alert log and system level 10 trace files if anyone wants. These traces were generated when db hung.  

Appreciate your help.  

Thanks,  

-ahmed  

---

"If we knew what it was we were doing, it wouldn't be called research, would it?" --Albert Einstein  

---

New Yahoo! Messenger with Voice. Call
<http://us.rd.yahoo.com/mail_us/taglines/postman5/*http://us.rd.yahoo.com/evt=39 666/*http://messenger.yahoo.com> regular phones from your PC and save big.

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

Received on Thu Apr 27 2006 - 18:24:15 CDT