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".
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
- Legacy Products
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App