RE: DATABASE HANGS WITH SHUTDOWN IMMEDIATE
- From: "Josh Collier" <collier_jw@xxxxxxxxxxx>
- To: <ahmed107@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 Apr 2006 16:24:15 -0700
SMON is going to need to do the work regardless of what you do. Use locally
managed tablespaces.
Josh C.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ahmed Ullah
Sent: Thursday, April 27, 2006 3:36 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
