laptop and a wrench

Bug

After applying the ArcGIS 'Oracle Critical Patch Update’, ArcGIS may crash, without an Oracle error, if the open_cursor count needed by the ArcGIS session exceeds the value set by the patch.

Zuletzt veröffentlicht: January 30, 2017 ArcSDE/Enterprise Geodatabase
Bug-ID-Nummer BUG-000094265
EingereichtFebruary 18, 2016
Zuletzt geändertApril 2, 2025
Gilt fürArcSDE/Enterprise Geodatabase
Gefunden in Version10.1
StatusWill Not Be Addressed

Zusätzliche Informationen

The patch page has been updated with the information to update open_cursors. http://support.esri.com/download/2143 "The geodatabase on Oracle must be configured with open_cursors server_config parameter as described in Technical Article 000012229 after installing this patch on all ArcGIS versions." A new stored procedure is also included as part of a 10.5 geodatabase: http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/update-open-cursors.htm

Workaround

Set the geodatabase open_cursor parameter in the server_config table equal to that of the Oracle instance. For example if the Oracle instance had an open_cursor parameter of 4,000 us the following SQL to also set the geodatabase open_cursor to 4,000. SQL> insert into sde.server_config (prop_name,char_prop_value,num_prop_value) values ('OPEN_CURSORS',NULL,4000); SQL> commit;

Schritte zur Reproduzierung

Bug-ID: BUG-000094265

Software:

  • ArcSDE/Enterprise Geodatabase

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln