执行Oracle数据库导入,遇到报错ORA-39006: internal error、ORA-39213: Metadata processing is not available。这还是第一次遇到。
下面说下解决方法。
1. 执行导出操作,报错:
[oracle@oracle bin]$ ./expdp cwy_GX1009/cwy_GX1009@orcl directory=DATA_PUMP_DIR schemas=cwy_GX1009 dumpfile=cwy_GX1009_1028.dmp logfile=exp_cwy_GX1009_1028.log
Export: Release 11.2.0.4.0 - Production on Fri Oct 28 13:56:36 2022
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
2. 解决办法:
sqlplus 执行 execute dbms_metadata_util.load_stylesheets;
[oracle@oracle bin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 28 13:59:59 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> execute dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
SQL>
3. 再次导出,导出成功:
[oracle@oracle bin]$ ./expdp cwy_GX1009/cwy_GX1009@orcl directory=DATA_PUMP_DIR schemas=cwy_GX1009 dumpfile=cwy_GX1009_1028.dmp logfile=exp_cwy_GX1009_1028.log
Export: Release 11.2.0.4.0 - Production on Fri Oct 28 14:01:51 2022
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
Starting "CWY_GX1009"."SYS_EXPORT_SCHEMA_01": cwy_GX1009/********@orcl directory=DATA_PUMP_DIR schemas=cwy_GX1009 dumpfile=cwy_GX1009_1028.dmp logfile=exp_cwy_GX1009_1028.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 724.5 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE