Use tnsnames.ora in Oracle SQL Developer

sql oracle tnsnames oracle-sqldeveloper
Peter Lang picture Peter Lang · Jan 7, 2010 · Viewed 346k times · Source

I am evaluating Oracle SQL Developer.

My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections.

Oracle SQL Developer Soars mentions, that if

you have Oracle client software and a tnsnames.ora file already installed on your machine, Oracle SQL Developer will automatically populate the Connections navigator from the net service names defined in tnsnames.ora.

I also tried to set my TNS_ADMIN environment variable, but after restarting SQL Developer there are still no connections displayed.

Any ideas?
Anyone successfully working with SQL Developer and tnsnames.ora?

Answer

Chandra Sekhar picture Chandra Sekhar · Jul 23, 2012
  • In SQLDeveloper browse Tools --> Preferences, as shown in below image.

    SQLDeveloper access preferences


  • 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

    SQLDeveloper update tnsnames directory

Now you can connect via the TNSnames options.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
Oracle SQL: Update a table with data from another table

Table 1: id name desc ----------------------- 1 a abc 2 b def 3 c adf Table 2: id name desc ----------------------- 1 x 123 2 y 345 In oracle SQL, how do I run an sql update query that can update Table 1 with Table 2's name and desc using …

Read More