问题现象:
提示如下错误
解决办法:
参考如下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
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