Odp.Net-取决于客户端和服务器 [英] Odp.Net - Depending on the client and server

问题描述

我从理论上有疑问. 我的应用程序使用Odp.Net.我将Oracle.DataAccess.dll版本2.112.3.0添加为参考文件. 我正在使用Odp.Net来查询数据库并注册查询通知. 在每台计算机上，我从

I have question from theory. My application uses Odp.Net. I add as reference file Oracle.DataAccess.dll version 2.112.3.0. I am using Odp.Net to query database and to registry query notifications. On each computer i install ODAC 11.2 Release 5 (11.2.0.3.20) from http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html.

我想知道我的Odp.Net版本，Oracle客户端版本(可以在客户端计算机上安装)和Oracle服务器版本之间有什么依赖性.

I would like to know what dependencies are between my Odp.Net version, Oracle Client version (which can be installed on client machine) and Oracle Server Version.

问题是我注册查询通知后，可以在USER_CHANGE_NOTIFICATION_REGS表中看到行.但是几秒钟后，该通知将被取消注册并消失.我读到这与版本问题有关，但是我不明白我该怎么办.

The problem is that after I register query notification I can see row in USER_CHANGE_NOTIFICATION_REGS table. But after few seconds this notification is unregistered and dissapear. I read that this is connected with version problem, but i cant understand what i have to do.

我的目标是在我的应用程序中使用相同的Odp.Net文件(Oracle.DataAccess.dll +一些额外的依赖项，例如oci.dll等).

My goal is to use same Odp.Net files (Oracle.DataAccess.dll + some extra dependencies like oci.dll etc) in my application.

推荐答案

已解决 Oracle服务器版本11.2.0.1.0和11.2.0.2.0有一个错误.如果客户端处于其他版本的注册事件，则它将在第一次更改数据库后自动取消注册.为了解决这个问题，我不得不写持久性命令: 永远更改系统设置事件="10867跟踪名称上下文"，级别1，COMMENT ="komentarz" SCOPE = SPFILE;

Resolved Oracle server version 11.2.0.1.0 and 11.2.0.2.0 has a bug. If client in other version register event it will eb automatically unregistered after first database change. To resolve it i had to wirte persistant command: alter system set event=’10867 trace name context forever, level 1, COMMENT =’komentarz’ SCOPE=SPFILE;

这篇关于Odp.Net-取决于客户端和服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！