tnsnames.ora file maintenance

From: Eugene Pipko <>
Date: Tue, 3 Mar 2009 10:25:54 -0800
Message-ID: <>

Hi all,
I wonder if you can share how you manage your tnsnames.ora file. I currently have about a dozen database servers and each one has tnsnames.ora locally. Whenever IP, server name, ... gets changed I have to remember to update that file accordingly on every box. I am not even mentioning user machines and the fact that not every box needs to have a full set of connections on it.


Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail.

Received on Tue Mar 03 2009 - 12:25:54 CST

Original text of this message