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,
[...]
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.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center