11g: 30K of open file descriptors per oracle process to oraus.msb
Date: Tue, 13 Oct 2009 07:54:48 +0200
Message-ID: <9b46ac490910122254q7616ed96tb96091f0b8be7f31_at_mail.gmail.com>
Hi,
your feedback/experience sharing is much appreciated. Platform is oracle
database 11.2 on linux x86_64.
SR to oracle support has been made but no feedback yet that helps me any
further.
Last weekend when doing tests where packaged plsql stored procedures were
being called many times by java code running on jboss side we saw following
errormessage in the server.log file:
...java.sql.SQLException: ORA-00600: internal error code, arguments:
[pesldl01_Get_Object: shm_open: errno 24 errmsg Too many open fil], [], [],
[], [], [], [], [], [], [], [], []
then when we checked on the oracle (rac) serverside we noticed that lsof was reporting more than 120000 lines pointing to oraus.msb like following:
COMMAND PID USER FD TYPE DEVICE SIZE
NODE NAME
oracle *2780* oracle 27r REG 253,24 1074176
9404528 /opt/11.2.0/db_1/rdbms/mesg/oraus.msb
..repeated 30000 times
oracle *4976* oracle 10r REG 253,24 1074176
9404528 /opt/11.2.0/db_1/rdbms/mesg/oraus.msb
..repeated 30000 times
so each oracle shadow process was holding 30K of open filedescriptors to the
same file if I understand correctly, which looks insane to me.
I am trying to find the trigger that causes this behaviour leading to outages, which is not in line with oracle's high availability motto.
Regards,
Andre
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 13 2009 - 00:54:48 CDT