Re: tnsnames.ora file maintenance

From: Jared Still <>
Date: Tue, 3 Mar 2009 10:46:54 -0800
Message-ID: <>

On Tue, Mar 3, 2009 at 10:25 AM, Eugene Pipko <>wrote:

> 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.

If you must use tnsnames.ora files, something like rsync comes to mind.

Personally I prefer to not use tnsname.ora unless absolutely necessary.

Some apps (SAP, Oracle Apps) require one.

Oracle OID is preferable IMO for oracle name resolution, as it is centrally administered.

Oracle Names was the pre 10g method for centralizing names resolution.

We are using OID, with an Oracle Names Proxy (uses OID as source) for legacy reasons.

OID is much simpler to administer than Oracle Names.

Even for apps that require a tnsnames.ora file, sqlnet.ora can be adjusted to also search LDAP directories (OID) so that the only entries in the tnsnames.ora
files are those required by the local app.

That said, there may be good reason to use tnsnames.ora. You just need to use an effective means to administer it.. used to use rsync with tnsnames.ora files - they may still, I don't know.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Original text of this message