TNSNAMES.ORA 1

[ADB1]

Could somebody please explain how tnsnames.ora file is used on the different platforms below and where it should be stored?

Windows98
WindowsXP
Windows2000

Thanks,

Adam.

 

[bookouri]

it is stored depending on how you structure your oracle installation. Normally, its going to be in something like d:\oracle\ora92\network\admin, or /u01/ora92/network/admin. I dont think there's a "correct" location that varies from platform to platform. If you take the defaults when you install Oracle just look for that /network/admin directory and you should find it there. The installation should also have configured the tnsnames file to allow you to connect to the local database you installed. If you want to connect to a remote database you must add the connection information to the tnsnames file for that remote database. Look at the lines that oracle put in tnsnames for your local database, then copy them inside the tnsnames file, modify the name and connection values and you should be able to connect to the report database. To test your connection(s) use the tnsping utility. It works kind of like ping, but you tnsping your database name.

You can get more "technical" explanations if you look around. Go to

http://www.orafaq.net,

thats a good place to start.

 

[ADB1]

Thanks bookouri.

Adam.

 

[sem]

The "correct" location is defined by TNS_ADMIN environment (registry) variable. If it's not set, the default value is %ORACLE_HOME%\NETWORK\ADMIN (%ORACLE_HOME%\NET80\ADMIN for 8.0).

Regards, Dima

http://seminihin.narod.ru