How do I correct the error:"[Manager.AppMap] Unable to complete model synchronization with storage!" caused by "ORA-01000: maximum open cursors exceeded"?

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

 Question:

    How do I correct the error:"[Manager.AppMap] Unable to complete model synchronization with storage!" caused by "ORA-01000: maximum open cursors exceeded"?

 Answer: 

    After installing or upgrading to APM 10.1 when using an Oracle database, the following error may appear in Enterprise Manager logs:

[ERROR] [Thread-ModelSynchronization] [Manager.AppMap] Unable to complete model synchronization with storage!
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT state, start_time, alert_id, vertex_id FROM appmap_states_20151221 WHERE start_time <= ? AND ? = end_time AND alert_id in (?, ?, ?, ?, ?, ?, ?, ?, ?) AND vertex_id in (?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors exceeded
; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded

    This error occurs because of a change in APM 10.1 to allow App Map to make use of a public REST API. The REST API requires an additional number of open cursors to be made available to the APM database. In addition to the open cursors consumed by the database for CEM, Oracle databases have a default value of 50 open cursors.

  To raise this value and address correct the error, run the following command on the APM Database:
  alter system set open_cursors = 1000 scope=both;

   Restart the EM to allow for the changes to take effect.

Additional Information:

   For more details regarding the REST API, see: https://docops.ca.com/ca-apm/10-1/en/integrating/api-reference-guide/apm-rest-api

Environment

Release: CEMUGD00200-10.1-Introscope to CA Application-Performance Management-Upgrade Mai
Component: