DevOps, CI/CD and Automation

Hello all,

I am not sure if this the right place to post this thread. My apology in advance if this is the wrong place to post it.

I am trying to understand on how ORACLE Continuous Query Notification works. I used the sample code from the ORACLE site:

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28395/oci10new.htm#LNOCI13111

I created employees and departments table under my schema.

At first, I received an error ("ORA-24912: Listener thread failed. Failed to get IP address of host." ) when I executed the sample code. The error was returned in OCISubscriptionRegister()

To work around the error above, I set the client IP address through calling OCIAttrSet, and the client can register successfully. I can see the registration entry in USER_CHANGE_NOTIFICATION_REGS.

I tried to trigger the notification by updating employee table as recommended. However, the client never received the notification.

My sample application uses oracle instant client 11.2.0.2.0 to connect to the server.

My database server is running oracle 11.2.0.1.0

The sample application was running on Centos 5.5.

The sample application user has already had CHANGE_NOTIFICATION privilege. The database server's DML_LOCKS and JOB_QUEUE_PROCESSES are also set to non zero values. However, the notification never reached to the client or never got generated on the server side.

Is there a way to check if the server created notification or tried to send it out to the client?


Thanks,


swen