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

    TNS Connection Dropdown

    jflack

      Using SQL Developer 4.0.1.14 - 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?