TNS Connection Dropdown

jflack May 2, 2014 8:24 PM

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?

1. Re: TNS Connection Dropdown

thatJeffSmith-Oracle May 2, 2014 8:45 PM (in response to jflack)

Prob b/c you have multiple tns* files in that directory - we read in more than just tnsnames.ora. Do you have any backup copies of said file?
Like Show 0 Likes(0)

Actions
2. Re: TNS Connection Dropdown

jflack May 5, 2014 1:14 PM (in response to thatJeffSmith-Oracle)

As a matter of fact, I DID have a tnsnames.ora.bak in the folder with tnsnames.ora, So I deleted it - and you are exactly right, the extra entries disappeared.

One remaining question - WHY do you read other files besides the REAL tnsnames.ora?
Like Show 0 Likes(0)

Actions
3. Re: TNS Connection Dropdown

thatJeffSmith-Oracle May 5, 2014 2:19 PM (in response to jflack)

Good question - because SQL*Plus does. Someone opened a bug that we weren't following that behavior, so now we do.
Like Show 0 Likes(0)

Actions

Go to original post