Managing TNSNAMES.ora file

Hi,

I'm looking for a way to have a single copy of tnsnames.ora available for all my clients although the entire software is installed localy for each client.

Is there a way to use an  include file inside tnsnames.ora,
or a parallel to unix link file ( my clients are running windows95) ?
efratlAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

petevdbCommented:
Two possibilities :

1. I think you can install tnsnames.ora on a network disk and in the register of Oracle change a parameter. I don't have the manual for me but I am sure that that has to work.

2. Create the tnsnames file on a network disk and install a shortcut on the local machines.

To include filenames in the tnsnames.ora is not possible, I believe (I have heard of it btw).

Hope this helps.

Peter.
0
efratlAuthor Commented:
You cannot use a shortcut on the local machine because the
file name changes (to tns...~.LNK) since it is a link file
and oracle does not know to look for that name.

I also cannot find a registery entry to make oracle look
for that file somewhere else other than ORACLE_HOME/network/admin


0
ferchoCommented:
Try this:
* change the NET20 key in the registry (usually
  C:\ORAWIN95\NETWORK) to a share directory.
* copy all the files in the old NET20 directory to this new
  directory (ie, copy the installation of SQL*Net).

Hope this helps!

0
efratlAuthor Commented:
I've tries it but it still does not work.
Oracle seems to ignore the NET20 regitery entry.

When tring to connect it takes some time and
after a while it fails with an error "could not resolve service
name." (for the same service name appeared in the tnsnames.ora
when it was localy.

0
xiaodongCommented:
This is a undocumented method on Window environment but common on UNIX platform.
Here is what you need to do:
set a machine-wide environment variable called tns_admin and make its value equal to any mapped network drive on which you have the tnsnames.ora.
For example, if you put your tnsnames.ora on a network drive mapped as F: on all client machine, then set tns_admin=f:\
Make sure all client machine have that network drive mapped, this is usually done by using a logon script.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.