Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle on AIX hangs

Oracle on AIX hangs

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 26 Jan 2006 13:22:37 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C4503D40125@NT15.oneneck.corp>


Anyone else seen anything like this?  

Oracle 9.2.0.6, AIX 5.2 ML7  

Recently migrated to new server, from Oracle 8.1.7 & AIX 5.1, and since moving to the new server we've had a few instances of horrible performance where hdisk0 is pegged at 100% utilization. When this happens it takes 60 seconds just to establish a telnet connection and all Oracle sessions, as well as new connection attempts just hang indefinitely. We can't even get a "conn / as sysdba" connection so we can't get a hanganalyze or systemstate dump.  

After we killed all database server processes (not the background processes), the hdisk0 utilization dropped down to zero, but then as soon as we try to connect again, the connection attempt hangs and hdisk0 goes back to 100%. We can't even shutdown the instance since we can't connect so we have to kill it, and then the problem goes away and does not come back when the instance is restarted . . . until the next time, which may be days or weeks later. We haven't been able to identify any pattern to the occurrences yet.  

I've been all over Google and Metalink with no luck.  

Any ideas?  

Thanks,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 26 2006 - 14:22:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US