DataPump Export raises ORA-7445 [kaf4reasrp0km] (Doc ID 2078371.1)

Last updated on NOVEMBER 19, 2015

Applies to:

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

Symptoms

On : 11.2.0.4 version, Internals Errors (ORA-600 & ORA-7445)

When attempting to use DataPump export the following error is reported in the alert log:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7F082020202A] [PC:0x8C1078D, kaf4reasrp0km()+495] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dw00_1604.trc (incident=136873):
ORA-07445: exception encountered: core dump [kaf4reasrp0km()+495] [SIGSEGV] [ADDR:0x7F082020202A] [PC:0x8C1078D] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_136873/orcl_dw00_1604_i136873.tr

 
The trace file shows the failing sql as a creation of an external table like;

CREATE TABLE "ET$03CB56050001"
( "DB2_FILIAL",
"DB2_DOC",
"DB2_SERIE",
"DB2_EMISSA",
"DB2_TIPO",
"DB2_CLIFOR",
"DB2_LOJA",
"DB2_ITEM",
"DB2_NRAVRC",
"DB2_VALICM",
"DB2_VALIPI",
"DB2_PESO",
"DB2_VOLUME",
"DB2_ESPECI",
"DB2_FORMUL",
"D_E_L_E_T_",
"R_E_C_N_O_",
"R_E_C_D_E_L_",
"DB2_USER"
) ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "BACKUPS" ACCESS PARAMETERS ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE "P11TST"."DB2010" JOB ( "SYSTEM","SYS_EXPORT_FULL_02",175) WORKERID 1 PARALLEL 1 VERSION '11.2.0.4.0' ENCRYPTPASSWORDISNULL COMPRESSION DISABLED ENCRYPTION DISABLED ) LOCATION ('bogus.dat') ) PARALLEL 1 REJECT LIMIT UNLIMITED
AS SELECT /*+ PARALLEL(KU$,1) */ "DB2_FILIAL", "DB2_DOC", "DB2_SERIE", "DB2_EMISSA", "DB2_TIPO", "DB2_CLIFOR", "DB2_LOJA", "DB2_ITEM", "DB2_NRAVRC", "DB2_VALICM", "DB2_VALIPI", "DB2_PESO", "DB2_VOLUME", "DB2_ESPECI", "DB2_FORMUL", "D_E_L_E_T_", "R_E_C_N_O_", "R_E_C_D_E_L_", "DB2_USER"
FROM RELATIONAL("P11TST"."DB2010" NOT XMLTYPE) AS OF SCN 199794005 KU$

 

The call stack includes functions like:

... kaf4reasrp0km kdstf00001010000km kdsttgr qertbFetch rwsfcd qerlxtCBPopulate kpxsPopulateStream kpxsPopulate qxxqPopulate spefcpfa spefmccallstd pextproc pgmcetc_execute_trusted_c pgmccc_call_c pciccc_call_c kkxmcexe kgmexcb kkxmswu kgmexwi kgmexec evapls evaopn2 qximeop_fbk qximeop qxxmeop qerlxtFetch ctcdrv opiexe opiosq0 opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ...

 

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