Don't panic!

 

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.

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.



About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.