IMPDP - Database Import Job Aborts With ORA-07445 [LdiDateFromArray()+1132] In Alert Logfile (Doc ID 1914200.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Personal Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Standard Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Enterprise Manager for Oracle Database - Version 11.1.0.6 to 12.1.0.6.0 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Symptoms

1. You run a full database Import Data Pump job which aborts, e.g.:

$ impdp system/manager parfile=impdp.par

Import: Release 11.2.0.3.0 - Production on Sun Jul 13 10:12:22 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** parfile=impdp.par
...
. . imported "K"."EVT3":"AGING_000011488"                71.20 MB 4714416 rows
Job "SYSTEM"."SYS_IMPORT_FULL_01" stopped due to fatal error at 11:46:00

2. The alert logfile on the target database shows:

...
Sun Jul 13 11:43:10 2014
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0xFFFFFFFF77B80000] [PC:0x1073C412C, LdiDateFromArray()+1132] [flags: 0x0, count: 1]
Errors in file /opt/oracle/admin/orcl/diag/rdbms/orcl/orcl/trace/orcl_dw14_11880.trc  (incident=737):
ORA-07445: exception encountered: core dump [LdiDateFromArray()+1132] [SIGSEGV] [ADDR:0xFFFFFFFF77B80000] [PC:0x1073C412C] [Invalid permissions for mapped object] []
Incident details in: /opt/oracle/admin/orcl/diag/rdbms/orcl/orcl/incident/incdir_737/orcl_dw14_11880_i737.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun Jul 13 11:43:20 2014
Non critical error ORA-48913 caught while writing to trace file "/opt/oracle/admin/orcl/diag/rdbms/orcl/orcl/incident/incdir_737/orcl_dw14_11880_i737.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit [5000000] reached
Writing to the above trace file is disabled for now on...
...
Sun Jul 13 11:46:05 2014
Errors in file /opt/oracle/admin/orcl/diag/rdbms/orcl/orcl/incident/incdir_737/orcl_dw14_11880_i737.trc:
ORA-00448: normal completion of background process
ORA-07445: exception encountered: core dump [LdiDateFromArray()+1132] [SIGSEGV] [ADDR:0xFFFFFFFF77B80000] [PC:0x1073C412C] [Invalid permissions for mapped object] []
...

3. The trace file of the Data Pump Worker process shows:

[Insert note here]
...
*** 2014-07-13 11:43:10.623
*** SESSION ID:(369.1) 2014-07-13 11:43:10.623
*** CLIENT ID:() 2014-07-13 11:43:10.623
*** SERVICE NAME:(SYS$BACKGROUND) 2014-07-13 11:43:10.623
*** MODULE NAME:(Data Pump Worker) 2014-07-13 11:43:10.623
*** ACTION NAME:(SYS_IMPORT_FULL_01) 2014-07-13 11:43:10.623

Dump continued from file: /opt/oracle/admin/orcl/diag/rdbms/orcl/orcl/trace/orcl_dw14_11880.trc
ORA-07445: exception encountered: core dump [LdiDateFromArray()+1132] [SIGSEGV] [ADDR:0xFFFFFFFF77B80000] [PC:0x1073C412C] [Invalid permissions for mapped object] []
...
----- Current SQL Statement for this session (sql_id=2wx1gsrmh38g4) -----
BEGIN
 SYS.KUPW$WORKER.MAIN('SYS_IMPORT_FULL_01', 'SYSTEM', 0);
END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object      line  object
handle    number  name
4f2bf4058        58  package body SYS.KUPD$DATA_INT
4f3481118      3401  package body SYS.KUPD$DATA
4f36ec938     15332  package body SYS.KUPW$WORKER
4f36ec938      4426  package body SYS.KUPW$WORKER
4f36ec938      9739  package body SYS.KUPW$WORKER
4f36ec938      1775  package body SYS.KUPW$WORKER
4f2eb3470         2  anonymous block
...

Stack:
ksedst1 ksedst dbkedDefDump ssexhd sighndlr call_user_handler sigacthandler
LdiDateFromArray kpudpcdt kpudpcv kpudpcs_colToStreamInner kpudpxcs_ctxConvertStream kpudpxls_ctxLoadStream kupdls_rdData kupdls
spefcifa spefmccallstd peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe ...

4. The problem reproduces if you re-create the export DataPump dumpfile with expdp.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms