Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS Connection Dropdown

jflackMay 2 2014 — edited May 5 2014

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?

This post has been answered by thatJeffSmith-Oracle on May 2 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 2 2014
Added on May 2 2014
3 comments
1,539 views