ORA-03120: two-task conversion routine: integer ov

ORA-03120: two-task conversion routine: integer overflow

在导入imp数据库对象的时候，碰到一个错误:"ORA-03120: two-task conversion routine: integer overflow",查询metalink此问题为9.2.0.8.0平台的一个bug。
解决办法有两个：
1.To implement the solution, it will be necessary to apply the one-off patch for Bug 5671074 to the 9.2.0.8 database.
2.客户端用9.2.0.8.0导入也可以解决这个问题。
问题重现：
1. 9.2.0.1.0客户端导出9.2.0.7.0的数据库下的owner
$ expleiz/ecc@db_9208file=./leiz.dmp wner=leiz
Connected to: Oracle9i Enterprise Edition Release9.2.0.7.0- 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release9.2.0.7.0- Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user leiz
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user leiz
About to export leiz's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export leiz's tables via Conventional Path ...
. . exporting table                    "ARAP_DJLX"         13 rows imported
. . exporting table              "SM_USERANDCLERK"          4 rows imported
. . exporting table           "SM_USER_MANAGEROLE"        379 rows imported
. . exporting table                 "SM_USER_ROLE"       1694 rows imported
. . exporting table              "SQLEXPERT_PLAN1"          0 rows imported
. . exporting table              "TOAD_PLAN_TABLE"        629 rows imported
. . exporting table                                                      
. . exporting table                  "XX_EXSYSTEM"          1 rows imported
. . exporting table                "XX_EXSYSTEM_B"          1 rows imported
. . exporting table              "XX_IDCONTRASTPK"    3303732 rows imported
. . exporting table                      "XX_XLOG"    1670747 rows imported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

2. 9.2.0.1.0客户端导入(同一台客户端) 导入9.2.0.8 数据库服务器
$ impecc_view/ecc@leizfile=./leiz.dmp fromuser=leiz touser=ecc_view
Connected to: Oracle9i Enterprise Edition Release9.2.0.8.0- Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release9.2.0.8.0- Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by leiz, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. . importing table                    "ARAP_DJLX"         13 rows imported
. . importing table              "SM_USERANDCLERK"          4 rows imported
. . importing table           "SM_USER_MANAGEROLE"        379 rows imported
. . importing table                 "SM_USER_ROLE"       1694 rows imported
. . importing table              "SQLEXPERT_PLAN1"          0 rows imported
. . importing table              "TOAD_PLAN_TABLE"        629 rows imported
.....
. . importing table                  "XX_EXSYSTEM"          1 rows imported
. . importing table                "XX_EXSYSTEM_B"          1 rows imported
. . importing table              "XX_IDCONTRASTPK"    3303732 rows imported
. . importing table                      "XX_XLOG"    1670747 rows imported
About to enable constraints...
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00000: Import terminated unsuccessfully

    刚刚碰到这个错误的时候，以为是客户端的问题，但是在不同版本之间进行数据导入的2个规则我都满足:
规则1.   低版本的exp/imp客户端可以连接到高版本（或同版本）的数据库服务器，但高版本的exp/imp客户端不能连接到低版本的数据库服务器。
规则2.   高版本exp出的dmp文件，低版本无法imp（无法识别dmp文件）,没有问题啊，那我尝试把9.2.0.1.0的客户端换成了9.2.0.7.0的exp导出的数据库的那台服务器，但是重复imp操作后，问题仍然重现。查了metalink，原因是9.2.0.8.0平台的一个bug:
    After applying the 9.2.0.8 patchset, compilation of functions and/or materialized view refreshes that reference remote databases via database links start failing. It can occur for anyPL/SQLthat references a remote object via database link where the 'Endianness' of the two platforms differs. If one platform. is 'Big-Endian', and another platform. is 'Little-Endian', then this bug can be triggered between them.
   To resolve ORA-03120, this solution is given:To implement the solution, it will be necessary to apply the one-off patch for Bug 5671074 to the 9.2.0.8 database.

3.用9.2.0.8.0客户端导入9.2.0.8.0数据库服务器，问题解决。
$ impecc_view/ecc@leizfile=./leiz.dmp fromuser=leiz touser=ecc_view
Import: Release 9.2.0.8.0 - Production on 星期三 4月 29 12:50:58 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
连接到: Oracle9i Enterprise Edition Release9.2.0.8.0- Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release9.2.0.8.0- Production
经由常规路径导出由EXPORT:V09.02.00创建的文件
警告: 此对象由 leiz 导出, 而不是当前用户
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将leiz的对象导入到 ECC_VIEW
. . 正在导入表                       "SM_ROLE"        244行被导入
成功终止导入.