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

Posted on 2011-04-19
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 ? []
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
    LVL 51

    Accepted Solution

    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

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

    and put this in startup :)
    LVL 1

    Author Comment

    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 51

    Expert Comment

    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...
    LVL 51

    Assisted Solution

    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 ""

    and run it like

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

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

    Author Comment

    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 51

    Assisted Solution

    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 :)
    LVL 1

    Author Closing Comment

    many thanks !

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    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

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now