Oracle Database Discussions

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!

Database Change Notification Registrations Getting Deleted

Andy DufresneMar 31 2015 — edited Mar 31 2015

We are facing an issue where we see database change notification registrations getting deleted. We periodically (every 5 mins) execute the below query

select count(ucnr.REGID) as REGS from USER_CHANGE_NOTIFICATION_REGS ucnr where ucnr.REGID = ?

and at times it returns 0. The registrations are made by java (jdbc). What we have seen is that the issue is seen on servers where multiple database operations like restore, upgrade are being executed in parallel. An entry in USER_CHANGE_NOTIFICATION_REGS is not found for schema1 while restore or upgrades are performed on schema2 or schema3 on the same database server.

Oracle database version is 11.2.0.4. Do you know if there already open issues related to this or do you have suggestions on troubleshooting this?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2015

Added on Mar 31 2015

#general-database-discussions

0 comments

237 views