Datamart Load Fails with Error "ORA-00604: error occurred at recursive SQL level ORA-16000: database open for read-only access" When Pointed To Agile Active Data Guard Schema (Doc ID 1317230.1)

Last updated on APRIL 11, 2016

Applies to:

Oracle Agile Product Lifecycle Management Datamart - Version 3.2.0.1 to 3.2.0.2 [Release 3.2.0]
Information in this document applies to any platform.

Symptoms

On : 3.2.0.1 version, Datamart Load Fails when Pointed to Agile Active Data Guard Schema with


ERROR
-----------------------
"ORA-00604: error occurred at recursive SQL level ORA-16000: database open for read-only access"


STEPS
-----------------------
Point ODM/ADM schema to an active data guard source and execute the ETL


Cause

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