My Oracle Support Banner

JDBC Reports ORA-12506 When Using Continuous Query Notification (CQN) on ATP-S (Doc ID 3007734.1)

Last updated on MARCH 03, 2024

Applies to:

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


To connect to database hosted at ATP-S Cloud infrastructure, java applications commonly use Oracle Wallet and use TCPS protocol with mutual TLS authentication.

These applications typically set the wallet location in the OracleDataSource properties and create the database connection from the OracleDataSource using JDBC 19.22.
When the application tries to register a datachange notification using this connection and pass CLIENT_INITIATED flag, it expects to receive the change notifications from ATP-S database. However, the change notification is not received.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.