ORA-7445 [evaopn2()] From Query Using Functional Index (Doc ID 749204.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
RDBMS 10.2.0.4
Checked for relevance on 01-Nov-2011

Symptoms

When running a query on a table having a functional index and using linguistic sorts (nls_sort='BINARY_CI' and nls_comp='LINGUISTIC'), it may core dump in evaopn2():

ORA-07445: exception encountered: core dump [evaopn2()+228] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

The call stack looks similar to:

... evaopn2 evareo evaior qertbFetchByRowID ...

The query has a functional inlist ie. a list of OR'ed conditions like:

SQL> select .... from ...
      where (<condition1> OR <condition2> OR <condition3> OR ...)

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