ORA-7445 [intel_fast_memcpy] or ORA-7445 [kgidmp] with LDAP(REVERSE()) (Doc ID 1380369.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.1.0.6 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 03-Jun-2013***

Symptoms

- The expression LPAD(REVERSE(( )) used in a select statement generates a failure with ORA-3113 reported on the client interface.

- For this failure, the alert.log file contains the following ORA-7445 error:

ORA-7445: exception encountered: core dump [_intel_fast_memcpy.A()+10]

or occasionally:

ORA-7445: exception encountered: core dump [kgidmp()+613] [SIGSEGV]

- Review of the generated tracefiles reveals a call stack similar to:

 intel_fast_memcpy  evalpa evaopn2 evaopn2 kpofcr qerstRowP
qerstRowP kdstf0000101km kdsttgr qertbFetch qerstFetch qergiFetch qerstFetch

- The example below reproduces the error:
 
SQL> create table test (col number);
SQL> insert into test values (100);
SQL> select LPAD (REVERSE (col), 2) from test;
select LPAD (REVERSE (col), 2) from TEST
*
ERROR at line 1:
ORA-3113: end-of-file on communication channel

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