EM 13c: Intermittent Alerts from Enterprise Manager 13c Cloud Control: Failed To Connect To ASM Instance. ORA-01000: Maximum Open Cursors Exceeded
(Doc ID 2753929.1)
Last updated on AUGUST 19, 2022
Applies to:
Enterprise Manager for Oracle Database - Version 13.4.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
Enterprise Manager (EM) 13.4 Cloud Control shows intermittent alerts on an ASM target:
Target type=Automatic Storage Management
Target name=+ASM1_<SID>.<DOMAIN_NAME>
Categories=Availability
Message=Failed to connect to ASM instance. ORA-01000: maximum open cursors exceeded
Severity=Fatal
Target name=+ASM1_<SID>.<DOMAIN_NAME>
Categories=Availability
Message=Failed to connect to ASM instance. ORA-01000: maximum open cursors exceeded
Severity=Fatal
Trying to manually colelct the Response metric on the same target, will fail with the same error:
emctl getmetric agent +ASM1_<SID>.<DOMAIN_NAME>,osm_instance,Response
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
Status,oraerr
0,ORA-01000: maximum open cursors exceeded
After the EM agent is restarted, the error is no longer seen for a while.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |