问题描述
谁能帮我实现ODP.Net日志记录在Windows XP计算机上?我用Google搜索,发现下面的链接,但它并没有为我工作。
Can anyone help me with enabling ODP.Net logging on a Windows XP machine? I googled and found following link but it did not work for me.
http://download.oracle.com/docs/html/E10927_01/ featConfig.htm
我设置的TraceLevel设置为63,在注册表中,但它并没有帮助
I set the "TraceLevel" setting to "63" in registry but it did not help
基本上我想捕捉所有的数据库调用从我的C#code通过日志发生。
Basically I want to capture all the database call happening from my C# code through the log.
我希望能有像SQL事件探查器用于Oracle的工具。
I wish there was a tool like "SQL Profiler" for Oracle.
推荐答案
我的故障排除与Oracle支持的一些问题时,对某些机器同样的问题。我发现,改变到输出文件的路径几次,多重启终于迫使ODP客户端开始记录。确保输出文件到您的调用应用程序的身份访问的目录。
I had the same issues on certain machines when troubleshooting some issues with Oracle Support. I found that changing the path to the output file a couple of times and multiple restarts finally forced the ODP client to start logging. Make sure that the output file is to a directory that your calling application identity has access to.
检查以下注册表项。这是从我的机器.NET4和11.2的例子。
Check the following things in the registry keys. Here is an example from my machine for .net4 and 11.2.
HKEY_LOCAL_MACHINE \ SOFTWARE \ Wow6432Node \ ORACLE \ ODP.NET \ 4.112.2.0
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\ODP.NET\4.112.2.0
- 在32位或64位(正确的节点)
- 更改跟踪级别设置为8(或64我想完整记录)
- 更改跟踪选项= 1
- 设置有效的TraceFileName
这篇关于启用ODP.Net记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!