Database Change Notification -Ports Can Not Be Reused (Doc ID 745680.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 10.2.0.2 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On 10.2.0.2.0 in Production:
When attempting to invoke method unregisterDatabaseChangeNotification(registerationId) , it is not possible to reuse the ports on the next run of the application. How can be reclaimed previously
used ports that are unavailable.
Registration fails even with the default port NTF_DEFAULT_TCP_PORT = 47632.

The following error occurs:

"java.sql.SQLException: ORA-29970: Specified registration id does not exist"


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