RE: TNSNAMES Management

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@xxxxxxx <mailto:name.name@xxxxxxx> 

 

We deliver on our commitments

so you can deliver on yours.

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Goulet, Richard
Sent: Monday, October 20, 2008 11:57 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx 

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.

Other related posts: