Oracle Streams Capture Process Aborts with 'ORA-04063: rule set <OWNER>.<RULESET_NAME> has errors' / ORA-01280 Fatal LogMiner Error (Doc ID 1206717.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Streams capture aborts errors similar to the following in the alert log:

krvxerpt: Errors detected in process 180, role preparer.
krvxifc: Exception 4063 raised in filter callback.
ORA-04063: rule set "STRMADMIN.RULESET$_775" has errors
krvxerpt: Errors detected in process 180, role preparer.
krvxmrs: Leaving by exception: 4063
ORA-04063: rule set "STRMADMIN.RULESET$_775" has errors
LOGMINER: session#=2, preparer MS02 pid=180 OS id=1970286 sid=25 stopped
LogMiner process death detected
ORA-04063: rule set "STRMADMIN.RULESET$_775" has errors
LOGMINER: session#=2, reader MS00 pid=175 OS id=1880170 sid=719 stopped
LOGMINER: session#=2, builder MS01 pid=179 OS id=1036348 sid=741 stopped
Sun Aug 29 10:18:47 2010
Streams CAPTURE CP01 for STREAMS_CAPTURE with pid=169, OS id=1253490 stopped
ORA-01280: Fatal LogMiner Error.

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