HowTo:  Make Oracle external authentication connections (OSA for Oracle) using EZCONNECT syntax

【解决方案】
1. Download the (32-bit) Oracle Instant Client from the ESRI Customer Care Portal, and unzip it to a location on the local ArcGIS Desktop machine. Change the name of the folder if desired.
2. Add the Oracle Instant Client path to the beginning of the existing PATH (operating system) Environment Variable. EXAMPLE: PATH=C:\OracleInstantClient_32;...
3. Create a file called 'SQLNET.ORA' inside the Oracle Instant Client directory and add this entry to the file: SQLNET.AUTHENTICATION_SERVICES = (NTS)
Setting SQLNET.AUTHENTICATION_SERVICES = (NONE) does not suffice.

4. Create an Environment Variable on the Windows operating system called 'TNS_ADMIN' that references the location of the Oracle Instant Client directory.
5. Launch ArcCatalog and make a connection using the EZCONNECT syntax and selecting the Operating System Authentication option from the drop-down (the username and password is grayed out). The EZCONNECT syntax consists of the name of the server machine where the Oracle instance resides, a forward slash, and the name of the ORACLE SID.


【其它相关参考】

1. Make Oracle database authentication connections using EZCONNECT syntax
2. How to make Oracle database authentication connections using a Net Service Name
3. How to make Oracle external authentication connections (OSA for Oracle) using a Net Service Name
4. How to create an Oracle External Authentication user

【创建及修改时间】
Created: 4/4/2014

Last Modified: 4/16/2014
【原文链接】
http://support.esri.com/en/kno ... 42394