ORA-7445 [kokscold()+849] from Job Queue Process Running SQL Analyze (Doc ID 1115493.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 14-May-2013***

Symptoms

A job queue process fails with an error like:

ORA-07445: exception encountered: core dump [kokscold()+849] [SIGSEGV][ADDR:0x50] [PC:0x115E15F] [Address not mapped to object] []


The trace file shows the current SQL statement as something like:

/* SQL Analyze(397,1) */ MERGE INTO MGMT_ARU_PATCH_RECOMMENDATIONS p USING ...


With a PL/SQL stack like:

----- PL/SQL Call Stack -----
object line object
handle number name
0xc8dfd590 11774 package body SYS.DBMS_SQLTUNE_INTERNAL
0xdd8a6408 7 SYS.WRI$_ADV_SQLTUNE
0xdd6b9790 545 package body SYS.PRVT_ADVISOR
0xdd6b9790 2613 package body SYS.PRVT_ADVISOR
0xc8f9d120 241 package body SYS.DBMS_ADVISOR
0xc8e22780 772 package body SYS.DBMS_SQLTUNE
0xc88a6ae0 4 anonymous block


The disassemble shows:

> (0x115e15f) mov 0x50(%r11),%rdx
(0x115e163) movzbl 0x1(%r13),%ecx
(0x115e168) movzbl 0x1(%r15),%r9d
(0x115e16d) mov 0x8(%rdx),%edx
(0x115e170) lea 0x10(%r13),%r8


and the call stack is:

----- Call Stack Trace -----
... kokscold insolic insSetColumnInfo inspre0 upspre0 qkadml qkastmt qkadrv opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc opiexe ...

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