Hi,
The Enterprise manager of our production 10.2.0.4 database is shutting down intermittently with the following errors in the "emagent.trc" file;
SQL = "OCIServerAttach"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=c1-hd03)(PORT=1521)
)(CONNECT_DATA=(SID=center)))
2010-06-13 09:04:47 Thread-31773 ERROR vpxoci: Error while trying to retrieve text for error ORA
-12157
2010-06-13 09:04:51 Thread-264310 ERROR fetchlets.healthCheck: GIM-00104: Health check failed to
connect to instance.
GIM-00090: OS-dependent operation:open failed with status: 24
GIM-00091: OS failure message: Too many open files
GIM-00092: OS failure occurred at: sskgmsmr_7
2010-06-13 09:04:51 Thread-264310 ERROR engine: [oracle_database,center,health_check] : nmeegd_
GetMetricData failed : Instance Health Check initialization failed due to one of the following c
auses: the owner of the EM agent process is not same as the owner of the Oracle instance process
es; the owner of the EM agent process is not part of the dba group; or the database version is n
ot 10g (10.1.0.2) and above.
2010-06-13 09:05:02 Thread-31773 WARN vpxoci: OCI Error -- ErrorCode(12157): Error while trying
to retrieve text for error ORA-12157
It has been identified as a bug in the Oracle metalink ID 368612.1, and one workaround has been provided in the metalink note, but it did not resolve the issue.
Any help in this regard will be appreciated.
Thanks!