如何确定.net调用使用了哪个tnsnames.ora文件? [英] How can you tell which tnsnames.ora file is used by a .net call?

问题描述

我有多个版本的Oracle，并且它到处都保存了tnsnames.ora文件.较旧的文件存储在oracle下的程序文件中，而较新的文件存储在我的硬盘驱动器中的app目录下.

I have multiple versions of Oracle and it saved tnsnames.ora files all over the place. Older ones got stored in program files under oracle but newer ones got stored under an app directory in my hard drive.

我正在使用Oracle提供的.net库与.net应用程序连接，并告诉我找不到我要连接的名称.

I'm using the .net libraries provided by Oracle to connect with a .net app and it's telling me it cannot find the name I want to connect to.

我已经更新了所有可以找到的tnsnames.ora文件.有没有办法告诉我的应用程序试图使用什么tnsnames.ora连接到Oracle?

I've updated all the tnsnames.ora files I could find. Is there a way to tell what tnsnames.ora my app is trying to use to connect to Oracle with?

推荐答案

来晚了，但是我用过 Sysinternals' procmon.exe用于执行类似操作.这是我给自己的笔记:

Coming late to the party, but I've used Sysinternals' procmon.exe for doing something like this. Here are my notes to myself:

1. 启动procmon.exe
2. 文件>捕获事件以关闭捕获
3. 按下显示文件系统活动按钮(右侧的其余位置应取消设置)
4. 文件>捕获事件以开始捕获
5. 执行您要监视的活动
6. 文件>捕获事件以停止捕获
7. 工具>文件摘要，以在文件名列表中找到tnsnames.ora

1. Start procmon.exe
2. File > Capture Events to turn off capturing
3. Press the Show File System Activity button (the rest on the right should be unset)
4. File > Capture Events to start capturing
5. Perform the activity that you want monitored
6. File > Capture Events to stop capturing
7. Tools > File Summary to find tnsnames.ora in the filename list

这篇关于如何确定.net调用使用了哪个tnsnames.ora文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！