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

jiawang

报错现象：

[oracle@strong_dg admin]$ impdp system/oracle DIRECTORY=DMP_DIR  NETWORK_LINK=link_sztech  full=y

Import: Release 11.2.0.4.0 -Production on nWed Jan 9 16:22:40 2019

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

Connected to: Oracle Database11gEnterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, DataMiningand Real Application Testing options

ORA-39006: internal error

ORA-39213: Metadata processing isnotavailable

[size=15.3333px]网上查了下，解决方法如下描述：

[size=15.3333px] Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly.

[size=15.3333px] Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.

解决办法：

运行脚本：

SQL> conn / as sysdba;

Connected.

SQL> execute  sys.dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfullycompleted.

再次执行impdp导入成功

登录/注册后可看大图