SAP dispatcher status is stopped in Console how can i start it

[Former Member]

Hi All

Help me out

*SAP dispatcher status is stopped in Console how can i start it

Dispatcher turns green to yellow suddenly and status changes to stopped and all WP elemets shows status as ended.

Alert from Syslog : SAP Basis System: Message server disconnected

Tracert : Disp+work.exe

-

---

trc file: "dev_disp", trc level: 1, release: "640"

-

---

Thu Oct 02 12:32:52 2008

kernel runs with dp version 128(ext=102) (@(#) DPLIB-INT-VERSION-128)

length of sys_adm_ext is 312 bytes

systemid 560 (PC with Windows NT)

relno 6400

patchlevel 0

patchno 21

intno 20020600

make: multithreaded, ASCII

pid 736

***LOG Q00=> DpSapEnvInit, DPStart (00 736) [dpxxdisp.c 1100]

shared lib "dw_xml.dll" version 21 successfully loaded

shared lib "dw_xtc.dll" version 21 successfully loaded

shared lib "dw_stl.dll" version 21 successfully loaded

shared lib "dw_gui.dll" version 21 successfully loaded

Thu Oct 02 12:32:58 2008

• 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 3886]

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: JAVA is not active

DpShMCreate: sizeof(wp_adm) 6624 (828)

DpShMCreate: sizeof(tm_adm) 2219848 (11044)

DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

DpShMCreate: sizeof(comm_adm) 192000 (384)

DpShMCreate: sizeof(vmc_adm) 0 (320)

DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

DpShMCreate: SHM_DP_ADM_KEY (addr: 05270040, size: 2505416)

DpShMCreate: allocated sys_adm at 05270040

DpShMCreate: allocated wp_adm at 052717A8

DpShMCreate: allocated tm_adm_list at 05273188

DpShMCreate: allocated tm_adm at 052731B0

DpShMCreate: allocated wp_ca_adm at 054910F8

DpShMCreate: allocated appc_ca_adm at 05495748

DpShMCreate: allocated comm_adm_list at 05496EB8

DpShMCreate: allocated comm_adm at 05496ED0

DpShMCreate: allocated vmc_adm_list at 054C5CD0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 054C5CF8

DpShMCreate: allocated wall_adm at 054C5D00

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation std

<EsNT> Memory Reset enabled as NT default

<EsNT> EsIUnamFileMapInit: Initialize the memory 2450 MB

<ES> 2449 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG Q0K=> DpMsAttach, mscon ( home) [dpxxdisp.c 9719]

CCMS: Initalizing shared memory of size 40000000 for monitoring segment.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 6400, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1025]

DpMsgAdmin: Set patchno for this platform to 21

Release check o.K.

Thu Oct 02 12:33:38 2008

• ERROR => W0 (pid 1500) died [dpxxdisp.c 12170]

• ERROR => W1 (pid 3796) died [dpxxdisp.c 12170]

my types changed after wp death/restart 0xbf --> 0xbe

• ERROR => W2 (pid 3548) died [dpxxdisp.c 12170]

my types changed after wp death/restart 0xbe --> 0xbc

• ERROR => W3 (pid 1464) died [dpxxdisp.c 12170]

my types changed after wp death/restart 0xbc --> 0xb8

• ERROR => W4 (pid 3368) died [dpxxdisp.c 12170]

• ERROR => W5 (pid 3400) died [dpxxdisp.c 12170]

my types changed after wp death/restart 0xb8 --> 0xb0

• ERROR => W6 (pid 2620) died [dpxxdisp.c 12170]

my types changed after wp death/restart 0xb0 --> 0xa0

• ERROR => W7 (pid 380) died [dpxxdisp.c 12170]

my types changed after wp death/restart 0xa0 --> 0x80

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

killing W0-1500 (SIGUSR2)

• ERROR => DpWpKill(1500, SIGUSR2) failed [dpxxtool.c 2468]

killing W1-3796 (SIGUSR2)

• ERROR => DpWpKill(3796, SIGUSR2) failed [dpxxtool.c 2468]

killing W2-3548 (SIGUSR2)

• ERROR => DpWpKill(3548, SIGUSR2) failed [dpxxtool.c 2468]

killing W3-1464 (SIGUSR2)

• ERROR => DpWpKill(1464, SIGUSR2) failed [dpxxtool.c 2468]

killing W4-3368 (SIGUSR2)

• ERROR => DpWpKill(3368, SIGUSR2) failed [dpxxtool.c 2468]

killing W5-3400 (SIGUSR2)

• ERROR => DpWpKill(3400, SIGUSR2) failed [dpxxtool.c 2468]

killing W6-2620 (SIGUSR2)

• ERROR => DpWpKill(2620, SIGUSR2) failed [dpxxtool.c 2468]

killing W7-380 (SIGUSR2)

• ERROR => DpWpKill(380, SIGUSR2) failed [dpxxtool.c 2468]

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=1593

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Oct 02 12:33:48 2008

NiISelect: TIMEOUT occured (10000 ms)

dump system status

Workprocess Table (long) Thu Oct 02 07:03:48 2008

========================

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

-

---

0 DIA 1500 Ended no 1 0 0

1 DIA 3796 Ended no 1 0 0

2 UPD 3548 Ended no 1 0 0

3 ENQ 1464 Ended no 1 0 0

4 BTC 3368 Ended no 1 0 0

5 BTC 3400 Ended no 1 0 0

6 SPO 2620 Ended no 1 0 0

7 UP2 380 Ended no 1 0 0

Dispatcher Queue Statistics Thu Oct 02 07:03:48 2008

===========================

--------

---

+

---

+

---

+

---

+--

---

+

Typ

now

high

max

writes

reads

--------

---

+

---

+

---

+

---

+--

---

+

NOWP

0

3

2000

8

8

--------

---

+

---

+

---

+

---

+--

---

+

DIA

5

5

2000

5

0

--------

---

+

---

+

---

+

---

+--

---

+

UPD

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

ENQ

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

BTC

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

SPO

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

UP2

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

max_rq_id 13

wake_evt_udp_now 0

wake events total 9, udp 7 ( 77%), shm 2 ( 22%)

since last update total 9, udp 7 ( 77%), shm 2 ( 22%)

Dump of tm_adm structure: Thu Oct 02 07:03:48 2008

=========================

Term uid man user term lastop mod wp ta a/i (modes)

Workprocess Comm. Area Blocks Thu Oct 02 07:03:48 2008

=============================

Slots: 300, Used: 1, Max: 0

--------

---

+

---

+--

---

+

id

owner

pid

eyecatcher

--------

---

+

---

+--

---

+

0

DISPATCHER

-1

WPCAAD000

NiWait: sleep (5000 msecs) ...

NiISelect: timeout 5000 ms

NiISelect: maximum fd=1593

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Oct 02 12:33:53 2008

NiISelect: TIMEOUT occured (5000 ms)

Shutdown server ...

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes...

Stop gateway

killing process (676) (SOFT_KILL)

Stop icman

killing process (924) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives (PID:676 HANDLE:1564)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1593

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Oct 02 12:33:54 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:676 HANDLE:1564)

[DpProcDied] Process died (PID:924 HANDLE:1556)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

NiIMyHostName: hostname = 'home'

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 163 bytes

NiBufSend starting

NiIWrite: write 562, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9945]

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiSelClear: removed hdl 3 from selectset

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/8

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 19)

MBUF component DOWN

NiBufClose: clear extensions for hdl 3

NiBufSetStat: bufstat of hdl 3 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 3 / socket 1572

MsIDetach: detach MS-system

EsCleanup ....

Thu Oct 02 12:33:55 2008

***LOG Q05=> DpHalt, DPStop ( 736) [dpxxdisp.c 8478]

Good Bye .....

-

---

Trace from WP table DIA 1

-

---

trc file: "dev_w0", trc level: 1, release: "640"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Thu Oct 02 12:32:59 2008

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\SUD\SYS\exe\run\dboraslib.dll' ...

B Library 'C:\usr\sap\SUD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\SUD\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.19)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 21

M intno 20020600

M make: multithreaded, ASCII

M pid 1500

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 1500) [dpxxdisp.c 1160]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M DpShMCreate: sizeof(wp_adm) 6624 (828)

M DpShMCreate: sizeof(tm_adm) 2219848 (11044)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(vmc_adm) 0 (320)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 05A70040, size: 2505416)

M DpShMCreate: allocated sys_adm at 05A70040

M DpShMCreate: allocated wp_adm at 05A717A8

M DpShMCreate: allocated tm_adm_list at 05A73188

M DpShMCreate: allocated tm_adm at 05A731B0

M DpShMCreate: allocated wp_ca_adm at 05C910F8

M DpShMCreate: allocated appc_ca_adm at 05C95748

M DpShMCreate: allocated comm_adm_list at 05C96EB8

M DpShMCreate: allocated comm_adm at 05C96ED0

M DpShMCreate: allocated vmc_adm_list at 05CC5CD0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 05CC5CF8

M DpShMCreate: allocated wall_adm at 05CC5D00

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M calling db_connect ...

C Got ORACLE_HOME=C:\oracle\ora92 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPSUD's password

C Connecting as /@SUD on connection 0 ...

C Attaching to DB Server SUD (con_hdl=0,svchp=040D325C,svrhp=040D3E34)

C Starting user session (con_hdl=0,svchp=040D325C,srvhp=040D3E34,usrhp=040DC614)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c 3721]

C Detaching from DB Server (con_hdl=0,svchp=040D325C,srvhp=040D3E34)

C *** ERROR => CONNECT failed with sql error '1033'

[dbsloci.c 9753]

C Try to connect with default password

C Connecting as SAPSUD/<pwd>@SUD on connection 0 ...

C Attaching to DB Server SUD (con_hdl=0,svchp=040D325C,svrhp=040D3E34)

C Starting user session (con_hdl=0,svchp=040D325C,srvhp=040D3E34,usrhp=040DC614)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c 3721]

