Hello, I managed to get my subscription working. Here is what I have done on my test environment. My client uses oracle-instant-client 11.2.0.1. My db server is running Oracle 11.2.0.1 release. Both client and server are on Centos OS. Previously, I have client on Centos and server on Solaris. I have done quite few tests with combination of different client, server and their OS. I found that the Oracle version and the OS platform contributed to the issue that I had. As a preliminary quick test, I also ran my client on the same box where my db server was running. In my case, this worked fine. Hopefully, this will help. Cheers, sw

Hi, May I know what Oracle edition that you have? Is it Enterprise or Standard edition? Mine is standard edition. I am trying to find out if publish/subscribe is supported in standard edition.

Thanks for the reply. If I solve this issue, I will post it here.

Hello, Have you solved this issue? I am having a similar problem. I used a OCI sample code from ORACLE site. My OCI client was able to register the subscription. However, the subscription was removed from USER_CHANGE_NOTIFICATION_REGS as soon as I updated the table that is registered for subscription. And, my client callback function never got called. Btw, I used oracle client 11.2.0.1.0 and my db is running 11.2.0.1.0. The sample code was compiled on Linux Centos 5.5. I checked my user privilege and it has CHANGE_NOTIFICATION. I also check "job_queue_processes" and "dml_locks", both of them have non-zero values.