ora-7445 [kkoitbp] running a query on a complex view (Doc ID 979442.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
Issue reproduces in 10.2.0.4 It does not reproduce in 11.1.0.x.

Symptoms

A query on a complex view fails with ora-1013. Correspondingly ORA-7445 is seen in the alertlog.


ORA-07445: exception encountered: core dump [kkoitbp()+928] [SIGSEGV] [Address not mapped to object] [0x0] [] []


kkoitbp <- kkotap <- kkoiqb <- kkooqb <- kkoqbc
apakkoqb <- apaqbdDescendents <- apaqbdListReverse <- apaqbd <- apaqbdDescendents
apaqbdListReverse <- apaqbd <- apaqbdDescendents <- apaqbdListReverse <- apaqbd
apadrv <- opitca <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc
kkspsc0 <- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8
opiodr <- ttcpip <- opitsk <- opiino <- opiodr
opidrv <- sou2o <- opimai_real.........

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