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

(Doc ID 1662601.1)

Last updated on JUNE 12, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 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 /opt/oracle/diag/rdbms/sr1rsd20/SR1RSD21/trace/SR1RSD21_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: /opt/oracle/diag/rdbms/sr1rsd20/SR1RSD21/trace/SR1RSD21_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 trade_cme on trade(decode(instr(lower(clearing_house), '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




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