Oracle 10.2.0.5 expdp ORA-39014/ORA-39029

qq69033472

Import: Release 10.2.0.5.0 - 64bit Production on Friday, 20 March, 2015 16:35:01

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "POPUPUSER"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "POPUPUSER"."SYS_IMPORT_SCHEMA_01":  popupuser/******** directory=TRAN_DUMP_DIR dumpfile=all.dmp logfile=all.log schemas=popupuser
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-31684: Object type USER:"POPUPUSER" already exists
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "POPUPUSER"."T_POP_UID_LOG"                 294.1 MB 5536165 rows
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.

Job "POPUPUSER"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at 16:36:46

今天用impdp做数据转移，impdp的时候报错ORA-39014/ORA-39029，然后查看alter log发现
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ldxlxi()+15] [SIGSEGV] [Address not mapped to object] [0x0000000E8] [] []

请大神指点

trace文件如下

Liu Maclean(刘相兵

*** 2015-03-20 16:35:20.540
*** ACTION NAME:(SYS_IMPORT_SCHEMA_01) 2015-03-20 16:35:20.540
*** MODULE NAME:(Data Pump Worker) 2015-03-20 16:35:20.540
*** SERVICE NAME:(SYS$USERS) 2015-03-20 16:35:20.540
*** SESSION ID:(142.1) 2015-03-20 16:35:20.540
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xe8, PC: [0x383e703, ldxlxi()+15]
*** 2015-03-20 16:35:20.545
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ldxlxi()+15] [SIGSEGV] [Address not mapped to object] [0x0000000E8] [] []
Current SQL statement for this session:
BEGIN
   SYS.KUPW$WORKER.MAIN('SYS_IMPORT_SCHEMA_01', 'POPUPUSER');
END;
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x514eff540        54  package body SYS.KUPD$DATA_INT
0x515e75da0      1725  package body SYS.KUPD$DATA
0x514f0b890     11005  package body SYS.KUPW$WORKER
0x514f0b890      3797  package body SYS.KUPW$WORKER
0x514f0b890      7078  package body SYS.KUPW$WORKER
0x514f0b890      1340  package body SYS.KUPW$WORKER



stack call  kpudpxls_ctxLoadStream =>kpudpxcs_ctxConvLoadStream=>kpudpxcs_ctxConvertStream=>kpudpgbr
=>kpudpgbc

qq69033472

dw trace文件

Liu Maclean(刘相兵

odm fingding:

Errors ORA-39014 ORA-39029 ORA-31672 On DataPump Import (Doc ID 956662.1)        To BottomTo Bottom       

In this Document
Symptoms
Cause
Solution
References
APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 23-Jul-2013***
SYMPTOMS

DataPump import always crashes with the following errors when the table has NOT NULL columns:

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYSTEM"."SYS_IMPORT_TABLE_02" stopped due to fatal error at 11:31:29
ORA-39014: One or more workers have prematurely exited.

In the alert log file:

ORA-07445: exception encountered: core dump [ldxlxi+0034] [SIGSEGV] [Invalid permissions for mapped object] [0x0000000E8] [] []

The call Stack looks like:

ldxdts kpudpgbc kpudpgbr kpudpxcs_ctxConvertStream kpudpxcs_ctxConvLoadStream kpudpxls_ctxLoadStream OCIDirPathLoadStream kupdls_rdData kupdls spefcifa spefmccallstd pextproc peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL
CAUSE

The cause of this problem has been identified in Bug 8470871.

It is caused when impdp is inserting null value in NOT NULL column. DataPump direct path import does not correctly handle importing rows that have null data column and violate a NOT NULL constraint.

SOLUTION

Bug 8470871 is fixed in 12.1 release and patch set 11.2.0.2.

For other versions, please apply interim Patch 8470871 if available for your platform.

REFERENCES

NOTE:8470871.8 - Bug 8470871 - IMPDP worked dumps / ORA-39014 ORA-39029 ORA-31672 for NULL data violating a NOT NULL constraint

Liu Maclean(刘相兵

以上问题 由bug  8470871 y引起， 到11.2.0.2中修复， 其他版本可以打临时补丁 8470871