2018-07-04

Oracle SQL Developer Showing Duplicate/Multiple DB Alias

If Oracle SQL Developer is listing multiple network alias (TNS alias) for a DB, check in your "default tnsnames location" for multiple tnsnames* files.

Oracle SQL Developer joins the entries of all files matching tnsnames*

In my case I had two files tnsnames.ora and tnsnames.ora_OLD in the same directory.
(Some of the alias did not work, because they came from tnsnames.ora_OLD)


I hope it helps.

No comments :

Post a Comment