DOWNSTREAM ARCHIVELOG CAPTURE gets ORA-24147
(Doc ID 334352.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Exadata Express Cloud Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Oracle 10.2.0.1.0
Downstream Archivelog Capture setup
Adding positive capture ruleset to downstream archivelog capture with
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES
system generated capture ruleset is created for DML and DDL owned by SYS user
instantiate object at source
Changes
Adding a Positive Rule set to the CAPTURE process with: DBMS_STREAMS_ADM.ADD_SCHEMA_RULES
Creating a CAPTURE process using DBMS_CAPTURE_ADM.CREATE_CAPTURE using a schema in CAPTURE_USER parameter that is different from the user who owns the RULE and RULESET.
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 |
Changes |
Cause |
Solution |