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