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

Symptom:

Expdp reports the following error ORA-39006: internal errorORA-39213: Metadata processing is not available reference metalink: Ora-39213 Using Data Pump Export (Document ID 402242.1), execute the following statement: SQL> execute sys. dbms_metadata_util.load_stylesheets;

The following error is prompted:

Begin dbms_metadata_util.load_stylesheets; end; ORA-01114: IO error writing block to file (block #) ORA-06512: at "dbms_metadata_util", line 2345ORA-06512: at line 2

Solution:

Correct: no error is reported. Execute dbms_metadata_util.load_stylesheets; executing expdp again reports the following error: 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 execute the following script to regenerate 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