EM 12c, EM 13c: Tablespaces Full Metric Evaluation for 11.2.0.4 Databases Fails with "ORA-1000 : Maximum Open Cursors Exceeded" (Doc ID 1940500.1)

Last updated on JANUARY 02, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 to 13.1.1.0.0 [Release 12.1 to 13.1]
Information in this document applies to any platform.

Symptoms

 Metric alerts are not received for the Tablespaces Full/ Tablespaces Full (Undo) /Tablespaces Full (temp) metric collections of 11.2.0.4 target databases in 12c / 13c Cloud control.  

The details show that this metric evaluation fails with the "ORA-1000 : Maximum Open Cursors Exceeded" error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms