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?