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 AUGUST 04, 2018
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:
- Your platform is IBM AIX.
- The current PSU is 11.2.0.2.2
- Issue matches unpublished Bug 9877980, but patch 9877980 is already in place.
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] []
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()]
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |