ORA-01000: maximum open cursors

Error

Retrieving Snapshot Target Data (1) - 14:48:59
Error: Snapshot Get Target Data routine failed. ORA-01000: maximum open cursors
exceeded
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

Cause

Maximum open cursors limit exhausted.

Solution

If the value of the database parameter "open_cursors" is not set sufficiently high, then it causes the "ORA-01000: maximum open cursors exceeded" error.

SQL> alter  system set open_cursors=600 scope=both sid='*';

If you are using SPFILE to set database parameter, you can change this value by doing the following while logged into SQL*Plus as SYSDBA:

SQL> alter system set open_cursors=<new_value> scope=both;

In case you are not using SPFILE and are instead using init<SID>.ora file, you should change the value for open_cursors by adding a line to that file or changing any existing setting to look like:

OR

If open_cursors values is much enough then involve your developer to validate the code and ask them to close the cursor after processing statements which were left not closed.