 |
|
ORA-03120: two-task conversion routine: integer overflow tips
Oracle Error Tips by Stephanie F.
|
The Oracle docs note this on the
ORA-03120 error:
ORA-03120 two-task conversion routine:
integer overflow
Cause: An integer value in an internal Oracle structure
overflowed when being sent or received over a heterogeneous connection. This can
happen when an invalid buffer length or too great a row count is specified. It
usually indicates a bug in the user application.
Action: Check parameters to Oracle
calls. If the problem recurs, reduce all integer parameters, column values not
included, to less than 32767.
Internet sources
indicate that ORA-03120 is associated with bug 5671074 on Oracle
Enterprise Edition; Version 9.2.0.8, occurring on any platform:
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 with:
ORA-04052: error occurred when looking up remote object OMS.PREMISE@JEAUSER_OMPR_L.WORLD
ORA-00604: error occurred at recursive SQL level 1
ORA-03120: two-task conversion routine: integer overflow
ORA-02063: preceding line from
JEAUSER_OMPR_L
Bug 5671074 "ORA-4052/ORA-3106 on Create /
Refresh of Materialized View", can cause this problem. Contrary to the bug
abstract and description, this bug does not just apply to materialized view
creation and refresh. It can occur for any PL/SQL that 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. A list of the endianness
of different platforms can be obtained from the following query (note that
the v$transportable_platform view is only available in 10.1 and above):
SQL> select * from v$transportable_platform;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- ------------------------------ --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
7 Microsoft Windows NT Little
10 Linux IA (32-bit) Little
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
5 HP Tru64 UNIX Little
4 HP-UX IA (64-bit) Big
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
9 IBM zSeries Based Linux Big
13 Linux 64-bit for AMD Little
16 Apple Mac OS Big
12 Microsoft Windows 64-bit for AMD Little
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. One-off patches to 9.2.0.8 for most platforms are already
available for download on MOSC. Bug 5671074 to the 9.2.0.8 database.
One-off patches to 9.2.0.8 for most platforms are already available for
download on MOSC.
You may also find this link
helpful, as it references
ORA-03120
