ORA-07445 [kxspoac()] when cursor_sharing = FORCE (Doc ID 1476804.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Alert log reports error message

Errors in file /opt/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4848.trc  (incident=36521):
ORA-07445: exception encountered: core dump [kxspoac()+707] [SIGSEGV] [ADDR:0x1] [PC:0x8450C13] [Address not mapped to object] []

Trace file ( incident if 11g normal trace file if 10g ) generated by the error message shows the below call stack containing kxspoac <- opibnd0 <- opibnd <- opibrp

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
       <- ssexhd <- restore_rt <- kxspoac <- opibnd0 <- opibnd
        <- opibrp <- opiall0 <- opial7 <- opiodr <- ttcpip
         <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
          <- opimai_real <- ssthrdmain <- main <- libc_start_main <- start

Current SQL in the trace file indicates the query is run with BIND variables attached to it.         

SELECT JOBIT_ID,TO_CHAR(DATE_EXPLAIN,:"SYS_B_0")DATE_EXPLAIN,SJ.STATUS_NAME,INITIAL_SYMPTOMS,OFF_ID,NOTE_USER FROM JOB_IT,STATUS_JOB SJ WHERE OFF_ID =:"SYS_B_1"AND DATE_RECEIVE IS NULL AND JOB_IT.STATUS_ID = SJ.STATUS_ID ORDER BY JOBIT_ID ASC

 The cursor_sharing parameter is set to a non default value. These include FORCE or SIMILAR

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