Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP.NET Change_Notification/Oracle Dependency not working 11.2.0.4.0

897991Aug 14 2014 — edited Aug 19 2014

Hello,

We've just recently upgraded our oracle server to 11.2.0.4 (and I have upgraded the Oracle client as well to match) and since then, Oracle Cache Dependency is no longer working in my ASP.NET web applications. The cache never gets invalidated (notification is never sent to the server).

I was wondering if there is a glitch with this release?

I know in past releases, both the server and client needed to match up in order to avoid problems with cache not being invalidated, but I have the same versions for both. Also in past versions, you needed to run the following script to fix such problems with dependency:

alter system set events '10867 trace name context forever, level 1';

I have tried that as well and nothing works. The same exact code I have works perfectly fine on on both 11.2.0.2 and 11.2.0.3 So I'm wondering what was changed in 11.2.0.4 in order for this no longer to work?

Any insight you can provide would be very usefull.

Thanks!

PS. I'm not pasting any code as I've mentioned above, everything works fine in 11.0.2.2 and 11.2.0.3

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2014
Added on Aug 14 2014
4 comments
1,706 views