Tag: ORA-04067

DBMS_METADATA Is Missing During expdp

Posted on by Osama Mustafa in Database
The Error Appear During The expdp Database , And Looks

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-04067: not executed, package body “SYS.DBMS_METADATA” does not exist
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_METADATA”
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 62
ORA-06512: at “SYS.KUPW$WORKER”, line 6226

Cause:

 SYS.DBMS_METADATA Is Missing .

Solution :

Check if the above object exists

SELECT owner, object_name, object_type, status FROM dba_objects WHERE  object_name=’DBMS_METADATA’;

Not Found :

$ORACLE_HOME/rdbms/admin/prvtmeta.plb
$ORACLE_HOME/rdbms/admin/utlrp.sql