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 laterInformation 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 |