TNSnames.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TNSnames.ora

  1. #1
    Join Date
    Apr 2001
    Posts
    151

    Question

    Hi all,

    I can find tnsnames.ora (NT4.0 Oracle 8.0.5.2.1) under

    oracle_home/net80/admin and oracle_home/network/admin

    what is the different between those two.

    I have service name , when I tried to user tnsping ErpUser and it failed. But I can connect plus80 internal/password@ErpUser to connect to my prod. DB.

    Why tnsping not working? Why we have two tnsnames.ora file under different directory?

    Thank you!
    Elin@trend

  2. #2
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    In NT create a system environment variable (Start > Settings > Control Panel > System Icon > Environemt Tab...):
    TNSADMIN and set it to whatever TNSNAMES.ORA file directory you want to use.

    Variable: TNSADMIN
    Value: oracle_home/network/admin (or the other one)

    This will ensure that you are always using that particular TNSNAMES.ORA file in that dir.

    The reason that you have multiple is that there are two instals of Oracle on that PC. You can also go to the Registery all the Oracle Installs under: HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE

    Good Luck.

  3. #3
    Join Date
    Jun 2001
    Location
    Toronto
    Posts
    6

    followup

    In addition to this solution
    You can create variable like ORACLE_SID in Env. variable if two different oracle products are installed.

    Thanks
    ejaz ahmed

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