DOWNSTREAM ARCHIVELOG CAPTURE gets ORA-24147

(Doc ID 334352.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 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

start seeing the following errors in alert on CAPTURE site:
krvxerpt: Errors detected in process <process#> , role preparer.
<timestamp>
krvxmrs: Leaving by exception: 4067
<timestamp>
Errors in file <directory/...<parallel slave trace file>
ORA-04067: not executed, rule set "<sys.rule_set_name>" does not exist
logminer errors with ORa-1280 and Capture aborts

no problems occur if not adding any RULE

Verified issue with RDA Report
Verified issue with alert log: "alert.log" of Archivelog Capture site:

Tue Sep 13 14:48:27 2005
ALTER DATABASE FORCE LOGGING command is waiting for existing direct writes to finish. This may take
a long time.
Completed: ALTER DATABASE FORCE LOGGING
Tue Sep 13 15:50:14 2005
Errors in file d:\oracle\product\10.2.0\admin\gundam\bdump\gundam_q003_1640.trc:
ORA-24147: rule STREAMS_ADMIN.NEKTON52 does not exist
ORA-06512: at "SYS.DBMS_RULE_ADM", line 243
ORA-06512: at line 1
Tue Sep 13 15:59:02 2005
Streams CAPTURE C001 with pid=44, OS id=1560 stopped

Verified issue with QMN trace file Archivelog Capture Site:

kwqavqueue : STREAMS_CAPTURE_Q
    kwqaadqrs: error 24147 during add rule
    KSV 24147 error in slave process
    *** 2005-09-13 15:50:14.124
    ORA-24147: rule STREAMS_ADMIN.NEKTON52 does not exist
    ORA-06512: at "SYS.DBMS_RULE_ADM", line 243
    ORA-06512: at line 1
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-24147: rule STREAMS_ADMIN.NEKTON52 does not exist
    ORA-06512: at "SYS.DBMS_RULE_ADM", line 243
    ORA-06512: at line 1

Verified issue with ALERT at CAPTURE site:

in alert on CAPTURE site:

krvxerpt: Errors detected in process <process#> , role preparer.
        <timestamp>
        krvxmrs: Leaving by exception: 4067
        <timestamp>
        Errors in file <directory/...<parallel slave trace file>
        ORA-04067: not executed, rule set "<sys.rule_set_name>" does not exist
        logminer errors with ORa-1280 and Capture aborts

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

	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