Data Pump - ORA-07445 [PC:0x0] On ALTER PACKAGE "SYS"."KUPW$WORKER" COMPILE BODY REUSE SETTINGS (Doc ID 1628901.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle Database - Standard Edition - Version 12.1.0.1 and later
Oracle Database - Personal Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to run an Export DataPump or Import DataPump job from a specific Pluggable database, the following error occurs.

$ expdp system/manager@ora07:1521/INTERNAL directory=my_dir dumpfile=expdp_tc.dmp logfile=expdp_tc.log schemas=tc

Export: Release 12.1.0.1.0 - Production on Wed Feb 5 08:18:31 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_09":  system/********@ora07:1521/INTERNAL directory=my_dir dumpfile=expdp_tc.dmp logfile=expdp_tc.log schemas=tc

Job "SYSTEM"."SYS_EXPORT_SCHEMA_09" stopped due to fatal error at Wed Feb 5 08:20:04 2014 elapsed 0 00:01:30

The alert logfile shows:

...
DW00 started with pid=129, OS id=26572, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_03
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x0, {empty}] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/xxx/XXX/trace/DEVEE07_dw00_26572.trc  (incident=39434):
ORA-07445: Exception aufgetreten: CORE Dump [PC:0x0] [SIGSEGV] [ADDR:0x0] [PC:0x0] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/xxx/XXX/incident/incdir_39434/DEVEE07_dw00_26572_i39434.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Feb 05 08:19:05 2014
Dumping diagnostic data in directory=[cdmp_20140121091355], requested by (instance=1, osid=26572 (DW00)), summary=[incident=39434].

...

And the Data Pump Worker trace file shows:

...
ORA-07445: Exception aufgetreten: CORE Dump [PC:0x0] [SIGSEGV] [ADDR:0x0] [PC:0x0] [Address not mapped to object] []

========= Dump for incident 39434 (ORA 7445 [PC:0x0]) ========
----- Beginning of Customized Incident Dump(s) -----
Dumping swap information
Memory (Avail / Total) = 25538.46M / 63803.16M
Swap (Avail / Total) = 3072.00M /  3072.00M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x0, {empty}] [flags: 0x0, count: 1]
Registers:
%rax: 0x00007fa0211db9a0 %rbx: 0x00007fff911b55f0 %rcx: 0x0000000000000003
%rdx: 0x000000000ca7a580 %rdi: 0x00007fff911b6970 %rsi: 0x00007fff911b6c68
%rsp: 0x00007fff911b55e8 %rbp: 0x00007fff911b5b00  %r8: 0x0000000000000018
%r9: 0x0000000000600000 %r10: 0x0000000000000000 %r11: 0x0000000005563e5f
%r12: 0x0000000000000000 %r13: 0x00007fa0214f9c40 %r14: 0x00000005a6838cd8
%r15: 0x0000000000000000 %rip: 0x0000000000000000 %efl: 0x0000000000010206

*** 2014-02-05 08:19:05.967
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=69srpx97yfysh) -----
ALTER PACKAGE "SYS"."KUPW$WORKER" COMPILE BODY REUSE SETTINGS
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object      line  object
handle    number  name
0x5a65f3610         2  anonymous block

----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------

skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd
      <- sslsshandler <- sighandler <- 0000000000000000 <- ph1drv <- phpcmp
       <- pcicmp0 <- kkxcmp0 <- rpiswu2 <- kkxcmp <- kkpalt
        <- opiexe <- opiosq0 <- opiosq <- opiodr <- rpidrus
         <- skgmstack <- rpiswu2 <- rpidrv <- rpisplu_internal <- 1145
          <- kqlvld <- kglgob <- kgiinb <- pfri3_inst_body <- pfrrun
           <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8
            <- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpuexec
             <- OCIStmtExecute <- kupprwp <- ksvrdp <- opirip <- opidrv
              <- sou2o <- opimai_real <- ssthrdmain <- main <- 00007FA02152A2F0

 The problem does not get resolved by running catproc.sql:

 

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