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 tnsnames.ora

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

  1. Posted by Jeff
  2. Posted by Mat

Add Your Comment