Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2003

    Unanswered: alternative solution to tnsnames.ora

    We have about 30 Oracle servers, more than 50 users. I would like to know if it is intersting to think
    to avoid using local tnsnames.ora and use other solution (NB: we don't have LDAP in our company).

    Any suggestions ? recommandation ?

  2. #2
    Join Date
    Oct 2002
    Create an automounted filesystem that automouts to all your oracle servers. Put a common tnsnames.ora file on that filesystem. On each of your servers create a soft link from $OH/network/admin/tnsnames.ora to the automouted filesystem.

  3. #3
    Join Date
    Jan 2004
    Scottsdale, AZ
    You may also need to set the tns_admin variable to point to the automounted file systems, on your oracle clients, and each person must have access to that drive.

    (Marist, did you go to marist college in poughkeepsie?)
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  4. #4
    Join Date
    Feb 2003


    See the Oracle Documentation under topic

    * Oracle Names Server

  5. #5
    Join Date
    Sep 2003
    We are using the TNS_ADMIN variable to look up the database connection information. It works fine. All you need to do is the following:

    1) Place the tnsnames.ora and sqlnet.ora files in central direcory

    2) Add a environment variable TNS_ADMIN=\\hostname\share to the client (you may also set the variable in the registry if you use windows)

    3) tnsping your database. This will show you the use of the path defined within TNS_ADMIN

    Description here:

    Kind Regards,


  6. #6
    Join Date
    Sep 2004

    Talking Why not ldap or names

    We are currently using nameserver (4 of them) with a region database (only 1). We have about 17 servers and 100 databases. We add to the names server using net 8 assistant, pointing to the primary names server. Then within 60 seconds the other three names servers automatically get the modifications. If for some reason the region database is down, it is only a factor if you want central administration (update once poulate many). Our standard desktops sqlnet.ora points to all 4 names servers. The only down side is names server is gone in 10g. So we are looking at how to migrate to oracle ldap. Their is not a lot out their on how to's.

    Mel Reichman

  7. #7
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    * goal: How to Set up Oracle Internet Directory 2.1.1 for Names Resolution
    * fact: Oracle Server - Enterprise Edition 8.1.7
    * fact: Oracle Internet Directory 2.1.1
    * fact: LDAP
    fix: Setting Up Oracle Internet Directory to do Names Resolution
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts