My Oracle Support Banner

Ora-07445: Exception Encountered: Core Dump [Kudmnli()+376] when running a query against external table remotely (Doc ID 580220.1)

Last updated on APRIL 16, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1
Oracle Net Services - Version: 10.1.0.2.0 to 10.2.0.1.0
This problem can occur on any platform.

Symptoms

The alert log gives the below error message when an SQL is run against an external table remotely. Client terminates with ORA-3113 . When the query is run locally , it works.

ORA-07445: exception encountered: core dump [kudmnli()+376] [SIGSEGV] [Address not mapped to object] [0x000000038] [] []

Listener services show the static registration of the database service.

Client trace shows:

    ......
    [07-MAY-2008 17:01:59:525] nspsend: 00 21 73 65 6C 65 63 74  |.!select|
    [07-MAY-2008 17:01:59:525] nspsend: 20 2A 20 66 72 6F 6D 20  |.*.from.|
    [07-MAY-2008 17:01:59:525] nspsend: 6C 6D 73 36 35 75 73 72  |lms65usr|
    [07-MAY-2008 17:01:59:525] nspsend: 2E 74 65 6D 70 6C 72 6E  |.templrn|
    [07-MAY-2008 17:01:59:525] nspsend: 74 62 6C 00 00 00 01 00  |tbl.....|
    .......
    [07-MAY-2008 17:01:59:525] nsprecv: entry
    [07-MAY-2008 17:01:59:526] nsprecv: reading from transport...
    [07-MAY-2008 17:01:59:526] nttrd: entry
    [07-MAY-2008 17:02:01:171] nttrd: exit
    [07-MAY-2008 17:02:01:171] ntt2err: entry
    [07-MAY-2008 17:02:01:171] ntt2err: Read unexpected EOF ERROR on 10
    [07-MAY-2008 17:02:01:171] ntt2err: exit
    [07-MAY-2008 17:02:01:172] nsprecv: error exit
    [07-MAY-2008 17:02:01:172] nserror: entry
    [07-MAY-2008 17:02:01:172] nserror: nsres: id=0, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0,
    nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
    [07-MAY-2008 17:02:01:172] nsrdr: error exit
    [07-MAY-2008 17:02:01:172] nsdo: nsctxrnk=0
    [07-MAY-2008 17:02:01:172] nsdo: error exit
    [07-MAY-2008 17:02:01:172] nioqer: entry
    [07-MAY-2008 17:02:01:172] nioqer:  incoming err = 12151
    [07-MAY-2008 17:02:01:172] nioqce: entry
    [07-MAY-2008 17:02:01:172] nioqce: exit
    [07-MAY-2008 17:02:01:172] nioqer:  returning err = 3113
    [07-MAY-2008 17:02:01:172] nioqer: exit
    [07-MAY-2008 17:02:01:172] nioqrc: exit
    [07-MAY-2008 17:02:01:172] nioqrs: entry
    [07-MAY-2008 17:02:01:172] nioqrs:  state = normal (0)
    [07-MAY-2008 17:02:01:172] nioqrs:  reset called, but connection in EOF state.

 

Server trace :

    .......
    [12-MAY-2008 21:23:42:934] nsprecv: 01 00 1E 04 2A 00 00 00  |....*...|
    [12-MAY-2008 21:23:42:934] nsprecv: 01 00 20 11 68 00 00 00  |....h...|
    [12-MAY-2008 21:23:42:934] nsprecv: 00 21 73 65 6C 65 63 74  |.!select|
    [12-MAY-2008 21:23:42:934] nsprecv: 20 2A 20 66 72 6F 6D 20  |.*.from.|
    [12-MAY-2008 21:23:42:934] nsprecv: 6C 6D 73 36 35 75 73 72  |lms65usr|
    [12-MAY-2008 21:23:42:934] nsprecv: 2E 74 65 6D 70 6C 72 6E  |.templrn|
    [12-MAY-2008 21:23:42:934] nsprecv: 74 62 6C 00 00 00 01 00  |tbl.....|
    [12-MAY-2008 21:23:42:934] nsprecv: 00 00 00 00 00 00 00 00  |........|
    .....
    ......
    [12-MAY-2008 21:23:42:934] nsrdr: NSPTDA flags: 0x0
    [12-MAY-2008 21:23:42:934] nsrdr: normal exit
    [12-MAY-2008 21:23:42:934] nsdo: *what=1, *bl=2001
    [12-MAY-2008 21:23:42:934] nsdo: nsctxrnk=0
    [12-MAY-2008 21:23:42:934] nsdo: normal exit
    [12-MAY-2008 21:23:42:934] nioqrc: exit
    [12-MAY-2008 21:23:42:936] nioqsn: entry
    [12-MAY-2008 21:23:42:936] nioqsn: exit

 

Server terminates after receiving the select query from the cleint. At the same time alert log reports ORA-7445 error with a core dump. Client receives ORA-3113 .

Listener Trace :

[07-MAY-2008 17:02:27:020] nlpcaini: env[13] = TNS_ADMIN=/oracle/GEN02/product/10.1.0.4/network/admin
[07-MAY-2008 17:02:27:020] nlpcaini: env[14] = ORA_NLS10=/oracle/GEN01/product/10.2.0.3/nls/data

 

Listener trace shows the ORA_NLS10 is picking up the incorrect path.

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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