Import Fails With Errors ORA-3113 ORA-7445 And Trace File Shows ALTER TYPE COMPILE (Doc ID 1301574.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8 and later   [Release: 9.2 and later ]
Information in this document applies to any platform.

Symptoms

Traditional import (IMP) is failing with errors:

IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully

Alert.log file contains an ORA-7445 error. The corresponding trace file shows the following was being attempted:

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Current SQL statement for this session:
ALTER TYPE "TIA"."TP_UO_PATH" COMPILE SPECIFICATION REUSE SETTINGS

The error stack contains the functions:

ksedmp <- ssexhd <- 0000441C <- kottins <- kotnoins <- kotpcty <- koktalt <- opiexe <- opiosq0 <- opiosq <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- rpisplu <- rpispl <- kqlvld <- kglgob <- kgldpo <- kgldon <- pkldon <- pkloud <- phnnrl_name_resolve <- by_loading <- phngdl_get_defining <- libunit <- phnrpls_resolve_pre <- fix_libscope <- phnrp_resolve_prefi <- phnr_resolve <- ph2nam <- ph2con <- ph2tys <- ph2typ <- ph2dty <- ph2uni <-
<- kkxcmp0 <- rpiswu2 <- kkxcmp <- kkpcrt <- opiexe <- opiosq0 <- opiosq <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o

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