laptop and a wrench

Bogue

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.

Dernière publication: January 30, 2017 ArcSDE/Enterprise Geodatabase
Numéro d’ID de bogue BUG-000094265
EnvoiFebruary 18, 2016
Dernière modificationApril 2, 2025
S’applique àArcSDE/Enterprise Geodatabase
Version trouvée10.1
StatutWill Not Be Addressed

Informations supplémentaires

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

Solution de contournement

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;

Étapes pour reproduire

ID de bogue: BUG-000094265

Logiciel:

  • ArcSDE/Enterprise Geodatabase

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement