Re: Storing TNSNAMES in Microsoft Active Directory

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 23 Aug 2003 21:51:28 +0200
Message-ID: <39ffkvo0bgq5f5guudt93jdabktcp1jsts@4ax.com>

On Sat, 23 Aug 2003 12:51:44 -0500, "Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote:

>But, even Oracle Names seems like just 1 more thing that could break and
>doesn't buy you that much.

It does buy you

- a centralized tnsnames.ora
- b automatic global links between all your databases
- c faster lookup of connect strings
- d delegated administration possible if you are in a large network

>
>I know replicating tnsnames.ora all over the place might seem "old
>technology", but if your replication (not Oracle replication, but file
>system replication) of the file tnsnames.ora is setup right, this seems less
>problem-atic to me.

You are clearly wrong. NT replication is in itself intrinsically a single point of failure. You would need to have someone check on replication frequentlt.
Oracle Names works is and is not 100 percent dependent on the existence of a database with the network definition.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Aug 23 2003 - 14:51:28 CDT