What is tnsnames.ora file?
Is there a way to use just
one tnsnames.ora file on a network, or must it reside in the oracle home
directory. I am looking for an NT registry setting or something that
will allow me to point all of our locally installed sqlnet products to
a centrally located tnsnames.ora
Ans1:
You need a registry key TNS_ADMIN
pointing to the correct directory. Depending on the complexity of your
environment, you could also use Oracle Names, in this case you need a sqlnet.ora
only.
Ans2:
Have you thought about oracle
names...
It is such a great tool, I
don't know why more people don't use it. With the use
of implicit DB links, it is wonderful thing to use when comparing environments.
And updates are seemless to the users.
But you could use the TNS_ADMIN
variable too.