Troubleshooting
Problem
If you configured unfenced Oracle wrapper working with Oracle 11gR2 client, you will encounter DB2 crash or ORA-01013 error intermittently.
Symptom
Currently, two cases were encountered.
Case 1: Running a query against Oracle nickname failed with an ORA-01013 error without any interrupt operation performed.
Case 2: DB2 instance crashed with a stack similar to below:
<POFDisassembly>
nsgetcinfo + 0x00cc (/oracle/app/oracle/product/11.2.0/client_1/lib/libclntsh.so.11.1)
0x00002B7A66C9DED8 : 4D8B942458050000
</POFDisassembly>
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002B79F4F0C0E7 ossDumpStackTraceEx + 0x01f7
(/opt/ibm/db2/V9.5/lib64/libdb2osse.so.1)
0x00002B79F4F07BBA _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00b4
(/opt/ibm/db2/V9.5/lib64/libdb2osse.so.1)
0x00002B79F4F07C81 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x0009
(/opt/ibm/db2/V9.5/lib64/libdb2osse.so.1)
0x00002B79F1263C19 sqlo_trce + 0x0425
(/opt/ibm/db2/V9.5/lib64/libdb2e.so.1)
0x00002B79F12A5D24 sqloEDUCodeTrapHandler + 0x0138
(/opt/ibm/db2/V9.5/lib64/libdb2e.so.1)
0x000000398D40E4C0 address: 0x000000398D40E4C0 ; dladdress: 0x000000398D400000 ; offset in lib: 0x000000000000E4C0 ;
(/lib64/libpthread.so.0)
0x00002B7A66C9DED8 nsgetcinfo + 0x00cc
(/oracle/app/oracle/product/11.2.0/client_1/lib/libclntsh.so.11.1)
0x00002B7A67A0BFCD address: 0x00002B7A67A0BFCD ; dladdress: 0x00002B7A66793000 ; offset in lib: 0x0000000001278FCD ;
(/oracle/app/oracle/product/11.2.0/client_1/lib/libclntsh.so.11.1)
0x00002B7A67A13330 address: 0x00002B7A67A13330 ; dladdress: 0x00002B7A66793000 ; offset in lib: 0x0000000001280330 ;
(/oracle/app/oracle/product/11.2.0/client_1/lib/libclntsh.so.11.1)
0x00002B7A67A133BB address: 0x00002B7A67A133BB ; dladdress: 0x00002B7A66793000 ; offset in lib: 0x00000000012803BB ;
(/oracle/app/oracle/product/11.2.0/client_1/lib/libclntsh.so.11.1)
0x00002B7A67C2A886 sslssAsynchHdlr + 0x0160
(/oracle/app/oracle/product/11.2.0/client_1/lib/libclntsh.so.11.1)
0x00002B7A67C2A1A1 sslsshandler + 0x0091
(/oracle/app/oracle/product/11.2.0/client_1/lib/libclntsh.so.11.1)
If the DB2 crash happened on AIX, "errpt -a" will also print a similar stack:
nsgetcinf 54
nioqih 24
nioqih 24
nigsuiint 88
nigsuihdl 64
sslssAsyn 16C
sslsshand D4
??
[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Sources and Wrappers - Oracle","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.5;9.7;10.1;10.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21499426