Implementing Oracle Internet Directory to end manual TNSNAMES.ora change and deployment woes

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11

I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using varioous Oracle DB vesion 9i up to v11g
usually I send email for all of the users to manually copy and update the TNSNAMES.ora

so I wonder If Implementing this Oracle Internet Directory is the proper way to do it ? [http://www.oracle.com/technetwork/middleware/id-mgmt/overview/index-082035.html]
1. is it free ?
2. what is the prerequisite and the limitations ?
3. can I use it for both Oracle Server in WIndows Server and Unix install ?

my understanding is that this OID is like DNS to the computer systems.

Any kind of comments and help would be greatly appreciated.

Question by:jjoz
  • 4
  • 3
LVL 61

Accepted Solution

HainKurt earned 2000 total points
ID: 35429950
what about writing a small app/script that connect to a secure ftp site and replaces the tnsnames.ora?
it maybe a small bat file like this

ftp xxx.xxx.xxx.xxx
lcd c:\oracle\....\admin
get ora\tnsnames.ora

and put this in startup :)

Author Comment

ID: 35430117
well, most of the clients are using Windows XP and some of them Windows Server, so I wonder If I enable or implement such feature then it would be the real solution in the TNSNAMES.ora woes.

but thanks for your suggestion Kurt.
LVL 61

Expert Comment

ID: 35430127
wait wait :) the suggestion above is not feasible? looks easy to me instead of buying a huge product and installing and configuring and changing all your applications... just 3 lines of code in a bat file and put them in startup :) or call it from your application... plus you need a ftp server :) to host the last ora file...
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

LVL 61

Assisted Solution

HainKurt earned 2000 total points
ID: 35430141
what about creating an asp page that connect to a db and pulls all your tns settings and sends to client?
then on client machines you need a script like this

... some code here to create HTTP object
get "http://domain.com/tnsnames.asp"

and run it like

getTNS.vbs > c:\oracle\...\admin\tnsnames.ora

this one requires you host a web site with one asp page...

Author Comment

ID: 35430146
oh... "lcd" command doesn't work on Windows XP Kurt :-)
well if the OID is expensive product then the only way is to get the file copied over from the FTP site like you suggested.
LVL 61

Assisted Solution

HainKurt earned 2000 total points
ID: 35430170
lcd work under ftp

similar to cd but meaning "change local drive"
you can use cd before running ftp command
or use lcd inside ftp to change the local drive...

ftp site maybe a good solution, tell users that if they get TNS error, go to ftp site and get updated tns file :)

Author Closing Comment

ID: 35622770
many thanks !

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question