Oracle on AIX hangs

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 26 Jan 2006 13:22:37 -0700

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.

Other related posts: