HowTo:  Create Operating System (OS) Authentication for Oracle with Direct Connect

相关信息
Article ID: 40652
Software:
ArcSDE 10.1
ArcGIS for Desktop Advanced 10.1
ArcGIS for Desktop Standard 10.1
Platforms:
Windows XP, Server 2003, Vista, Server 2008, Windows 7, Windows 8, Server 2012

问题描述
The instructions provided describe how to create Operating System (OS) Authentication when connecting directly from ArcGIS clients to geodatabases in Oracle. Only OS Authentication or External Authentication is supported when establishing a Direct Connection from an ArcGIS client to geodatabases in Oracle.
已邀请:

易智瑞技术支持

赞同来自:

解决方案
1.Follow Oracle’s documentation for setting up OS Authentication; refer to the following references provided by Oracle Metalink       
       For Windows: WIN: Setup O/S Authentication [ID 60634.1] 
       For UNIX: UNIX: OS Authentication on Oracle Server [ID 18088.1]2. After setting up the externally identified user (External OS User), test and verify that the External OS User can successfully log into the Oracle database in SQL*Plus before creating a direct connection within ArcCatalog.
3. Add a Database Connection from ArcCatalog to enable users to log into ArcSDE using a Direct Connection. 
   A. In ArcCatalog, click Add Database Connection. 
   B. From the Database Connection dialog box, select one of the following connection options: 
Option 1 Database Platform: 
      Oracle Instance: Oracle 
      TNS name Authentication
      Type: Operating system authentication 

 
Option 2 
Database Platform: Oracle 
Instance: Select one of the following Oracle Easy Connect strings: 

• <The name of the Oracle server>/<Oracle service name or ID> 

For example, if Oracle is installed on 'myserver' and 'myosvc' is the Oracle service name, type the following: 
myserver/myosvc

• <The name of the Oracle server>:<Oracle port number>/<Oracle service name or ID> 

For example, if Oracle is installed on 'myserver,' is listening on port '60000' and 'myosvc' is the Oracle service name, type the following: 
myserver:60000/myosvc
Authentication Type: Operating system authentication 


创建及修改时间
Created: 11/7/2012

Last Modified: 10/15/2013
原文链接
http://support.esri.com/en/kno ... 40652

要回复问题请先登录注册