Frequently asked question

Can Oracle Instant Client be set up to use a tnsnames.ora file when connecting to Oracle from an ArcGIS 10.1 or newer client?

Last Published: April 25, 2020

Answer

Yes, as long as Oracle supports the use of a tnsnames.ora file with the Oracle Instant Client, it can be used when connecting from ArcGIS clients to an Oracle database. See the Oracle documentation links in the Related Information section below.

If both the 64- and 32-bit Oracle Instant Client are installed on the same machine, configure the TNS_ADMIN variable or registry setting to point both clients to the same tnsnames.ora file.

Article ID: 000011850

Software:
  • ArcGIS Server

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options