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

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

Post a Comment

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET