ORA-39213/ORA-39006: Metadata processing is not available, internal error
Posted by Mir Sayeed Hassan on February 26th, 2018
ORA-39213/ORA-39006: Metadata processing is not available, internal error
[oracle@testdb ~]$ expdp system directory=db_dump dumpfile=full_db26feb18.dmp logfile= full_db26feb18.log full=yes
Export: Release 11.2.0.4.0 – Production on Mon Feb 26 16:03:01 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data mining and Real Application testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available
Reason:
Due to the Data Pump could not use the Metadata API, this might be caused by XSL not set correctly, to resolve this connect with sqlplus as sysdba & execute the below package to reload the XSL Stylesheets.
Login into the sqlplus & execute the below package.
[oracle@testdb ~]$ !sq sqlplus SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 26 16:54:52 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options sys@TESTDB> execute dbms_metadata_util.load_stylesheets; PL/SQL procedure successfully completed.