Dblink on Physical standby - ORA-16000
Last updated on SEPTEMBER 05, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 184.108.40.206 - Release: 10.2 to 11.2
Information in this document applies to any platform.
Steps to access data via dblink on physical standby in dataguard environment.
From 11g MRP will run when physical standby in opened in read only. We the problem will come when we access the data via dblink. The below note will give the solution to overcome the issue.
NOTE : For 10g standby open the database in read only first to use dblink.
SQL> select * from emp@link_emp_chicago;
select * from emp@link_emp_chicago
ERROR at line 1:
ORA-16000: database open for read-only access
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms