Application Connections to Data Guard Fail with ORA-16000
(Doc ID 2890353.1)
Last updated on AUGUST 31, 2023
Applies to:
Universal Connection Pool - Version 12.1.0.2.0 and laterJDBC - Version 12.1.0.1.0 and later
Information in this document applies to any platform.
Symptoms
Some JDBC connections connection to DataGuard are going to to the standby database, causing application startup to fail with error:
java.sql.SQLException: ORA-16000: database or pluggable database open for read-only access
ORA-06512: at "<NAME>", line 928
ORA-06512: at "<NAME>", line 911
ORA-06512: at line 1
The application connect string is:
jdbc:oracle:thin:@(DESCRIPTION=(TRANSPORT_CONNECT_TIMEOUT=3000)(CONNECT_TIMEOUT=120)(RETRY_COUNT=20)(RETRY_DELAY=3)(FAILOVER=ON)
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=) (PORT=<PORT>))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=<PORT>))(LOAD_BALANCE=YES)(FAILOVER=ON))
(CONNECT_DATA=(SERVICE_NAME=)))
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |