Hi all,

I have one client 10g server on my office computer, which I use when
the regular servers are down .I also have 10g client. Both have a
TNSNAMES.ORA, and its not clear to me that it needs two of these files
to work properly. I seem to have to update both, using the net manager,
whenever the other servers change.

Any hints here on what is the best procedure. Can I delete the client
file?

Thanks,

Dean

"dean" <deanbrown3d (AT) yahoo (DOT) com> wrote

guessing that your running windoze -- in the registry you can set TNS_ADMIN
for each oracle home to point to a common directory

++ mcs

Thanks. Looking for that key [TNS_ADMIN] in my registry comes up with
nothing though.

"dean" <deanbrown3d (AT) yahoo (DOT) com> wrote:

If you do not want to edit your registry, you can also use Environment Variables ( System ones) to set it..

TNS_ADMIN = <DRIVE:>/<OracleHomeYouWantToUse>/network/admin/