Summary
Instructions provided describe the steps to make Oracle database authentication connections using the Oracle Instant Client and EZCONNECT syntax. See Knowledge Base article 42269 for more information.
Procedure
- 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.
EXAMPLE:
C:\OracleInstantClient_32 - Add the Oracle Instant Client path to the beginning of the existing PATH (operating system) Environment Variable.
EXAMPLE:
PATH=C:\OracleInstantClient_32;...
- Launch ArcCatalog and make a connection using the EZCONNECT syntax and selecting the Database Authentication option from the drop-down, then specify a username and password.
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.
![[O-Image]](https://webapps-cdn.esri.com/CDN/support-site/technical-articles-images/000012023/00N39000003LL2C-0EM39000000wdTs.png)