ORA-07445 [qcplgte_multibyte()+242] Error For Oracle Net Client Session (Doc ID 2003930.1)

Last updated on MAY 29, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Trying to create a spatial index, it kills the session saying

SQL Error: No more data to read from socket.


The alert log shows an ORA-07445:

ORA-07445: exception encountered: core dump [qcplgte_multibyte()+242] [SIGSEGV] [ADDR:0x7FFF8E668F78] [PC:0xBE29182] [Address not mapped to object] []


The trace file shows information like:

Memory (Avail / Total) = 149871.83M / 193796.35M
Swap (Avail / Total) = 195327.99M /  195327.99M

 qcplgte_multibyte()+227 (0xbe29173) cmp %rax,%rsi
 qcplgte_multibyte()+230 (0xbe29176) jz 0xbe2ae9b
 qcplgte_multibyte()+236 (0xbe2917c) mov %rbx,%rdi
 qcplgte_multibyte()+239 (0xbe2917f) mov %r12,%rsi
> qcplgte_multibyte()+242 (0xbe29182) call 0x32b0f40
 qcplgte_multibyte()+247 (0xbe29187) movzbl %al,%eax
 qcplgte_multibyte()+250 (0xbe2918a) test %eax,%eax
 qcplgte_multibyte()+252 (0xbe2918c) jz 0xbe297fc
 qcplgte_multibyte()+258 (0xbe29192) cmp $47,%eax


Current SQL information unavailable - no cursor.

[TOC00005]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x62fa7a808        10  MDSYS.SDO_INDEX_METHOD_10I


----- Call Stack Trace -----

... qcplgte_multibyte qcplgte qcplgnt prscmd prsdrv opiParse opiprs kksParseChildCursor rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 opiall0 opikpr opiodr ...


o  A "call" statement like above is rather unusual to fail on. The ADDR argument value of the exception is also unusual as this looks like a stack frame address.

o  When we try the operation directly from a sqlplus session on the server, this works fine, 

o  Checking ulimit shows next results:

 

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