- Introduction Connect to Oracle from ArcGIS—ArcGIS Pro | Documentation Connect to Oracle from ArcGIS—ArcGIS Server | Documentation for ArcGIS Enterprise Connect to Oracle from ArcGIS—ArcMap | Documentation - Important ArcMap/ArcCatalog - use 32-bits Oracle Client Pro/Portal/Server - use the 64-bits Oracle Client - Tips - use SQL Plus to test the connection !!! - Oracle releases the updates for the Oracle Client in Jan / Apr / Jul / Oct to resolved bugs and security vulnerabilities, hence is import that you keep the Oracle Client updated. - It is recommended that you use an Oracle Client Version that matches the Oracle Database Version, e.g. if Oracle Database is 19c then use the latest version of the Oracle Instant Client 19c or if using the Oracle Full Client then make sure to install the latest patchset. - After you install the Oracle Instant Client and you set the Windows System PATH Environment Variable to include the Oracle Instant Client folder then you must close/open ArcGIS Desktop (ArcMap/ArcCatalog), ArcGIS Pro and stop/start the ArcGIS Server Windows Service, only then ArcGIS will know about the changes in the PATH Environment Variable for the Oracle Instant Client folder. - You also need to install the Oracle Instant Client on your ArcGIS Enterprise machine for ArcGIS Server to be able to connect to the Oracle Geodatabase, and as mentioned above you must stop/start the ArcGIS Server Windows Service, only then ArcGIS Server will know about the changes in the PATH Environment Variable for the Oracle Instant Client folder. - Oracle Instant Client Instant Client for Microsoft Windows (x64) 64-bit (oracle.com) Instant Client for Windows 32-bit (oracle.com) Video https://youtu.be/ni_j8Rfp0J0 - Oracle 19c Instant Client !!!video has no audio!!! Download and install the correct Visual Studio Redistributable from Microsoft. Instant Client 21 requires the Visual Studio 2017 Redistributable. Instant Client 19 requires the Visual Studio 2017 redistributable. Instant Client 18 and 12.2 require the Visual Studio 2013 redistributable. Instant Client 12.1 requires the Visual Studio 2010 redistributable. - Oracle Full Client Video https://youtu.be/d7hRCootD9Y - Oracle 19c Full Client !!! video has no audio!!! --------------------------------------------------------------- --Oracle Client Enable Windows Authentication Protocol SQLNET.AUTHENTICATION_SERVICES = (NTS) /* --cmd window, verify PATH variable /* ORA-12638: credential retrieval failed Workaround if using Oracle Instant Client 19.15 add these lines to sqlnet.ora on client machine: SQLNET.AUTHENTICATION_SERVICES= (NTS) SQLNET.NO_NTLM=FALSE */ --Note: Oracle Database Administrator needs to create a login with external authentication in the database for the user to be able to connect via Windows Authentication. |