is there a way to use single file instead of multiple TNS name files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: is there a way to use single file instead of multiple TNS name files

  1. #1
    Join Date
    Mar 2001
    Posts
    61
    We have many databases and each have diffrent name defined for connection to databases.
    Is there a way to use a single file for all homes across all machines?
    I have heard about name server does that come as standard product? how is it configured?

    Thanks in advance

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Yes, you can, simply specify the TNS Connection names of all the Databases in that file TNS file. It should work
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Apr 2001
    Posts
    151
    Name server will do that for you, but Oracle is giving it up.....after 8.0.5 release (I read document somewhere else)
    If wrong, sorry about the info.
    Elin@trend

  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    If the problem is that you have multiple ORACLE_HOME's and you just want to use 1 tnsnames.ora file.

    I think you can define the variable TNS_ADMIN= ( not sure, so sorry if wrong )

    Hope this helps
    Gert

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yes, on Unix it is no problem. You create an NFS mount and mount it to all your servers. Then, create a soft link from all your $OH to your central tnsnames.ora file.

    What is your platform? Do you have a common mount point?
    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."

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by elintrend
    Name server will do that for you, but Oracle is giving it up.....after 8.0.5 release (I read document somewhere else)
    If wrong, sorry about the info.
    Yes, names is going away with 9i. The new method will be to use LDAP and is available in various 8.1 versions...
    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."

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