is there a way to use single file instead of multiple TNS name files

[pangul]

We have many databases and each have diffrent name defined for connection to databases.
Is there a way to use a single file for all homes across all machines?
I have heard about name server does that come as standard product? how is it configured?

Thanks in advance

[Kishore]

Yes, you can, simply specify the TNS Connection names of all the Databases in that file TNS file. It should work

[elintrend]

Name server will do that for you, but Oracle is giving it up.....after 8.0.5 release (I read document somewhere else)
If wrong, sorry about the info.

[denevge]

If the problem is that you have multiple ORACLE_HOME's and you just want to use 1 tnsnames.ora file.

I think you can define the variable TNS_ADMIN= ( not sure, so sorry if wrong )

Hope this helps
Gert

[marist89]

Yes, on Unix it is no problem. You create an NFS mount and mount it to all your servers. Then, create a soft link from all your $OH to your central tnsnames.ora file.

What is your platform? Do you have a common mount point?

[marist89]

Originally posted by elintrend
Name server will do that for you, but Oracle is giving it up.....after 8.0.5 release (I read document somewhere else)
If wrong, sorry about the info.

Yes, names is going away with 9i. The new method will be to use LDAP and is available in various 8.1 versions...