Bug:  Typing an Oracle tnsname in the Instance field of the Database Connection dialog box changes to pre-10.1 syntax after saving connection

相关信息
Article ID: 40576
Bug Id: NIM085231
Software:
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描述
When making a direct connection from ArcGIS 10.1 to an Oracle database or geodatabase using the tnsname, pre-10.1 syntax is appended to the tnsname after clicking OK on the Database Connection dialog box.

For example, if the tnsname of the Oracle database is myora, type myora in the Instance text box of the Database Connection dialog box. After clicking OK and the Database Connection properties dialog box re-opens, the text in the Instance text box has changed to 'sde:oracle11g:myora'.

Unfortunately, this leads people to believe that they should type the old syntax in the Instance text box. However, if sde:oracle11g:<tnsname> is typed, 'sde:oracle' gets appended to it.
For example, if sde:oracle11g:myora is typed in the Instance text box, ArcGIS tries to connect to 'sde:oracle$sde:oracle11g:myora'.

BUG原因
At 10.1, the Database Connection dialog box is simplified, so that the instance parameter only requires minimal information such as the tnsname or Oracle Easy Connect string for the database.

To allow upgraded systems to continue using older Spatial Database Connection files (*.sde), ArcGIS passes the older syntax when making a direct connection to Oracle.
已邀请:

易智瑞技术支持

赞同来自:

解决方案
When connecting to Oracle databases or enterprise geodatabases in Oracle using ArcGIS for Desktop version 10.1 remember the following:


  1. Don't use the traditional direct connection string.
  2. Either type the Oracle TNS name in the Instance text box, or if the Oracle instance is configured for EZCONNECT, provide the Oracle Easy Connect string.


创建及修改时间
Created: 9/27/2012

Last Modified: 11/17/2014
原文链接
http://support.esri.com/en/kno ... 40576

要回复问题请先登录注册