Oracle 10.2.0.5 expdp ORA-39014/ORA-39029
Import: Release 10.2.0.5.0 - 64bit Production on Friday, 20 March, 2015 16:35:01Copyright (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 [] []
请大神指点
trace文件如下
*** 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:
*** 2015-03-20 16:35:20.545
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [] []
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 dw trace文件 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
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 [] []
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 以上问题 由bug 8470871 y引起， 到11.2.0.2中修复， 其他版本可以打临时补丁 8470871
页:
[1]