Below is the end of my own tnsnames.ora located on my PC. There is a common network tnsnames.ora on a network share located on my 'R' drive. The network version has all the permanent databases defined in it. I can add any temporary or new test servers to my copy of tnsnames.ora and still get to all the permanent entries when ever I need to. Works great!
R. Smith test.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = someserver) (Port = 1521) ) ) (CONNECT_DATA = (SID=test) ) ) ifile=r:\tnsnames.ora -----Original Message----- Sent: Thursday, February 27, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Use Oracle Names. Easy to setup/maintain. never touch a client config again. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ine.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: shared tnsnames.ora 02/27/2003 12:56 PM Please respond to ORACLE-L I am looking for info on how you support a large number of PCs (200+) and keep each ones tnsnames.ora file in sync. It seems that most people do not touch them. Some try to modify them and when new databases are created, the tnsnames.ora files must be changes as well. It seems to be that a shared tnsnames.ora file on a network drive may work. I remember a thread awhile back about the order of resolution (home directory, then OH/network/admin .....). Again, I am asking about people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers. I have just started to think about this and posted here before I started my MetaLink search. TIA for any info. JF John Fedock "K" Line America, Inc. www.kline.com ( 804.327.4444 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).