Error: ORA-01000: maximum open cursors exceeded

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".


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.