impdp 遭遇ORA-39113

xifenfei

源库：Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
      user :zjk，dba权限
      table:t_zs_grjfmx
目标库：Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      user：zjk_test
      已建源库的DBLink：zjk_link
使用impdp network_link 命令把源库中表t_zs_grjfmx的数据迁移到目标库的zjk_test用户下，命令impdp zjk_test/zjk_test@testDB network_link=zjk_link remap_schema=zjk:zjk_test remap_tablespace=TS_XT_DATA01:USERS TABLES=t_zs_grjfmx TABLES=t_sfzj_grjfmx
报错信息：
Import: Release 11.2.0.1.0 - Production on 星期二 6月 24 18:27:05 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: 内部错误
ORA-39113: 无法确定数据库版本
ORA-04052: 在查找远程对象 SYS.DBMS_UTILITY@MMZJKCS_LINK 时出错
ORA-00604: 递归 SQL 级别 3 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [55916]
ORA-02063: 紧接着 2 lines (起自 MMZJKCS_LINK)

ORA-39097: 数据泵作业出现意外的错误 -4052

xifenfei

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.1.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 13-Mar-2013***


SYMPTOMS

Datapump import fails with the following errors when importing into an 11g database from a 10g export:

ORA-39006: internal error
ORA-39113: Unable to determine database version
ORA-04052: error occurred when looking up remote object SYS.DBMS_UTILITY@<tns alias>
ORA-00604: error occurred at recursive SQL level 3
ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [55916]
ORA-02063: preceding 2 lines from <tns alias>
ORA-39097: Data Pump job encountered unexpected error -4052
ORA-39006: internal error
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3444
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5233
ORA-06512: at line 2

CAUSE

This is due to unpublished bug 4511371 fixed in 11.1 and 10.2.0.2, where an interoperability issue occurs during remote PLSQL lookup of an object between 10g and 11g, as documented in Note:4511371.8.

SOLUTION

Apply the latest patchset to the 10g database, e.g.: 10.2.0.4 or 10.1.0.5.

REFERENCES

NOTE:4511371.8 - Bug 4511371 - ORA-6544 / ORA-4052 using PLSQL between 10g and 11g



相关内容


产品

Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS
Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS

关键字

DATAPUMP;DBMS_UTILITY;IMPDP;INTEROPERABILITYLSQL

错误

ORA-2063;ORA-39006;ORA-39097;ORA-39113;ORA-4052;ORA-604;ORA-6512;ORA-6544;ORA-6553LS-801

具体参考：IMPDP From 10g TO 11g Gives ORA-39113, ORA-4052 & ORA-6544 PL/SQL: internal error, arguments: [55916] (文档 ID 1062428.1)