My Oracle Support Banner

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 later
Information 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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.