Return
-
Title
Large number of open cursors and sessions caused by Oracle agent with SQL PI -
Description
Large number of open cursors and sessions were detected on an Oracle Instance monitored by SQL PI. These sessions' user account matches the Oracle agent service account user name and machine name matches the FglAM (Agent Manager).
Found multiple instances of ORA-01001: invalid cursor and ORA-01000: maximum open cursors exceeded errors in the DB_Oracle_RAC_Instance agent logs.
ERROR [Oracle Sampler_147 [Thu Apr 29 07:41:29 EDT 2021]] com.dell.dsgi.spi.common.utils.logger.LogUtils - BaseSampler.java:119:com.dell.dsgi.spi.engine.base.olap.sample.BaseSampler.sampleAndAnalyze(): Error during sampling query
java.sql.SQLException: Failed to execute SQL:
[...]
Caused by: java.sql.SQLException: ORA-01001: invalid cursor
[...]
Caused by: Error : 1001, Position : 0, Sql = SELECT SES.sid,
[...] -
Cause
This issue has been identified as FOG-872 and affects Oracle Cartridge 5.9.4.10 through 5.9.7.20. -
Resolution
WORKAROUND
Contact Quest Support to get a hotfix.
STATUS
Defect FOG-872 was fixed in the 6.0.0.10 and higher releases of the Oracle cartridge.
-
Defect ID
FOG-872