Geek Answers Handbook

What is a deal with oracle connection identifiers separated by period

I was interested in this for a while, but since it is not so much, I left it in the column "mysterious wizard".

It seems to me that there is some kind of connection between the connection identifier, such as ABC and ABC.DEFG, and I do not quite understand what it is.

For example, the machine that I was setting up just now, I had problems using the ED2 identifier, although in my tnsnames file I clearly had

EDC2 = (....)

This was copied and pasted from another computer that worked perfectly. However, tnsping EDC2 could not be resolved until I changed it to say

 EDC2.WORLD = (...)

after which EDC2 began to work. What's going on here?

+4
source share
1 answer

The TNS alias in the tnsnames.ora file interacts with the parameter

 NAMES.DEFAULT_DOMAIN

in the sqlnet.ora file. If, for example, NAMES.DEFAULT_DOMAIN set to WORLD, then when you try to connect to an alias without a domain, the sqlnet.ora file tells Oracle to automatically add the domain before searching in the tnsnames.ora file. If you try to connect to an alias with a domain, NAMES.DEFAULT_DOMAIN ignored.

My general preference / suggestion is to set NAMES.DEFAULT_DOMAIN to WORLD in sqlnet.ora and specify EDC2.WORLD in the tnsnames.ora file. Thus, the connection identifier EDC2 and EDC2.WORLD will work: the first one will be changed to the last due to the DEFAULT_DOMAIN parameter.

+7
source

More articles:


All Articles