RE: TNSNAMES Management
Date: Tue, 21 Oct 2008 09:57:11 -0400
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.
Senior Oracle DBA
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.
[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
> 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
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-lReceived on Tue Oct 21 2008 - 08:57:11 CDT