ORA-04067: Not Executed, Rule Set "SYS.RULESET$_XXXX" Does Not Exist
Sign in

ORA-04067: not executed, rule set "SYS.RULESET$_XXXX" does not exist

Error During start of capture process. Capture dies with following error message in alert log.

Error

*******************

LOGMINER: Begin mining logfile for session 101 thread 1 sequence 96795, /mob_arch/archCRMTRFP/crmtrfp_arch_1_654707213_96795.arc Tue Feb 14 01:31:44 2012 krvxerpt: Errors detected in process 147, role preparer. krvxifc: Exception 4067 raised in filter callback. Errors in file /crmdb/oracle11g/base/diag/rdbms/strmob/STRMOB/trace/STRMOB_ms02_9822424.trc: ORA-04067: not executed, rule set "SYS.RULESET$_5960" does not exist krvxerpt: Errors detected in process 147, role preparer. krvxmrs: Leaving by exception: 4067

************************ ************************

Solution:

DECLARE
rs_name VARCHAR2(64); -- Variable to hold rule set name
BEGIN
SELECT RULE_SET_OWNER||'.'||RULE_SET_NAME
INTO rs_name
FROM DBA_CAPTURE
WHERE CAPTURE_NAME='<CAPTURE_NAME>';
DBMS_RULE_ADM.GRANT_OBJECT_PRIVILEGE(
privilege => SYS.DBMS_RULE_ADM.EXECUTE_ON_RULE_SET,
object_name => rs_name,
grantee => '<STRM_USER>);
END;

start_blog_img