ORA-7445 [kkslMarkLiteralBinds()] Still Occurs Even When Patch 9877980 For 11.2.0.2.2 Is Already In Place On AIX (Doc ID 1386167.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
IBM AIX on POWER Systems (64-bit)

Symptoms

Important points: 

In alert log, you may see many instances of the following error:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xB38F0000000121] [PC:0x10489DCA8, kkslMarkLiteralBinds()+520] [flags: 0x0, count: 1]
ORA-07445: exception encountered: core dump [kkslMarkLiteralBinds()+520] [SIGSEGV] [ADDR:0xB38F0000000121] [PC:0x10489DCA8] [Address not mapped to object] []


The stack trace will be similar to the following:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd <- 47dc <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- start


Issue is simple to reproduce as:

SQL> create table abc(c1 number, c2 number, c3 number, c4 number, c5 number, c6 number, c7 number);

Table created.

SQL> var b0 number;
var b1 number;
var b2 number;
var b3 number;
var b4 number;
var b5 number;
var b6 number;
var b7 number;
var b8 number;

SQL> alter session set cursor_sharing=similar;

Session altered.

SQL> update ABC set c1 = :b0:b1, c2 = :b2:b3, c3 = :b4:b5
where c4=:b6 and c5=:b7 and c6=:b8 and c7 in (100,200);
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 454806

In alert log, you see ORA-07445 [kkslMarkLiteralBinds()]

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