C Detaching from DB Server (con_hdl=0,svchp=040D325C,srvhp=040D3E34)

C *** ERROR => CONNECT failed with sql error '1033'

[dbsloci.c 9753]

B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 1195] [dbsh 1195 ]

B ***LOG BY2=> sql error 1033 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1271]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9379]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server home_SUD_00 on host home (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Thu Oct 02 12:32:59 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9555

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 246]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 1500) [dpnttool.c 357]

Thanks in advance please help me out

Edited by: sudhakar aleti on Oct 2, 2008 12:54 PM

Edited by: sudhakar aleti on Oct 2, 2008 12:56 PM

[Former Member]

Hi All

Its a problem with oracle insallation what Eric Brunelle has said

Thanks to all once again

[Former Member]

Thanks to all Gurus to put me out from this issue

[debasissahoo]

Hi Sudhakar,

Please mention the steps that you follow so that someone else in future can use this forum to solve and close the thread if issue has been solved.

Thanks,

Debasis.

[debasissahoo]

Sudhakar,

As I see the logs you posted..

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

http://dboci.c 3721

C Detaching from DB Server (con_hdl=0,svchp=040D325C,srvhp=040D3E34)

C *** ERROR => CONNECT failed with sql error '1033'

http://dbsloci.c 9753

C Try to connect with default password

C Connecting as SAPSUD/<pwd>@SUD on connection 0 ...

C Attaching to DB Server SUD (con_hdl=0,svchp=040D325C,svrhp=040D3E34)

C Starting user session (con_hdl=0,svchp=040D325C,srvhp=040D3E34,usrhp=040DC614)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

http://dboci.c 3721

the problem is in the schema password..SAP workprocess is not able to connect to database with the existing password,. may be its expired.

if your abap schema is SAPSUD, then go by these steps.

1. sqlplus "/as sysdba"

2. sql> select username, account_status, expiry_date from dba_users;

check if SAPSUD schema password has expired or not.

if expired use brtools to reset the password.

3. then start up your SAP.

Thanks,

Debasis.

[Former Member]

Hi Gurus

Recently we encounter an error like "0x7c82caa2 referenced memory at 0x00000000"

is this any way related to my dispatcher stopped

Thanks

Sudhakar A

[Former Member]

Hi Sudhakar,

It can be because of wrong Environment settings or missinf Environment settings .check below note

Note 556232 - Environment settings for R/3/Oracle on Windows

Regards

Ashok

[Former Member]

Hi All please find the result r3trans -d

4 ETW000 r3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 03.10.2008 - 11:02:35

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri Oct 03 11:02:36 2008 5494 0.005494

4 ETW000 [dev trc ,00000] db_con_init called 40 0.005534

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 26 0.005560

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 33 0.005593

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 139566 0.145159

4 ETW000 [dev trc ,00000] using "C:\usr\sap\SUD\SYS\exe\run\dboraslib.dll"

4 ETW000 22 0.145181

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 7 0.145188

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 13 0.145201

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.19)

4 ETW000 2501 0.147702

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 12 0.147714

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 18 0.147732

4 ETW000 [dev trc ,00000] New connection 0 created 13 0.147745

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO

4 ETW000 15 0.147760

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 12391 0.160151

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 12 0.160163

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO

4 ETW000 14 0.160177

4 ETW000 [dev trc ,00000] Found ORACLE_HOME=C:\oracle\ora92 in Registry 796 0.160973

4 ETW000 [dev trc ,00000] -->oci_initialize 400 0.161373

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8MSWIN1252

4 ETW000 34020 0.195393

4 ETW000 [dbsloci. ,00000] *** ERROR => Cannot connect: TNS-name missing 11 0.195404

2EETW169 no connect possible: "DBMS = ORACLE --- TWO_TASK = ''"

Thanks

Sudhakar A

[former_member204746]

problem 1: Found ORACLE_HOME=C:\oracle\ora92 in Registry 796 0.160973

You did not isntall ORacle the proper way, you did not follow the instlalation guide. Do not install ORacle with setup.exe, it must be done with sapserver.cmd

Problem 2: ERROR => Cannot connect: TNS-name missing 11

look if you can find tnsnames.ora file. If so, please provide its contents here

[Former Member]

Hi Thanks to all for helping me out

DataBase is oracle 9i which is running

Still i am in R&D with your advice's

Thanks for your support

[Former Member]

Hi sudhakar,

execute command r3trans -d and check logfile trans.log for errors.

or paste here.

Regards

Ashok

[former_member204746]

ORA-01033: ORACLE initialization or shutdown in progress

Oracle is not completely started up... or is shutting down.

before start SAPMMC and SAP, make sure that DB is up and running:

sqlplus "/ as sysdba"

shutdown immediate;

startup;

exit;

good luck.

[Former Member]

Hi,

Check Note 655240 - Composite SAP note: ORA-01033

also check Note 903904 - DB Connect: SAP system does not start after OS reboot.

One more thing you are using vary old kernel patch you should upgrade your SAP kernel also

check Note 19466 - Downloading SAP kernel patches

regards,

kaushal