TNSnames.ora

[elintrend]

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!

[khussain]

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.

[ejaz_68]

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