Several TNS connection
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Several TNS connection

  1. #1
    Join Date
    Nov 2000
    Posts
    416

    Question

    My computer is a mess, I have several TNSNAMES.ORA, SQLNET.ORA , How can I know the sql*plus or TOAAD program use which of them? Any way to know that ?

    Does OEM use TNSNAMES.ORA as well ??

    I can't connect to oracle servers.


  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking


    If you have several files, just look at them all and decide which of them is the MOST accurate and delete the remainder.
    OR, you can combine the BEST of each and delete after that. It is not important WHICH tnsnames is being used, but it IS important that it have the correct connection parameters. So, just look at the files and compare them to the others and then clean them up. No biggie.

    also, Toad will use whatever tsnnames file you have in there. It won't matter if you change/update/edit one of the files as long as the connect string remain the same.

    OEM uses tnsnames as well.

    - Magnus

  3. #3
    Join Date
    Nov 2000
    Posts
    416
    and after I removed the bad ones and keep only one TNSNAMES.ORA should it be in a specific directory or is only should ne in the PATH variable ?

  4. #4
    Join Date
    Apr 2001
    Posts
    37
    Set the TNS_ADMIN environment variable to point to the directory with
    "good" Sql*Net/Net8 configuration files, then all programs will use them.
    inosov
    Brainbench MVP for Oracle DBA

  5. #5
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Red face


    Oh ...
    Well it should remain in the Net80 directory.

    NT is something like:
    D:\orant\NET80

    Unix is something like:
    /u01/app/oracle/product/8.0.6/network/admin

    is that what you were looking for?
    - Magnus

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