My Oracle Support Banner

Application Continuity in Oracle Cloud DBaas environment or Oracle 19C (Doc ID 2779963.1)

Last updated on OCTOBER 31, 2022

Applies to:

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

Goal

A Dataguard active/passive cluster is set up.  The purpose is to automatically use the active node, whichever that is at the time.
However,  a steady stream of ORA-16000 errors is produced:

java.sql.SQLException: ORA-16000: database or pluggable database open for read-only access
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:227)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:60)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:911)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3833)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1344)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3918)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3898)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)

Is there a document for configuring Application Continuity in Oracle Cloud DBaas environment or Oracle 19, specifically on how to create the service for the connection?
 

Solution

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
Goal
Solution
References


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