ORA-4063 Is Reported After Dropping Negative Prop.Ruleset (Doc ID 730911.1)

Last updated on SEPTEMBER 10, 2015

Applies to:

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

Symptoms

-- Problem Statement:
RDBMS 10.2.0.2.0
Streams

Dropped a Streams negative propagation ruleset while propagation was running, now receiving the
following errors in qmn slave:

ORA-04063: STRMADMIN.STREAMS_QUEUE_GINA_CP has errors


The propagation cannot be stopped due to this error message.
Using the steps in <Note 368237.1> for validating the queue did not help.

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