SQL Developer – Use tnsnames.ora file

This is a short tutorial on showing you how to setup SQL developer to use your tnsnames.ora file for new connections.

SQL Developer

In this example I am using SQL Developer Release 3.

Step 1

While in SQL Developer, browse to Tools, then to Preferences.

SQL Developer Tools

Step 2

Then expand the Database component, click on Advanced, and under the “Tnsnames Directory”, browse to the folder where your tnsnames.ora file is located. And your done! Now new connections or current connections you can connect via the TNSnames options.

SQL Developer Tnsnames

You may also like:

Creating a SQL view/record for PSQuery Have you every been annoyed by creating a query in PIA, using PSQuery? The easier way to do it is to create a new record, turn that into a view, and t...
  • Jeff

    Simple enough. So when I create a new connection I should see a list of the definitions in the tnsnames.oca file? I don’t. Perhaps I need to select the TNS type of connection? I tried that too.

  • Mat

    Thanks a lot.