Cry about...
Oracle Troubleshooting

ORA-01000: Maximum open cursors exceeded

Symptom:

The Oracle error:

ORA-01000: Maximum open cursors exceeded

Cause

Oracle indicates that this error is usually encountered in application programs, but could occur at the database level. I have only encountered it in application programs. The error indicates that Oracle has reached the set limit for open cursors allowed for the session.

Possible Remedies:

• Identify if there is a bug in the application program meaning that some cursors do not get closed properly.

• Increase the OPEN_CURSORS parameter in the Oracle initialisation file.