ORA-39213： Metadata processing is not available 解决方法

 

Oracle 11.2.0.3 impdp 报错：

 

gg2:/u01/backup> impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;

 

Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:35:19 2011

 

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.  All rights reserved.

 

Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

ORA-39006: internal error

ORA-39213: Metadata processing is notavailable

 

查看ORA-39213 具体内容：

gg2:/u01/backup> oerr ora 39213

39213, 00000, "Metadata processing isnot 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 executedbms_metadata_util.load_stylesheets

//         to reload the stylesheets.

gg2:/u01/backup>

 

运行脚本：

SQL> conn / as sysdba;

Connected.

SQL> executesys.dbms_metadata_util.load_stylesheets;

 

PL/SQL procedure successfully completed.

 

再次impdp 成功：

gg2:/u01/backup> impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;

 

Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:39:40 2011

 

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.  All rights reserved.

 

Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

Master table "DAVE"."SYS_IMPORT_TABLE_01"successfully loaded/unloaded

Starting"DAVE"."SYS_IMPORT_TABLE_01":  dave/******** directory=backupdumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace

Processing object typeTABLE_EXPORT/TABLE/TABLE

Processing object typeTABLE_EXPORT/TABLE/TABLE_DATA

. . imported"DAVE"."PDBA"                               49.14 MB 2713235rows

Job"DAVE"."SYS_IMPORT_TABLE_01" successfully completed at 12:40:16

 

 

 

 

-------------------------------------------------------------------------------------------------------

版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任！

QQ:492913789

Email:ahdba@qq.com

Blog:  http://www.cndba.cn/dave

Weibo:    http://weibo.com/tianlesoftware

Twitter:  http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

 

-------加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请----

DBA1 群：62697716(满);   DBA2 群：62697977(满)  DBA3 群：62697850(满)  

DBA 超级群：63306533(满);  DBA4 群：83829929(满) DBA5群： 142216823(满) 

DBA6 群：158654907(满)   DBA7 群：69087192(满)  DBA8 群：172855474

DBA 超级群2：151508914  DBA9群：102954821     聊天 群：40132017(满)