I can find tnsnames.ora (NT4.0 Oracle 220.127.116.11.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?
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.
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
In addition to this solution
You can create variable like ORACLE_SID in Env. variable if two different oracle products are installed.
Click Here to Expand Forum to Full Width