Error: ORA-01000: maximum open cursors exceeded
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.