Use Tnsnames.Ora in Oracle SQL Developer

Use tnsnames.ora in Oracle SQL Developer

• In SQLDeveloper browse Tools --> Preferences, as shown in below image.
  
  
  
  
  
• In the Preferences options expand Database --> select Advanced --> under "Tnsnames Directory" --> Browse the directory where tnsnames.ora present.
  
• Then click on Ok,
  as shown in below diagram.
  
  tnsnames.ora available at Drive:\oracle\product\10x.x.x\client_x\NETWORK\ADMIN
  
  
  

Now you can connect via the TNSnames options.

How to set tnsnames.ora location for SQL Developer in Windows 10

The sequence of checks you mentioned is correct. To see what the tool is using there's 2 choices

1 - In a worksheet type "show tns"

SQL> show tns
TNS Lookup locations
--------------------

Location used:
-------------
    /Users/klrice

Available TNS Entries
---------------------
SQL> 

2 - Also in the worksheet issue this command.

setloglevel oracle.dbtools.raptor.utils INFO

Blog post with details here : http://krisrice.io/2008-04-16-it-seems-to-come-up-often-that-some/

tns_names.ora file not showing in pl/sql developer

Create an environment variable named TNS_ADMIN that points to the directory of the tnsnames.ora file you wish to use. Installing another Oracle product with its own home can often confuse clients using tnsnames.

Oracle TNS names not showing when adding new connection to SQL Developer

SQL Developer will look in the following location in this order for a tnsnames.ora file

1. $HOME/.tnsnames.ora
2. $TNS_ADMIN/tnsnames.ora
3. TNS_ADMIN lookup key in the registry
4. /etc/tnsnames.ora ( non-windows )
5. $ORACLE_HOME/network/admin/tnsnames.ora
6. LocalMachine\SOFTWARE\ORACLE\ORACLE_HOME_KEY
7. LocalMachine\SOFTWARE\ORACLE\ORACLE_HOME

To see which one SQL Developer is using, issue the command show tns in the worksheet

If your tnsnames.ora file is not getting recognized, use the following procedure:

1. Define an environmental variable called TNS_ADMIN to point to the folder that contains your tnsnames.ora file.

   In Windows, this is done by navigating to Control Panel > System > Advanced system settings > Environment Variables...

   In Linux, define the TNS_ADMIN variable in the .profile file in your home directory.

2. Confirm the os is recognizing this environmental variable

   From the Windows command line:
   echo %TNS_ADMIN%

   From linux:
   echo $TNS_ADMIN

3. Restart SQL Developer

4. Now in SQL Developer right click on Connections and select New Connection.... Select TNS as connection type in the drop down box. Your entries from tnsnames.ora should now display here.

---

Related Topics