My Oracle Support Banner

CCG Snapshot Error - ORA-01000: Maximum Open Cursors (Doc ID 1543991.1)

Last updated on OCTOBER 10, 2023

Applies to:

Oracle Configuration Controls Governor - Version 5.5.1 and later
Information in this document applies to any platform.


On : 5.5.1 version, Integra Apps

When attempting to run a CCG Snapshot job, the job ends with an error and the following error is shown in multiple places in the log file:

Retrieving Snapshot Target Data (1) - 14:48:59
Error: Snapshot Get Target Data routine failed. ORA-01000: maximum open cursors
ORA-06512: at "SYS.DBMS_SYS_SQL", line 909
ORA-06512: at "SYS.DBMS_SQL", line 39
Running: CREATE TABLE snapshot_temp_data_764_1

The issue can be reproduced at will with the following steps:
1. Attempt to run a Snapshot Definition Job.
2. See that it fails with an error and the error message reported above is shown in multiple places in the log file.

The issue has the following business impact:
Due to this issue, users cannot successfully run a Snapshot Definition Job.


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

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