HOW TO

Perform a direct connect to Oracle without a tnsnames.ora file

Last Published: October 12, 2021

Summary

Establishing a direct connect connection from ArcGIS to an Oracle instance requires the Oracle client to be present on the machine where the application is performing the connection. In addition, when providing the connection parameters, the user must provide the information that specifies which Oracle instance for the connection.

Historically, the primary method users have used for defining which Oracle instance the connection will reference is by placing the name of an entry from the tnsnames.ora file after the user's password.

Instructions provided describe an example of how to establish a connection without using a reference from the tnsnames.ora file.

Procedure

To establish a direct connect connection without referencing the Oracle file tnsnames.ora, set the following syntax after the user's password:

<password>@<server_name>:<port>/<instance_name>

For example, in SQL*Plus, to connect to another instance on a machine named HARP and the Oracle sid named geodb, execute the following command:

SQL> CONNECT sde/sde@harp:1521/geodb
Connected.

With ArcGIS, to connect to the same Oracle instance in the prior example, provide the same parameters after the password, @harp:1521/geodb.

Article ID: 000010842

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

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options