expdp ora-39213: metadata processing is not available expdp 11g

expdp ora-39213: metadata processing is not available expdp 11g

 
In Windows,maybe missing, invalid some registry key, we need to check the registry entriesin windows machine to ensure that they (key) are in a valid status.  In case you have INVALID status in dba_registry, yu have check it and try to find a solution for it.IN THIS CASE when we try expdp but oracle throw this error ORA-39213 metadata processing is not available . java, xml file error .

Symptoms

When running expdp the following errors are raised:

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

This error was detected while executing the DataPump in any platform.

Cause

DataPump export uses DBMS_METADATA_UTIL package but this package does not successfully run. Executing sys.dbms_metadata_util.load_stylesheets procedure failed with following error:

ORA-31609: error loading file "kualter.xsl" from file system directory "/rdbms/xml/xsl"
ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 1807
ORA-06512: at line 1

This package needs XML being installed and XML needs JAVA being installed.

The select from view dba_registry shows neither Java nor XML were installed:

SQL> SELECT comp_id, version, status FROM dba_registry; 

COMP_ID                      VERSION                     STATUS
---------------------------  --------------------------- -----------
CATALOG                      10.2.0.2.0                  VALID
CATPROC                      10.2.0.2.0                  VALID

Solution

1. Install JVM and XML  executing the following scripts from sqlplus:

SQL> connect / as sysdba
SQL> @$ORACLE_HOME/javavm/install/initjvm.sql

SQL> connect / as sysdba
SQL> @$ORACLE_HOME/xdk/admin/initxml.sql

SQL> connect / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/catjava.sql

SQL> connect / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

2. Check if the scripts successfully ran:

select comp_name, version, status from dba_registry;

COMP_NAME                          VERSION                     STATUS
---------------------------------- --------------------------- -------
Oracle Database Catalog Views      10.2.0.2.0                 VALID
Oracle Database Packages and Types 10.2.0.2.0              VALID
JServer JAVA Virtual Machine       10.2.0.2.0                  VALID
Oracle XDK                         10.2.0.2.0                             VALID
Oracle Database Java Packages      10.2.0.2.0                  VALID

3. Run again sys.dbms_metadata_util.load_stylesheets from sqlplus:

connect / as sysdba
execute sys.dbms_metadata_util.load_stylesheets;

 

 

expdp bbb/ddd@ORCL schemas=niger directory=data_pump_dir dumpfile=140617.dmp logfile=exp140617.log