What is Tnsnames Ora file in Oracle?

The tnsnames. ora file is a configuration file that contains network service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses. A net service name is an alias mapped to a database network address contained in a connect descriptor.

Table of Contents

Where is Tnsnames Ora file in Oracle?

0\client_1\network\admin . If you have both 32- and 64-bit Oracle clients installed, be sure to add the TNSnames. ora file to each of the directories. Note: you can find the path to your Oracle client’s root folder by searching your C:\ drive for *\network\admin\* in Windows Explorer.

How do I use Tnsnames Ora file?

Hint.

Start SQL Developer and go to Tools > Preferences;
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;
Restart SQL Developer;
Now in SQL Developer select Connections and click New Connection;

Where does Tnsnames Ora save files?

Typically, the default location of the file tnsnames. ora is \NETWORK\ADMIN\. Save and close the tnsnames. ora file.

How can I update Tnsnames Ora file?

Updating the tnsnames. ora files

From the Oracle Home, open the file tnsnames. ora. Typically, the default location of the file tnsnames. ora is \NETWORK\ADMIN\.
Edit the entry in tnsnames.ora as follows: Replace HOST=machine_name. with HOST=virtual_IP_address.
Save and close the tnsnames. ora file.

How do I export Tnsnames Ora?

ora file to a directory:

Start Oracle Net Manager.
If the tnsnames.
Choose Command > Directory > Export Net Service Names from the menu bar.
Click Next.
Select the network domain whose net service names you want to export, and then click Next.
Select the net service names from the list to export, and then click Next.