Monday, December 24, 2012

DBMS_METADATA Is Missing During expdp

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

2 comments:

  1. Hi Osama, I live in Kent, England, and I am trying to get hold of a copy of your book Oracle Penetration Testing but not having any enjoy .. Would it be possible for you to send me a link please or let me how I can order it..
    Many Thanks.
    Kevin

    ReplyDelete
    Replies
    1. Hi Kevin , the book is not published Yet , It will be Published in 2013 :)

      Delete