ORA-07445 [LdiTZGetDeltaMinAffectedTime()] During TTS DataPump Import

(Doc ID 2400553.1)

Last updated on MAY 18, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1 to 18.1]
Information in this document applies to any platform.


DataPump Import fails at the end of job execution due to a fatal error:

Import: Release - Production on Fri May 4 09:04:06 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Source time zone is +03:00 and target time zone is +00:00.
Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01": "/******** AS SYSDBA" parfile=imp.par logfile=impdp.log
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/RADM_FPTM
Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at Sat May 5 18:40:37 2018 elapsed 1 09:36:26

and the error ORA-7445[LdiTZGetDeltaMinAffectedTime] appears in alert.log file:

Sat May 05 18:38:28 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x16] [PC:0x10F562FC0, LdiTZGetDeltaMinAffectedTime()] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/ibssparc/diag/diag/rdbms/ibssparc/ibssparc/trace/ibssparc_dw00_14276.trc (incident=231265):
ORA-07445: exception encountered: core dump [LdiTZGetDeltaMinAffectedTime()] [SIGSEGV] [ADDR:0x16] [PC:0x10F562FC0] [Address not mapped to object] []
Incident details in: /u01/app/oracle/ibssparc/diag/diag/rdbms/ibssparc/ibssparc/incident/incdir_231265/ibssparc_dw00_14276_i231265.trc

The incident trace file generated for ORA-7445[LdiTZGetDeltaMinAffectedTime] shows:

========= Dump for incident 231265 (ORA 7445 [LdiTZGetDeltaMinAffectedTime]) ========
----- Beginning of Customized Incident Dump(s) -----
Dumping swap information

*** 2018-05-05 18:38:29.152
swap info: free_mem = 424800.02M rsv = 10987.52M
alloc = 9334.23M avail = 430698.34M swap_free = 432351.62M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x16] [PC:0x10F562FC0, LdiTZGetDeltaMinAffectedTime()] [flags: 0x0, count: 1]
Disass information
> (0x10f562fc0) ldub [%o0 + 0x16],%o3
(0x10f562fc4) subcc %o3,0x5,%g0
(0x10f562fc8) be,pn %icc,0xf562fd8
(0x10f562fcc) or %g0,0x763,%o4
(0x10f562fd0) jmpl %o7 + 0x8,%g0
(0x10f562fd4) srl %o4,0x0,%o0
(0x10f562fd8) ld [%o0 + 0x0],%g2
(0x10f562fdc) sethi %hi(0x6d423800), %g1
(0x10f562fe0) add %g1,0x2f1,%o5

*** 2018-05-05 18:38:29.153
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=2rvnmbcgymr3d) -----
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
83cc8ce40 183 package body SYS.DBMS_DST
83cc8ce40 783 package body SYS.DBMS_DST
80cb9aa00 14789 package body SYS.KUPW$WORKER
80cb9aa00 20875 package body SYS.KUPW$WORKER
80cb9aa00 4545 package body SYS.KUPW$WORKER
80cb9aa00 12063 package body SYS.KUPW$WORKER
80cb9aa00 2081 package body SYS.KUPW$WORKER
77a09abc0 2 anonymous block

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
LdiTZGetDeltaMinAffectedTime qesdpiGetMinAffTime qesdpiUpgradeTable spefcmpa spefmccallstd peftrusted psdexsp
kxe_push_env_internal_pp kkx_push_env_for_IC D_for_new_session psdextp D_for_new_session pefccal pefcal pevm_FCAL






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