disp+work stopped. Why ??

[Former Member]

Hi,

the server cannot start. I see in the nodes tree under Process Lists 3 entries:

msg_server.exe --> running

disp+work.exe --> stopped

igswd.exe --> stopped

what is the reason that disp+work has stopped ??

If I go to the syslog node I see the following error message:

operating system call gethostbyname failed (error 11004)

perform rollback

transaction cancelled

I cannot check reports or transaction because I still cannot log on.

what should I do ??

[Former Member · Accepted solution]

check the dev_disp, dev_w0 for more details, these are avaialble under instance work directory.

[Former Member · Accepted solution]

Hi,

sorry, I am not confident in SAP basis. I see in the file dev_w0 this error messages:

C Thu Jan 20 21:04:03 2011
C  *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
 [dboci.c      4172]
C  *** ERROR => CONNECT failed with sql error '12541'
 [dbsloci.c    10933]

C Thu Jan 20 21:04:05 2011
C  *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
 [dboci.c      4172]
C  *** ERROR => CONNECT failed with sql error '12541'
 [dbsloci.c    10933]
B  ***LOG BY2=> sql error 12541  performing CON [dbsh#2 @ 1204] [dbsh    1204 ]
B  ***LOG BY0=> ORA-12541: TNS:no listener [dbsh#2 @ 1204] [dbsh    1204 ]
B  ***LOG BY2=> sql error 12541  performing CON [dblink#3 @ 431] [dblink  0431 ]
B  ***LOG BY0=> ORA-12541: TNS:no listener [dblink#3 @ 431] [dblink  0431 ]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10156]

and in the file dev_disp I see these errors:

Thu Jan 20 20:59:55 2011
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  5273]

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1050]
DpMsgAdmin: Set patchno for this platform to 75
Release check o.K.

Thu Jan 20 21:04:11 2011
*** ERROR => W0 (pid 1784) died [dpxxdisp.c   14241]
*** ERROR => W1 (pid 900) died [dpxxdisp.c   14241]
*** ERROR => W2 (pid 684) died [dpxxdisp.c   14241]
*** ERROR => W3 (pid 3952) died [dpxxdisp.c   14241]
*** ERROR => W4 (pid 1420) died [dpxxdisp.c   14241]
*** ERROR => W5 (pid 1260) died [dpxxdisp.c   14241]
my types changed after wp death/restart 0xbf --> 0xbe
*** ERROR => W6 (pid 3456) died [dpxxdisp.c   14241]
my types changed after wp death/restart 0xbe --> 0xbc
*** ERROR => W7 (pid 1472) died [dpxxdisp.c   14241]
my types changed after wp death/restart 0xbc --> 0xb8
*** ERROR => W8 (pid 604) died [dpxxdisp.c   14241]
*** ERROR => W9 (pid 1148) died [dpxxdisp.c   14241]
*** ERROR => W10 (pid 376) died [dpxxdisp.c   14241]
my types changed after wp death/restart 0xb8 --> 0xb0
*** ERROR => W11 (pid 1616) died [dpxxdisp.c   14241]
my types changed after wp death/restart 0xb0 --> 0xa0
*** ERROR => W12 (pid 1632) died [dpxxdisp.c   14241]
my types changed after wp death/restart 0xa0 --> 0x80
*** DP_FATAL_ERROR => DpWPCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***

do you see something of interest ?? any clue ??

[Former Member · Accepted solution]

>>***LOG BY0=> ORA-12541: TNS:no listener

have you started the listener? please check using below command

lsnrctl status (if not running start using below command)

lsnrctl start

BTW: you have opend the messaged in wrong forum, as you have oracle DB not DB2(DB6)

[nirmal_konchada · Accepted solution]

Hi,

follw below steps :

1. Stop your SAP MS

2. Start listener

3. Type R3trans -d from sidadm and paster the RC here.

Regards,

Nirmal.K

[Former Member · Accepted solution]

Hallo Sunil,

I checked the status of the listener and it is Ok. I started the listener again just in case but the problem exists and the report tells me this:

service DEV has 1 instance

Instance DEV status unknown, has 1 handler for this service.

What should I do now ??

[johannes_heinrich]

Moved to SAP on Oracle forum.

Regards,

Johannes