My Oracle Support Banner

Create Function-Based Index Fails With ORA-07445 [kokqodec()+25] (Doc ID 1662601.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Create function-based index with invalid DECODE fails with ORA-07445 [kokqodec()+25]


Alert.log:

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x10552A7, kokqodec()+25]
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_20466.trc  (incident=1088554):
ORA-07445: exception encountered: core dump [kokqodec()+25] [SIGSEGV] [ADDR:0x0] [PC:0x10552A7] [SI_KERNEL(general_protection)] []


Incident file:

Dump continued from file: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_20466.trc
ORA-07445: exception encountered: core dump [kokqodec()+25] [SIGSEGV] [ADDR:0x0] [PC:0x10552A7] [SI_KERNEL(general_protection)] []

========= Dump for incident 1088554 (ORA 7445 [kokqodec()+25]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x10552A7, kokqodec()+25]
Registers:
...
*** 2014-03-18 07:12:46.389
----- Current SQL Statement for this session (sql_id=0unn5g7rvrpg1) -----
create index <index_name> on <table_name>(decode(instr(lower(<col1>), 'cme', 0, null, 1)))


Stack trace:

kokqodec kokqbpo kokqbpt kokqoae kkmie2c kkmpqaq kkmpqcbk qcspqbDescendents qcspqb kkmdrv opiSem opiprs
kksParseChildCursor rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx
kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main




Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.