Bug: ArcGIS cannot connect to an Oracle database after installing Oracle Critical Patch Update for October 2014
【相关信息】
Article ID: 43293
Bug Id: BUG-000082555
Software:
ArcGIS - ArcEditor 9.3, 9.3.1, 10
ArcGIS - ArcInfo 9.3, 9.3.1, 10
ArcGIS - ArcView 9.3, 9.3.1, 10
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2, 10.3
Platforms: N/A
【BUG描述】
It was reported that ArcGIS is no longer able to connect to Oracle after applying Oracle Critical Patch Update (CPU) for October 2014. ArcGIS connections hang, cause an error, or crash when attempting to establish a connection.
This bug applies to all ArcGIS releases connecting to an Oracle instance with the Oracle Critical Patch Update for October 2014 applied. This bug applies to geodatabase Oracle instances, connecting to an Oracle instance without a geodatabase, and/or using ArcSDE Application Servers.
【BUG原因】
Oracle’s dbms_utility package’s subprogram get_parameter_value returns the error, "ORA-01031: insufficient privileges." ArcGIS software calls the subprogram when creating a connection to the Oracle database to obtain the database parameter open_cursors value. The value is required to ensure the ArcGIS session working with the Oracle instance does not exceed the maximum number of cursors available within its session.
ArcGIS holds cursors open for frequently executed SQL statements to improve performance and scalability.
The impact of this issue introduced after installing the Critical Patch Update prevents ArcGIS from successfully establishing a connection.
For additional information on Oracle's Critical Patch Update Advisory,
please visit Oracle's website.
Article ID: 43293
Bug Id: BUG-000082555
Software:
ArcGIS - ArcEditor 9.3, 9.3.1, 10
ArcGIS - ArcInfo 9.3, 9.3.1, 10
ArcGIS - ArcView 9.3, 9.3.1, 10
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2, 10.3
Platforms: N/A
【BUG描述】
It was reported that ArcGIS is no longer able to connect to Oracle after applying Oracle Critical Patch Update (CPU) for October 2014. ArcGIS connections hang, cause an error, or crash when attempting to establish a connection.
This bug applies to all ArcGIS releases connecting to an Oracle instance with the Oracle Critical Patch Update for October 2014 applied. This bug applies to geodatabase Oracle instances, connecting to an Oracle instance without a geodatabase, and/or using ArcSDE Application Servers.
【BUG原因】
Oracle’s dbms_utility package’s subprogram get_parameter_value returns the error, "ORA-01031: insufficient privileges." ArcGIS software calls the subprogram when creating a connection to the Oracle database to obtain the database parameter open_cursors value. The value is required to ensure the ArcGIS session working with the Oracle instance does not exceed the maximum number of cursors available within its session.
ArcGIS holds cursors open for frequently executed SQL statements to improve performance and scalability.
The impact of this issue introduced after installing the Critical Patch Update prevents ArcGIS from successfully establishing a connection.
For additional information on Oracle's Critical Patch Update Advisory,
please visit Oracle's website.
1 个回复
EsriSupport
赞同来自:
ArcGIS users should not install the Oracle Critical Patch Update (CPU) for October 2014 until this issue is resolved. Customers who have already installed this patch can roll it back to restore normal operations. Alternatively, the system administrator can grant the SELECT_CATALOG_ROLE to each user that accesses the Oracle instance with ArcGIS.
Esri has contacted Oracle Technical Support (Oracle SR 3-9775575171) and requested their assistance in helping Esri resolve this issue for our mutual customers.
In the event that Oracle does not resolve this issue in their Critical Patch Update, Esri is working on alternative implementations when establishing a connection in the upcoming ArcGIS 10.3 release. Once testing is complete, the fix will be back-ported to earlier supported ArcGIS releases.
Esri will use this technical article to communicate additional information as it becomes available. Please check back periodically for status updates.
October 24, 2014 Update:
Based on Oracle's instructions, the recommendation to ensure ArcGIS applications are able to successfully connect to the Oracle instance is to explicitly grant SELECT privileges on the v$parameter view to each user or the public role.
The ArcGIS hotfix provided below does not require the elevated system privilege to allow a user to create the Oracle database connection.
Connect in SQL*Plus as the SYS user and grant SELECT on the v_$parameter table to each named user or the PUBLIC role.
SQL> GRANT SELECT ON v_$parameter TO PUBLIC;
November 13, 2014 Update:
The ArcGIS 'Oracle Critical Patch Update - October 2104' Connection Issue Patch on ArcGIS 10.2.2, all Windows and Linux setups, has been released on the support site.
November 14, 2014 Update:
The ArcGIS 'Oracle Critical Patch Update - October 2104' Connection Issue Patch on ArcGIS 10.2.1 SP1 QIP has been released on the support site.
November 24, 2014 Update:
The ArcGIS 'Oracle Critical Patch Update - October 2014' Connection Issue Patch on ArcGIS 10.1 SP1 QIP has been released on the Esri Support site.
November 26, 2014 Update:
The ArcGIS 'Oracle Critical Patch Update - October 2014' Connection Issue Patch on ArcGIS 10 SP5 has been released on the Esri Support site.
December 12, 2014 Update:
The ArcGIS 'Oracle Critical Patch Update - October 2014' Connection Issue Patch on ArcGIS 9.3.1 SP2 QIP has been released on the Esri Support site. If a patch is needed for another ArcGIS release or for the ArcSDE application server, please submit a hotfix request to Esri Technical Support.
ArcGIS 'Oracle Critical Patch Update - October 2014' Connection Issue Patch
Related Information
Created: 10/22/2014
Last Modified: 12/16/2014
【原文链接】
http://support.esri.com/en/kno ... 43293
要回复问题请先登录或注册