ORA-7445 [Ksxpmprp] (Doc ID 857393.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Apr-2013***

Symptoms

You encounter the following intermittent ORA-7445 errors:

ORA-07445: exception encountered: core dump [ksxpmprp()+42] [SIGSEGV] [ADDR:0x14] [PC:0x3EB76C8][Address not mapped to object] []


The stack trace will show similar to the following:

ksxpmprp <- kclpbuf <- kclprepare <- kcllkopb <- kclgrlk <- kcbzib <- kcbgcur <- ktbgcur <- kdoiur <- kcoubk <- ktundo <- ktubko <- ktuabt <- ktcrab <- ktcsod <- kssdch <- ksuxds

 

The trace file would show that there are at least 2 session state objects pointing to the same
process state object.

While having opened the trace file, search for string "(session) sid" and will find
following sessions in this example:

    (session) sid: 5062 ser: 9244 trans: 0xb8bce8218, creator: 0xb80081c68
    (session) sid: 5047 ser: 49958 trans: 0xb8bce6508, creator: 0xb80081c68
    (session) sid: 5115 ser: 20390 trans: 0xb8bf99178, creator: 0xb80081c68


All these sessions have the same "creator" which points to the process state object.


With this example the creator: 0xb80081c68 points to identical process state object (proc=0xb8001cf90)
which is a clear confirmation for this bug:

process: 0xb8001cf90, call: 0xba121b100, xact: 0xb8c32a758, curses: 0xb83ffba28, usrses: 0xb83ffba28
  ----------------------------------------
  SO: 0xb8001cf90, type: 2, owner: 0x0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
   proc=0xb8001cf90, name=process, file=ksu.h LINE:10706 ID:, pg=0
  (process) Oracle pid:89, ser:225, calls cur/top: 0xba121b100/0xba121b100
            flags : (0x0) -
            flags2: (0x800),  flags3: (0x0)
            int error: 0, call error: 0, sess error: 0, txn error 0

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