My Oracle Support Banner

Dblink on Physical standby - ORA-16000 (Doc ID 1296288.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.1 [Release 10.2 to 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Goal


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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.