Oracle10.2.0.3 impdp 导入数据报 ORA-39125 in KUPW$WORKER.PUT_DDLS LPX-00007问题解决

最新推荐文章于 2021-05-25 23:38:33 发布

转载最新推荐文章于 2021-05-25 23:38:33 发布 · 470 阅读

文章标签：

本文介绍了解决Windows平台上10.2.0.3版本Oracle数据库在使用impdp命令导入数据时出现ORA-39125错误的方法。此错误源于Oracle的一个已知bug（bug号为5535956），可通过应用补丁6753556或替换特定列中的NULL字符来解决。

Windows平台上的10.2.0.3数据库，当使用impdp命令向数据库中导入数据的时候报如下错误：

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while
calling DBMS_METADATA.CONVERT [TABLE:....]
ORA-6502: PL/SQL: numeric or value error
LPX-00007: unexpected end-of-file encountered
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-6512: at "SYS.KUPW$WORKER", line 6234
----- PL/SQL Call Stack -----
object line object
handle number name
0x25bd1d0c8 14916 package body SYS.KUPW$WORKER
0x25bd1d0c8 6293 package body SYS.KUPW$WORKER
0x25bd1d0c8 12280 package body SYS.KUPW$WORKER
0x25bd1d0c8 3278 package body SYS.KUPW$WORKER
0x25bd1d0c8 6882 package body SYS.KUPW$WORKER
0x25bd1d0c8 1259 package body SYS.KUPW$WORKER
0x25de5e9f0 2 anonymous block

经查询这是oracle的一个bug（bug号为：5535956）

[@more@]下面是metalink上给出的问题描述：
This is Bug 6635956:

If DBMS_METADATA.GET_DDL fails with the following errors and audit$ column in tab$, view$, seq$, procedure$, dir$, user$, type_misc$, or library$ contains NULL characters, it's probably this bug.

ORA-6502: PL/SQL: numeric or value error
LPX-00007: unexpected end-of-file encountered
ORA-6512: at "SYS.UTL_XML", line 259
ORA-6512: at "SYS.DBMS_METADATA_INT", line 10269
ORA-6512: at "SYS.DBMS_METADATA_INT", line 10384
ORA-6512: at "SYS.DBMS_METADATA", line 2361
ORA-6512: at "SYS.DBMS_METADATA", line 3247
ORA-6512: at "SYS.DBMS_METADATA", line 4863
ORA-6512: at line 1

In the case of the datapump import, you would see the following errors.
Note that the object name in the error message does not always match the object whose audit$ column contains the NULL character.

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling
DBMS_METADATA.CONVERT [TABLE:"SH"."MV_CAPABILITIES_TABLE"]
ORA-6502: PL/SQL: numeric or value error
LPX-00007: unexpected end-of-file encountered
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-6512: at "SYS.KUPW$WORKER", line 6234
.----- PL/SQL Call Stack -----
object line object
handle number name
0x2bc6c228 14916 package body SYS.KUPW$WORKER
0x2bc6c228 6293 package body SYS.KUPW$WORKER
0x2bc6c228 12280 package body SYS.KUPW$WORKER
0x2bc6c228 3278 package body SYS.KUPW$WORKER
0x2bc6c228 6882 package body SYS.KUPW$WORKER
0x2bc6c228 1259 package body SYS.KUPW$WORKER
0x2add8080 2 anonymous block

下面是metalink上给出的解决问题的方法

If on 10.2.0.3, apply Patch 6753556 which merges:

Base Bugs: 6753556 6529662 5515882 4352110 6635956
There is also a generic platform patch available on 10.2.0.3 or 10.2.0.4 in Patch 6635956:

Or use the following workaround:

Replace NULL chars in audit$ column with '-' by issuing an appropriate NOAUDIT command, and re-enable auditing operations using AUDIT command if needed. Then, retrieve the metadata or perform the export/import

--end--

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22049049/viewspace-1030435/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22049049/viewspace-1030435/