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

Hi,

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.

Thanks.
LVL 1
jjozAsked:
Who is Participating?
 
HainKurtSr. System AnalystCommented:
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 :)
0
 
jjozAuthor Commented:
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.
0
 
HainKurtSr. System AnalystCommented:
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...
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
HainKurtSr. System AnalystCommented:
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

getTNS.vbs
... 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...
 
0
 
jjozAuthor Commented:
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.
0
 
HainKurtSr. System AnalystCommented:
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 :)
0
 
jjozAuthor Commented:
many thanks !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.