Database Change Notifications Are Not Received From Server (Doc ID 436585.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version 10.2.0.1.0 to 10.2.0.3
Information in this document applies to any platform.
***Checked for relevance on 18-Nov-2013***

Symptoms

When using the feature ODP.Net Database Change Notifications (using a simple example - see below) the notifications are not received by the client.

When checking USER_CHANGE_NOTIFICATION_REGS

The notifications are successfully registered on the object

eg. SELECT regid, table_name, callback FROM user_change_notification_regs;

However, the Client contains multiple Network Interface Cards (NIC). The IP address shown in the CALLBACK column is for another NIC or VMWare adapter than the primary NIC used for notifications.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms