Reputation: 231
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.
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.
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.
My goal is to use same Odp.Net files (Oracle.DataAccess.dll + some extra dependencies like oci.dll etc) in my application.
Upvotes: 1
Views: 855
Reputation: 231
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;
Upvotes: 0
Reputation: 2635
There was a bug in 11.2.0.1 database regarding change notification.
The following SQL causes Oracle to avoid the buggy code path with the older version, but you are advised to upgrade the database:
alter system set events '10867 trace name context forever, level 1';
This is not meant to be a permanent solution. You should upgrade both ODP.NET and patch the database to the latest 11.2 patchset.
Christian Shay
Oracle
Upvotes: 0
Reputation: 186678
ODP version decrypted
a.b.c.d (e.g. 2.112.3.0):
Another example: "4.100.1.0" - ODP for .Net 4.0+ and Oracle Client 10.0+ 1st version
Upvotes: 3