Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RESOLVED - Multiple versions of TNSNAMES.ORA ?

RESOLVED - Multiple versions of TNSNAMES.ORA ?

From: Suri, Deepak <>
Date: Fri, 29 Sep 2000 18:25:19 -0400
Message-Id: <>

Just to let you know what I did ...

I copied the exisitng tnsnames.ora to my another directory (in this case my home directory) and appended the customised connection string parameters.

Then just set the "TNS_ADMIN" environment variable to (in this case) $HOME and export it.

...and pooof, it works !

-----Original Message-----
From: Suri, Deepak [] Sent: Friday, September 29, 2000 5:55 PM To: Multiple recipients of list ORACLE-L Subject: Multiple versions of TNSNAMES.ORA ?

Something a DBA told me once ...  

"In a UNIX client machine, it is possible to create an equivalent of TNSNAMES.ORA in $HOME that over-rides (or adds to) the one in $ORACLE_HOME/network/admin"  

Is this statement True or False ? If true can you please point me towards more information regarding this ...  


8.204.6080 [Internal]
203.459.6080 [External]

Please Note: The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. Oxford Health Plans, Inc. is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.  


Please see the official ORACLE-L FAQ:

Author: Suri, Deepak

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Sep 29 2000 - 17:25:19 CDT

Original text of this message