RE: TNSNAMES Management

Understood, the point with AD is 1) getting the AD admin to let you in to maintain the information and 2) the AD admin messing with our data. Definitely a BAD thing to do.

Dick Goulet
Senior Oracle DBA
PAREXEL International
978.313.3426
 information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nuno Souto Sent: Tuesday, October 21, 2008 10:52 AM Cc: oracle-l_at_freelists.org
Subject: Re: TNSNAMES Management

Goulet, Richard wrote,on my timestamp of 21/10/2008 12:57 AM:

> I'm looking for what people use today now that Onames has
become
> history. This is a multi location within and outside the US and
> managing TNSNAMES.ORA files is well a PAIN. I'm especially interested

> in anyone who has or is using TnsManager from Andrew Barry
> (_http://www.shutdownabort.com/tnsmanager/_), especially with regard
to
> support.

Shared Wintel drive, specific folder with tnsnames.ora. Master copy in central site, gets replicated to all the distributed file servers with this shared drive. Workstations using two-tier c/s are configured to look for tnsnames in shared drive. Three-tier app servers simply have tnsnames pushed via ftp every time a refresh is needed.

Quick and above all: much, much simpler and easier to maintain than all that OID rigmarole. Particularly in an AD environment. (Yes, I *am* aware OID can talk with ad: that is *not* the point)

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l