使用impdp的networ_link从11.2.0.3向10.2.0.1同步数据时遭遇内部错误

为了减少数据落地时间，使用network_link远程抽取的方式导入数据，结果报错了：

[rac11g1@oracle]$ username=ODSAML  ;password=ODSAML ;impdp $username/$password directory=dumpdir logfile=$username.impdp.20120920.log network_link=${username}dbl cluster=n exclude=table_statistics

 
 Import: Release 11.2.0.2.0 - Production on Thu Sep 20 14:26:58 2012
 
 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
 Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
 With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
 Data Mining and Real Application Testing options
 ORA-39006: internal error
 ORA-39113: Unable to determine database version
 ORA-04052: error occurred when looking up remote object SYS.DBMS_UTILITY@ODSAMLDBL
 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 ODSAMLDBL
 
 ORA-39097: Data Pump job encountered unexpected error -4052

 

这是个低版本中的Bug，可以打相应的Patch，不过貌似现在也下不到补丁了，所以建议直接升级吧。

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1 - Release: 10.1 to 10.2
Oracle Server - 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 02-SEP-2011***

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