My Oracle Support Banner

Application Connections to Data Guard Fail with ORA-16000 (Doc ID 2890353.1)

Last updated on AUGUST 19, 2022

Applies to:

Universal Connection Pool - Version 12.1.0.2.0 and later
JDBC - 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


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