ORA-39006 和 ORA-39213 错误解决方法

ORA-39213: Metadata processing is not available

2010-05-26 11:31

今天在用expdp导出数据时报告一下错误，很奇怪，我的操作步骤没有错误啊。 ORA-39006: internal error ORA-39213: Metadata processing is not available 以下是我解决错误的相关信息 操作系统： Linux infodb111.com 2.6.9-42.0.0.0.1.ELsmp #1 SMP Sun Oct 15 14:02:40 PDT 2006 i686 i686 i386 GNU/Linux 数据库版本信息： Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production CORE    10.2.0.4.0      Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production 以下是操作步骤： [root@infodb111 ~]# su - oracle [oracle@infodb111 /]$ mkdir /oracle/dump_dir [oracle@infodb111 /]$ sqlplus / as sysdba SQL> create directory dump_dir as '/oracle/dump_dir'; SQL> grant read,write on directory dump_dir to scott; Grant succeeded. [oracle@infodb111 /]$ expdp scott/scott tables=mevent directory=dump_dir dumpfile=dump1.dmp Export: Release 10.2.0.4.0 - Production on Wednesday, 26 May, 2010 11:02:10 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available [oracle@infodb111 /]$ oerr ora 39006 39006, 00000, "internal error" // *Cause: An unexpected error occurred while processing a Data Pump job. //          Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS //          will further describe the error. // *Action: Contact Oracle Customer Support. [oracle@infodb111 /]$ oerr ora 39213 39213, 00000, "Metadata processing is not available" // *Cause: The Data Pump could not use the Metadata API. Typically, //          this is caused by the XSL stylesheets not being set up properly. // *Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets //          to reload the stylesheets. 根据oerr ora 39213提示，执行exec dbms_metadata_util.load_stylesheets; 再进行导出正常，问题解决。