This is in continuance with my question posted at the end of threadID = 691223. DBMS Scheduler error Today also I received the following error in my scheduler:
ERROR=ORA-24155: rule CPM_GS.CH_RU_3_01082012080123 not in rule set CPM_GS.SCHED_RULESET$16020ORA-06512: at "SYS.DBMS_ISCHED", line 3867 ORA-06512: at "SYS.DBMS_ISCHED", line 1340 ORA-06512: at "SYS.DBMS_SCHEDULER", line 1257 ORA-06512: at "CPM_GS.PKG_LOAD_PROD_CREDITS_MAIN", line 148
As indicated in my message in threadID 691223, there seems to be no relation between CH_RU_3_01082012080123 AND SCHED_RULESET$16020 in DBA_SCHEDULER_CHAIN_RULES, DBA_SCHEDULER_CHAINS, DBA_RULE_SET_RULES, DBA_RULES and DBA_RULE_SETS.
The details are as follows:
select * from dba_scheduler_chain_rules where rule_name = 'CH_RU_3_01082012080123'; owner chain_name rule_owner rule_name condition