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

Summary

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.

Procedure

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