RE: tnsnames.ora file maintenance
Date: Tue, 3 Mar 2009 16:13:16 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F24E546DD_at_US-BOS-MX011.na.pxl.int>
Don't forget you need an LDAP.ORA file as well. Example:
DIRECTORY_SERVERS=(<server1>:3838, <server2>:3838)
DEFAULT_ADMIN_CONTEXT=""
DIRECTORY_SERVER_TYPE=OID
Dick Goulet
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar
Sent: Tuesday, March 03, 2009 3:56 PM
Cc: 'oracle-l_at_freelists.org'
Subject: Re: tnsnames.ora file maintenance
Since it works as ldap you just say in SQLNET.ORA:
NAMES.DIRECTORY_PATH= (TNSNAMES,LDAP)
This way, if there is no tnsnames.ora or the name is not in
tnsnames.ora, sqlnet will try the LDAP.
This gives you the best of two worlds, including the ability to put in
the local tnsnames.ora only the entries you want to override or test
instead of all the entries.
Adar Yechiel
Rechovot, Israel
Sais, Gene wrote:
I prefer to set the TNS_ADMIN variable to a common directory. If someone wants to use their own tnsnames, they can delete the TNS_ADMIN environment variable. Otherwise, everyone shares the same tnsnames.ora file. The tnsnames.ora file gets updated infrequently and when it does, it gets distributed to the desktops upon login.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 03 2009 - 15:13:16 CST