ORA-27468 EXFSYS.RLM$EVTCLEANUP任务引起的故障

Errors in file /oracle/admin/cdx/bdump/cdx2_j000_663594.trc:
ORA-12012: error on auto execute of job 42780
ORA-27468: "EXFSYS.RLM$EVTCLEANUP" is locked by another process

Thu Dec 30 01:27:23 2010
Errors in file /oracle/admin/cdx/bdump/cdx2_cjq0_958586.trc:
ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select a.obj# OBJOID, a.clas...","sga heap(1,0)","kglsim heap")
ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select a.obj# OBJOID, a.clas...","sga heap(1,0)","kglsim heap")
ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select a.obj# OBJOID, a.clas...","sga heap(1,0)","kglsim heap")
ORA-04031: unable to allocate ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","select a.obj# OBJOID, a.clas...","sga heap(1,0)","kglsim object batch")
 bytes of shared memory ("","","","")
 bytes of shared memory ("","","","")
ORA-04031: unable to allocate OR bytes of shared memory ("","","","")
ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select a.obj# OBJOID, a.clas...","sga heap(1,0)","kglsim heap")

These jobs under EXFSYS schema are related to the Expression Filter feature in 10G.
The Expression Filter feature can be installed on an Oracle10G Standard or Enterprise Edition
database. It is supplied as a set of PL/SQL packages, a Java package, a set of dictionary tables,
and catalog views. All these objects are created in a dedicated schema named EXFSYS. This schema
is not part of the typical installation of the database and will not exist before the Expression Filter is installed.

1. Login as SYSDBA
2. @$ORACLE_HOME/rdbms/admin/catnoexf.sql

BEGIN
    dbms_scheduler.run_job(job_name => 'EXFSYS.RLM$EVTCLEANUP', use_current_session => FALSE);
END;
/