Where can I find the Tnsnames ora file?

By default, the tnsnames. ora file is located in the ORACLE_HOME/network/admin directory.

How do I get Tnsnames in SQL Developer?


  1. Start SQL Developer and go to Tools > Preferences;
  2. In the Preferences option, expand the Database component, click on Advanced, and under the “Tnsnames Directory”, browse to the folder where your tnsnames.ora file is located;
  3. Restart SQL Developer;
  4. Now in SQL Developer select Connections and click New Connection;

Where is Tnsnames ora file in SQL Developer?

The tnsnames. ora plain text file is located on both the client and the server. Typically, this file is located under the oracle_home\network\admin directory. You can make changes to the file using any text editor.

What is an ora file?

What Is an ORA File? A file with the ORA file extension could be an OpenRaster graphics file. This format, designed as an alternative to Adobe’s PSD format, supports multiple layers, layer effects, blending options, paths, adjustment layers, text, saved selections, and more.

What is a TNS name in Oracle?

A TNS (Transparent Network Substrate) name is the name of the entry in tnsnames.ora file which is kept in $ORACLE_HOME/network/admin. This file contains the information which is used by the system to connect to oracle database. Using this a client can fetch server associated information transparently.

How do I open Tnsnames Ora file in Windows?


  1. Begin by clicking on Start > All Programs > Accessories.
  2. Right-click on Notepad and select Run as administrator.
  3. In Notepad, click on File > Open.
  4. Locate the folder where you installed the Oracle Client (ORACLE_HOME).
  5. If files named tnsnames.

What is TNS file in SQL Developer?

Tnsnames. ora [DOCS] is a configuration file for SQL*Net that describes the network service names for the databases in your organization. Basically, it tells Oracle applications how to find your databases. This post is just a quick overview on how to get SQL Developer to ‘see’ this file and define a connection.

Where is Tnsnames Ora in SQL Developer?

SQL Developer looks for tnsnames….ora files in the following locations:

  1. your USER Home directory.
  2. $ORACLE_HOME\network\admin — assumes you have a client installed.
  3. OS Environment Variable value for TNS_ADMIN.
  4. Registry entry for TNS_ADMIN.
  5. The location you specified in the preferences.