oracle - How can you tell which tnsnames.ora file is used by a .net call? -


I have several versions of Oracle and this tnsnames.ora files have been saved throughout the place. Old people were stored in program files under Oracle, but the new ones were stored under the app directory in my hard drive.

I am using .NET libraries provided by Oracle to connect to the .NET app and it is telling me that it can not detect the name that I want to connect to .

I have updated all the tnsnames.ora files that I could get. Is there a way to find out if my app is trying to use to connect to Oracle?

The party is coming late, but I use procmon.exe to do this way Have done it.

  • File> Capture Event
  • File Press the System Activity Show button (the rest should not be unset)
  • Press> Capture Event to capture
  • File> Capture events to monitor
  • Tools> File summary to prevent capturing
  • Li>
  • tnsnames.ora
  • in the filename list

    Comments