Configure the Oracle Instant Client to make Database Authentication and Operating System Authentication connections using ArcGIS Desktop

Summary

The (32-bit) Oracle Instant Client can be used with ArcGIS Desktop (versions 10.1 and above) to make both Database Authentication and Operating System Authentication connections to Oracle Enterprise geodatabases and to Oracle Spatial databases. The steps below describe how to configure this.

Procedure

• How To: Make Oracle database authentication connections using EZCONNECT syntax
• How To: Make Oracle database authentication connections using a Net Service Name
• How To: Make Oracle external authentication connections (OSA for Oracle) using EZCONNECT syntax
• How To: Make Oracle external authentication connections (OSA for Oracle) using a Net Service Name

Note:
The Oracle External Authentication user must already exist in the Oracle instance prior to making the Operating System Authentication connection.

The 'OPS$' prefix is required when creating the Oracle External Authentication user if the 'os_authent_prefix' initialization parameter has a value of 'OPS$' in the Oracle instance. Here is a SQL sample of how to create this user:

• Read here: How To: Create an Oracle External Authentication user