author:skate
time:2009/08/20
错误现象:
C:/Users/Administrator>impdp 'system/aibo' table_exists_action=REPLACE logfile=d
uplicate_skate.log SCHEMAS=hpo5 remap_schema=hpo5:arena network_link=to_203
Import: Release 11.1.0.6.0 - Production on Thursday, 20 August, 2009 16:16:16
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, 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@TO_203
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 TO_203
ORA-39097: Data Pump job encountered unexpected error -4052
说明:
和其他内部错误有所区别的是,这个错误不会出现在后台告警日志中。
目标库版本:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
源库版本:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
通过检查metalink,在文档Doc ID: Note:4511371.8中详细描述了这个bug,只要在11g中调用10.1版本
(补丁小于10.1.0.5)或10.2版本(补丁小于10.2.0.2)数据库中的过程,就会引发这个错误。
除了打补丁升级之外,没有什么好的临时解决方法。将10g的数据库升级到10.1.0.5或10.2.0.2版本以上,可以避免问题的产生。
---end---