RE: TNSNAMES Management
Date: Mon, 20 Oct 2008 11:56:22 -0500
Message-ID: <785A4E1EF4D9E745BAC909B7941BEC009BF27F@usplm201.amer.corp.eds.com>
Well, I have written a pl/sql function that generates the TNSNAMES file,
it needs to be run as a DBA and you have to create the
$ORACLE_HOME/network/admin directory, but it works rather well. It uses
a dblink to a central database that has a table with all the info of all
the databases and a table that says which database should be included in
the tnsnames of each server... it's a bit boring to set up, but once
it's up an running it's just a call to a pl/sql procedure to modify the
data. I've also created an APEX interface for this package... perhaps
you can take your time and do it as well... in the long run it saves a
LOT of time.
Regards.
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
ITO Arias 1851
Ciudad Autonoma de Buenos Aires (C1429DXC)
Argentina
Tel: +54 11 4704-3132
E-mail: guillermo.bort_at_eds.com <mailto:name.name_at_eds.com>
We deliver on our commitments
so you can deliver on yours.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Richard
Sent: Monday, October 20, 2008 11:57 AM
To: oracle-l_at_freelists.org
Subject: TNSNAMES Management
Folks,
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/ <http://www.shutdownabort.com/tnsmanager/> ), especially with regard to support.
Dick Goulet
Senior Oracle DBA
PAREXEL International
2 Federal St
Billerica, MA 01821
978.313.3426
Richard.Goulet_at_PAREXEL.COM
The 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 20 2008 - 11:56:22 CDT