3 Replies Latest reply on May 5, 2014 2:19 PM by thatJeffSmith-Oracle

    TNS Connection Dropdown


      Using SQL Developer - but I've seen this in other versions.  When I create a new connection, or edit an existing one with Connection Type TNS, and drop down the list for Network Alias, sometimes I see more than one alias with the same name.  There is only one entry with this name in my TNSNAMES.ORA file.  I only have one TNSNAMES.ORA file and it is referenced via the TNS_ADMIN environment variable.


      Odder still, sometimes selecting one of these aliases works, but another will give me an error like ORA-01034 or a TNS error.


      Not a problem, but still - can someone explain what is happening here?