Query with multiple dblinks in ADG / read-only database fails with ORA-16000
(Doc ID 2462936.1)
Last updated on JUNE 15, 2022
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2 to 12.1]
Information in this document applies to any platform.
In an active Data Guard (ADG) database, execution of a select statement using multiple database links, for example:
select * from table@dblink1
select * from table@dblink2
select * from table@dblink3;
fails with the following error:
ORA-16000: database or pluggable database open for read-only access
*Cause: The database or pluggable database was opened for read-only access.
Attempts to modify the database using DML or DDL statements generate this error.
*Action: In order to modify the database or pluggable database, it must first be shut down and reopened for read/write access.
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