ORA-39213 Metadata processing is not available

ORA-39213 Metadata processing is not available

           

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle Database 11gR2

           

Description:

Expdp utility going to failed with following error:

ORA-39213: Metadata processing is not available

After some research I found that it is caused by the XSL stylesheets not setup/load properly.

Solution:

To fix the problem do the following steps:

Connect AS SYSDBA and execute the following to reload the stylesheets:

SQL> execute dbms_metadata_util.load_stylesheets;

Re-test the expdp, now it is working fine.

           

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