How can you determine which tnsnames.ora file is being used by a .net call?

Question

I have several versions of Oracle, and it has saved tnsnames.ora files everywhere. Older ones are stored in program files under the oracle, but newer ones are stored in the application directory on my hard drive.

I use the .net libraries provided by Oracle to connect to the .net application, and it tells me that it cannot find the name that I want to connect to.

I updated all the tnsnames.ora files that I could find. Is there a way to tell which application tnsnames.ora is trying to use to connect to Oracle using?

Answer 1

, Sysinternals procmon.exe - . :

• procmon.exe
• > ,
• ( )
• > ,
• , .
• > ,
• > , tnsnames.ora

Answer 2

:

http://www.dba-oracle.com/t_windows_tnsnames.ora_file_location.htm

http://dbaforums.org/oracle/index.php?showtopic=2554

tnsnames.ora , , , . tnsnames.ora - , , .

Answer 3

TNS_ADMIN . , .

TNS_ADMIN , tnsnames.ora. , , ORACLE_HOME\network\admin.

Answer 4

I ran into this problem. This is the comment I introduced into my program: 'Note: The program is built using Ora 11 OracleDataAdaptor. To find the "db name", the ORACLE \ KEY_OraClient11g_home1 registry entry must have a value for TNS_ADMIN, indicating the correct directory for TNSNAMES.ORA.