Change Notification not received from Oracle database 11.2.0.1 to client 11.2.0.3

                                      

Server version

Client version 11.2.0.1.0 11.2.0.2.0 11.2.0.2.0 + fix 11.2.0.3.0 11.2.0.1.0 works fails works fails 11.2.0.2.0 fails  works fails fails 11.2.0.2.0 + fix works fails works works 11.2.0.3.0 fails works works

Solution

Apply patches or upgrade versions as applicable to obtain a working combination.

A workaround can be used to bypass the authentication phase, which is where the problem behavior occurs.  To do that, set the following event in the database:

  

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