Getting ORA-07445 [DBMS_METADATA] When Using Data Pump
(Doc ID 1987632.1)
Last updated on OCTOBER 08, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Data Pump Export (EXPDP) or Import (IMPDP) is not executing due to a fatal error and in alert log it is reported an error similar with:
ORA-07445: exception encountered: core dump [DBMS_METADATA: (Line <decimal number>)()+<decimal number>] [SIGSEGV] [ADDR:<hexa number>] [PC:<hexa number>] [Address not mapped to object] []
The incident trace file contains the following information:
----- Current SQL Statement for this session (sql_id=7ksuup9sft5ax) -----
BEGIN
SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_03', 'SYS', 0);
END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xa9a901a0 4559 package body SYS.DBMS_METADATA
0xa9f99980 1824 package body SYS.KUPW$WORKER
0xa9e88ec0 2 anonymous block
STACK TRACE:
-----------------
DBMS_METADATA <- DBMS_METADATA <- pevm_NCAL <- pen_XCAL_i <- KUPW$WORKER <- 1824 <- pevm_NCAL <- pfrinstr_XCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute <- kupprwp <- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain
BEGIN
SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_03', 'SYS', 0);
END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xa9a901a0 4559 package body SYS.DBMS_METADATA
0xa9f99980 1824 package body SYS.KUPW$WORKER
0xa9e88ec0 2 anonymous block
STACK TRACE:
-----------------
DBMS_METADATA <- DBMS_METADATA <- pevm_NCAL <- pen_XCAL_i <- KUPW$WORKER <- 1824 <- pevm_NCAL <- pfrinstr_XCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute <- kupprwp <- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |