ORA-39006,ORA-39213,ORA-06512,ORA-01114,ORA-39065,ORA-39097,ORA-01403 EXPDP...

4若

问题现象：
?expdp报如下错误  
?ORA-39006: internal error  
ORA-39213: Metadata processing is not available  

参考metalink:Ora-39213 Using Data Pump Export (文档 ID 402242.1)，执行如下语句：  
SQL> execute sys.dbms_metadata_util.load_stylesheets;  

提示如下错误
begin dbms_metadata_util.load_stylesheets; end;  

?ORA-01114: IO error writing block to file (block #)  
ORA-06512: at "dbms_metadata_util",line 2345  
ORA-06512: at line 2  

?解决办法：
正确的如下，没有报错。  
execute dbms_metadata_util.load_stylesheets;  

再次执行expdp报如下错误：  
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  

执行执行如下脚本，重新生成DATAPUMP AIP即可：  
sqlplus / as sysdba   
SQL>@$ORACLE_HOME/rdbms/admin/catmeta.sql     
SQL>@$ORACLE_HOME/rdbms/admin/catmet2.sql     
SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql  

?参考如下metalink文档
NOTE:351650.1 - Export Aborts with ORA-600 [qmtInit1] or ORA-600 [unable to load XDB library] while Exporting Cluster Definitions
NOTE:452289.1 - Dpexp Of One Schema Crashes With Error Ora-39125 And Ora-04021.
NOTE:453796.1 - Data Pump Export Started Failing After Applying CPU Patchlinux