ORA-39006: internal error ORA-39213: Metadata processing is not available in EXPDP

I was getting this error when I do an schema export , Initial investigation suggested below fix

ORA-39006: internal error ORA-39213: 
Metadata processing is not available  in EXPDP

attempt 1:
hostname:dbname> SELECT comp_id, version, status FROM dba_registry;

COMP_ID                        VERSION                        STATUS
------------------------------ ------------------------------ -------------------
XDB                            11.2.0.3.0                     VALID
CATALOG                        11.2.0.3.0                     VALID
CATPROC                        11.2.0.3.0                     VALID

hostname:dbname> set timing on;
hostname:dbname> set time on;
15:47:57 hostname:dbname> exec dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.

Elapsed: 00:00:03.77

I retried my export again and this time gave a different error

$ expdp \"sys/password@dbname as sysdba\" DIRECTORY=id_migartion SCHEMAS=USBAJA DUMPFILE=test.dmp LOGFILE=test.log

Export: Release 11.2.0.3.0 - Production on Tue Apr 28 15:48:21 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-01403: no data found

ORA-39097: Data Pump job encountered unexpected error 100

attempt 2: Looking up for this issue , found a solution with note id

Errors ORA-39125 ORA-1403 ORA-39125 ORA-39065 ORA-39006 When Running A DataPump Import (Doc ID 789102.1)


hostname:dbname> select owner, object_name, object_type
     from   dba_objects
     where  object_name = 'DUAL';   2    3

OWNER                    OBJECT_NAME                    OBJECT_TYPE
------------------------ ------------------------------ -------------------
SYS                      DUAL                           TABLE
PUBLIC                   DUAL                           SYNONYM


But, It was not the case , there was no additional DUAL table in my database, searched more and found below note.

fix : DataPump Export Reports ORA-39097: Data Pump job encountered unexpected error 100 (Doc ID 453796.1)

This has fixed my issue ,

hostname:dbname> select count(*) from metanametrans$;

  COUNT(*)
----------
         0

hostname:dbname> @$ORACLE_HOME/rdbms/admin/catmet2.sql

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.

hostname:dbname> hostname:dbname> @$ORACLE_HOME/rdbms/admin/utlrp.sql
.

Cause for the issue can be attributed to a recent XDB installation which done manually and not through oui.