Google it ....

Wednesday, August 31, 2022

ORA-01000: maximum open cursors exceeded oracle.sysman.emSDK.emd.comm.MetricGetException: ORA-01000: maximum open cursors exceeded

Sometimes we are not getting alerts from OEM(Oracle Enterprise Manager) and if we try to check some metric values it is throwing error:
ORA-01000: maximum open cursors exceeded oracle.sysman.emSDK.emd.comm.MetricGetException: ORA-01000: maximum open cursors exceeded 
I Found interesting Doc about this issue on metalink: 
ORA-01000: MAXIMUM OPEN CURSORS EXCEEDED (Doc ID 2751726.1).
It seems it is Bug 31542357 - Use of setTimeToLiveTimeout causes leak of cursors and ORA-01000 eventually 
Solution: 
For 13.4 Cloud Control the patch will be included in the 13.4 RU7 and newer patches. 
The work around from development is: On agent side add this property in emd.properties and restart the agent. The following property will kill the seesion on db and avoid the cursor leak.
SqlConnectionCache._TimeToLiveTimeout=0

No comments:

Post a Comment