ERROR

ORA-01000: maximum open cursors exceeded

Last Published: April 25, 2020

Error Message

After using ArcMap to pan, zoom, and redraw for some time on a layer that has been defined using Oracle Spatial, ArcMap may return the following error:

"ORA-01000: maximum open cursors exceeded".

Cause

The Oracle initialization parameter OPEN_CURSORS determines the maximum number of cursors per user, and this has been exceeded.

There is a known issue where, if the Oracle Spatial layer has an SRID defined, ArcSDE does not release the cursor on a query to determine the SRID of the layer.

Solution or Workaround

If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and restart Oracle.

This has been resolved in ArcSDE 8.3.

    Article ID:000005807

    Software:
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic

    Esri Community

    Search for related information

    Training

    Find training related to this topic

    ArcGIS Ideas

    Explore ideas and give feedback