SM50 show Errors for Dialogue Work processes & back ground processes

[Former Member]

Hello all .

We are using Netweaver 04 system and HP-UX Operating system ORACLE 10.2.0.4.0.

We have some problme with System.

SM50 show Errors for Dialogue Work processes & back ground processes

No Ty. PID Status Reasn Start Err

DIA 3609 waiting Yes 15

DIA 3685 running Yes 15

DIA 5192 waiting Yes 15

DIA 15194 waiting Yes 15

DIA 4629 waiting Yes 15

DIA 28207 waiting Yes 10

Work process receiving a signal11 from Operating system and work process is restarting.

SM 21 logs

****

10:30:43 DIA 004 000 DDIC Q0E Signal 11 received by operating system

10:30:43 DIA 004 Q01 Start Workproc 4, 16 times since system startup. PID 4629

****

Dev_w0 error logs

M * LOCATION SAP-Server s96csvib1_IB1_00 on host s96csp26 (wp 5)

M * ERROR ThSigHandler: signal

M *

M C-STACK

(0) 0x40000000021f69e0 CTrcStack2 + 0x1b0 at dptstack.c:220 [dw.sapIB1_DVEBMGS00]

(1) 0x40000000045ee6f0 SigIGenAction + 0x540 at sigux.c:897 [dw.sapIB1_DVEBMGS00]

(2) 0xe00000012d9a6f80 Signal 11 (SIGSEGV) delivered

(3) 0x0000000000000000 .PLT0 + 0x3ffffffffff45f50 [/usr/lib/hpux64/dld.so]

(4) 0xc00000001ecbba30 LsxAnnotation + 0xefa10 [/oracle/client/92x_64/lib/libclntsh.so.9.0]

(5) 0xc00000001e32b450 nioqwa + 0xf0 [/oracle/client/92x_64/lib/libclntsh.so.9.0]

(6) 0xc00000001e03d030 upirtrc + 0x740 [/oracle/client/92x_64/lib/libclntsh.so.9.0]

(7) 0xc00000001df8b320 kpurcsc + 0xe0 [/oracle/client/92x_64/lib/libclntsh.so.9.0]

(8) 0xc00000001deecba0 kpuexecv8 + 0xb60 [/oracle/client/92x_64/lib/libclntsh.so.9.0]

(9) 0xc00000001def3070 kpuexec + 0x1b50 [/oracle/client/92x_64/lib/libclntsh.so.9.0]

(10) 0xc00000001dfd83e0 OCIStmtExecute + 0x60 [/oracle/client/92x_64/lib/libclntsh.so.9.0]

(11) 0xc0000000132b8000 oci_execute_stmt + 0x160 at dboci.c:1684 [/usr/sap/IB1/SYS/exe/run/dboraslib.so]

(12) 0xc0000000132efab0 stmt_fetch + 0x550 at dbsloci.c:12937 [/usr/sap/IB1/SYS/exe/run/dboraslib.so]

(13) 0xc0000000132d5f50 exec_fetch + 0x240 at dbsloci.c:8881 [/usr/sap/IB1/SYS/exe/run/dboraslib.so]

(14) 0xc0000000132d3270 DbSlRead + 0x950 at dbsloci.c:2606 [/usr/sap/IB1/SYS/exe/run/dboraslib.so]

(15) 0x4000000003772350 dbsl_read + 0x150 at dbslxxx.c:488 [dw.sapIB1_DVEBMGS00]

(16) 0x40000000035be7b0 dbsl_call + 0x150 at dbtran.c:7221 [dw.sapIB1_DVEBMGS00]

(17) 0x40000000035b77e0 dbsl_exec + 0x120 at dbtran.c:6975 [dw.sapIB1_DVEBMGS00]

(18) 0x40000000035b0670 select_single + 0x730 at dbtran.c:3308 [dw.sapIB1_DVEBMGS00]

(19) 0x40000000035acf20 db_tran94 + 0x360 at dbtran.c:2480 [dw.sapIB1_DVEBMGS00]

(20) 0x4000000003597bf0 call_tran + 0xb0 at dbrsql.c:12715 [dw.sapIB1_DVEBMGS00]

(21) 0x400000000358b7e0 read_handling + 0xcf0 at dbrsql.c:4053 [dw.sapIB1_DVEBMGS00]

(22) 0x4000000003587cf0 db_rsql1994 + 0x640 at dbrsql.c:2546 [dw.sapIB1_DVEBMGS00]

(23) 0x4000000002901960 Z10CallRsql949ABAPTRCLP8RSQLINFOP12RS_STATEMENT + 0x140 [dw.sapIB1_DVEBMGS00]

(24) 0x4000000002930320 Z15SqlsExecuteCallhP11DynCallInfo + 0x100 [dw.sapIB1DVEBMGS00]

(25) 0x40000000016aae50 Z8abjsqlsv + 0x23d0 [dw.sapIB1_DVEBMGS00]

(26) 0x40000000016e6830 Z8abextriv + 0x300 [dw.sapIB1_DVEBMGS00]

(27) 0x400000000168b150 Z9abxeventPKt + 0xb0 at abrunt1.c:263 [dw.sapIB1_DVEBMGS00]

(28) 0x40000000016445b0 ab_dstep + 0x1f0 at abdynpro.c:183 [dw.sapIB1_DVEBMGS00]

(29) 0x40000000022db120 dynpmcal + 0x720 at dymainstp.c:2375 [dw.sapIB1_DVEBMGS00]

(30) 0x40000000022d5650 dynppai0 + 0x510 at dymainstp.c:941 [dw.sapIB1_DVEBMGS00]

(31) 0x40000000022d8980 dynprctl + 0x390 at dymainstp.c:349 [dw.sapIB1_DVEBMGS00]

(32) 0x40000000022c4410 dynpen00 + 0xa90 at dymain.c:1457 [dw.sapIB1_DVEBMGS00]

(33) 0x4000000001f259f0 Thdynpen00 + 0x490 at thxxhead.c:4527 [dw.sapIB1_DVEBMGS00]

(34) 0x4000000001ef2c60 TskhLoop + 0x2530 at thxxhead.c:3812 [dw.sapIB1_DVEBMGS00]

(35) 0x4000000001eeb480 tskhstart + 0x3a0 at thxxhead.c:1041 [dw.sapIB1_DVEBMGS00]

(36) 0x4000000001dc18f0 DpMain + 0x490 at dpxxdisp.c:1038 [dw.sapIB1_DVEBMGS00]

(37) 0x4000000001572dd0 nlsui_main + 0x30 [dw.sapIB1_DVEBMGS00]

(38) 0x4000000001572d60 main + 0x70 [dw.sapIB1_DVEBMGS00]

(39) 0xc000000000032f90 main_opd_entry + 0x50 [/usr/lib/hpux64/dld.so]

M

And also i found the SYSTEM_CORE_DUMPED Dumps.

System is running but in sm50 count of errors are incresing.

Please some help me u2026to find out what was problme with system.

Goud

Edited by: Goud T on Nov 13, 2009 12:59 PM

[Former Member]

Hello Mark Norman

Thnaks a lot..

Problem was with Old oracle client.. we installed new oracle client. and problem resolved.

Could you pls share me ..where you identified the old client details in trace files.

Thanks

[Former Member]

Hi,

why are you using a 9.2 client on a 10.2 database. upgrade your client..

Regards

Mark

[Former Member]

Please check the trace files from work directory for detailed info. for example dev_w0, dev_w1 etc.