ORA-07445 [smboCkaGetPivot()+176] ERROR HIT FROM VARIOUS SELECT BASED SQL (Doc ID 1624100.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Standard Edition - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

The following symptoms are known to be directly atrributed to this issue :-

a) Database is 10gR2

b) Error of following nature is seen in the alert log :-

ORA-07445: exception encountered: core dump [smboCkaGetPivot()+240] [SIGSEGV] [Invalid permissions for mapped object] [0x000000110] [] []

c) Stack trace will be similar to :-


Function List   (to Full stack)   (to Summary stack)

    smboCkaGetPivot <- smboCkaQS <- smboAQSdoQS <- smboAQSdoRS <- smboAQSdoQS
       <- smboSort <- smbeod <- soreod <- qersoFetch <- opifch2
        <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
         <- opiodr <- opidrv <- sou2o <- opimai_real <- main
          <- main_opd_entry

d) The ORA-07445 trace file will show that the EXPLAIN PLAN can be generated so this is not an EXPLAIN PLAN issue

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