Global Tnsnames.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Global Tnsnames.ora

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    Post

    Folks
    Im just wondering can we have a global tnsnames.ora file
    for all databases on network--like DNS entry for hosts file
    What i mean is for every changes on SID in development
    i have to go to every developer to modify tnsnames.ora
    is there anyway where all users in network can have one tnsnames.ora on server.
    Tamil,Pando,Halo could u pls advice on this
    Thanks
    sat

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Although I wasn't asked, I will still answer your question.

    Sure, you can have a global tnsnames.ora file. Create the tnsnames.ora entry on a common disk and create soft links to it in each developers environment.

    Or, why not install the Oracle client on a common disk?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2000
    Location
    *
    Posts
    37
    We have a common tnsnames.ora file on the network. As each developer/user logs in a script executes that checks to see if the tnsnames.ora file on their hard drive is older then the one on the network drive. If it is older it's replaced with the new one.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    another option is names server, you need some reading before set it up though. the other options are easier

Posting Permissions

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


Click Here to Expand Forum to Full Width