SQL Developer – Use tnsnames.ora file

oracle-sql-developer

SQL Developer

This is a short tutorial on showing you how to setup SQL developer to use your tnsnames.ora file for new connections. 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

Incoming search terms:

  • sql developer tnsnames ora
  • sql developer tnsnames
  • sqldeveloper tnsnames ora
  • sql developer tnsnames ora location
  • tnsnames sql developer