Thursday, November 12, 2009

ORA-04063: ORA-04063: package body "EXFSYS.DBMS_RLMGR_DR" has errors

Noticed Below error in Alert log file:

ORA-12012: error on auto execute of job 42585
ORA-04063: ORA-04063: package body "EXFSYS.DBMS_RLMGR_DR" has errors
ORA-06508: PL/SQL: could not find program unit being called: "EXFSYS.DBMS_RLMGR_DR"
ORA-06512: at line 1 has errors

Solution I tried:

Re-created "EXFSYS" sample schema using the below commmand.

Step 1: Login as SYSDBA
Step 2: @$ORACLE_HOME/rdbms/admin/catexf.sql

No comments: