Last updated on OCTOBER 27, 2016
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1Oracle 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
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