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.
上次发布: January 30, 2017ArcSDE/Enterprise Geodatabase
漏洞 ID 编号
BUG-000094265
已提交
February 18, 2016
上次修改时间
April 2, 2025
适用范围
ArcSDE/Enterprise Geodatabase
找到的版本
10.1
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
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
解决办法
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;