Disp+work process was down after the Restoreing the backup

[Former Member]

Disp+work process is down after the Restore of the backup

s/m configration: windows 2003 server + oracle 10g

The below is the log file

-

---

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

-

---

sysno 01

sid PRA

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 52

intno 20050900

make: multithreaded, Unicode, optimized

pid 2928

Thu Apr 07 18:58:10 2011

kernel runs with dp version 210000(ext=109000) (@(#) DPLIB-INT-VERSION-210000-UC)

length of sys_adm_ext is 572 bytes

• SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (01 2928) [dpxxdisp.c 1231]

shared lib "dw_xml.dll" version 52 successfully loaded

shared lib "dw_xtc.dll" version 52 successfully loaded

shared lib "dw_stl.dll" version 52 successfully loaded

shared lib "dw_gui.dll" version 52 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3901

Thu Apr 07 18:58:15 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 5233]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >pwsap_PRA_01 <

DpShMCreate: sizeof(wp_adm) 18304 (1408)

DpShMCreate: sizeof(tm_adm) 3954072 (19672)

DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

DpShMCreate: sizeof(comm_adm) 528064 (1048)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1452)

DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 05C00040, size: 4613144)

DpShMCreate: allocated sys_adm at 05C00040

DpShMCreate: allocated wp_adm at 05C01E28

DpShMCreate: allocated tm_adm_list at 05C065A8

DpShMCreate: allocated tm_adm at 05C065D8

DpShMCreate: allocated wp_ca_adm at 05FCBB70

DpShMCreate: allocated appc_ca_adm at 05FD1930

DpShMCreate: allocated comm_adm at 05FD3870

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 06054730

DpShMCreate: allocated gw_adm at 06054770

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 060547A0

DpShMCreate: allocated wall_adm at 060547A8

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

MM diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 511 blocks reserved for free list.

ES initialized.

Thu Apr 07 18:58:16 2011

J2EE server info

start = TRUE

state = STARTED

pid = 3208

argv[0] = D:\usr\sap\PRA\DVEBMGS01\exe\jcontrol.EXE

argv[1] = D:\usr\sap\PRA\DVEBMGS01\exe\jcontrol.EXE

argv[2] = pf=D:\usr\sap\PRA\SYS\profile\PRA_DVEBMGS01_pwsap

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=1069

argv[5] = -DSAPSYSTEM=01

argv[6] = -DSAPSYSTEMNAME=PRA

argv[7] = -DSAPMYNAME=pwsap_PRA_01

argv[8] = -DSAPPROFILE=D:\usr\sap\PRA\SYS\profile\PRA_DVEBMGS01_pwsap

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1617]

***LOG Q0K=> DpMsAttach, mscon ( pwsap) [dpxxdisp.c 11414]

DpStartStopMsg: send start message (myname is >pwsap_PRA_01 <)

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

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

Thu Apr 07 18:58:17 2011

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

DpJ2eeLogin: j2ee state = CONNECTED

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 52

Release check o.K.

Thu Apr 07 18:58:42 2011

***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4235]

• ERROR => NiIRead: SiRecv failed for hdl 4 / sock 1472

(SI_ECONN_BROKEN; I4; ST; 127.0.0.1:1085) [nixxi.cpp 4235]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=3208)

• ERROR => DpProcKill: kill failed [dpntdisp.c 371]

DpIJ2eeShutdown: j2ee state = SHUTDOWN

Thu Apr 07 18:58:56 2011

• ERROR => W0 (pid 3216) died [dpxxdisp.c 14021]

• ERROR => W1 (pid 3224) died [dpxxdisp.c 14021]

• ERROR => W2 (pid 3232) died [dpxxdisp.c 14021]

• ERROR => W3 (pid 3240) died [dpxxdisp.c 14021]

• ERROR => W4 (pid 3248) died [dpxxdisp.c 14021]

• ERROR => W5 (pid 3256) died [dpxxdisp.c 14021]

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

• ERROR => W6 (pid 3264) died [dpxxdisp.c 14021]

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

• ERROR => W7 (pid 3272) died [dpxxdisp.c 14021]

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

• ERROR => W8 (pid 3280) died [dpxxdisp.c 14021]

• ERROR => W9 (pid 3288) died [dpxxdisp.c 14021]

• ERROR => W10 (pid 3296) died [dpxxdisp.c 14021]

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

• ERROR => W11 (pid 3304) died [dpxxdisp.c 14021]

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

• ERROR => W12 (pid 3312) died [dpxxdisp.c 14021]

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

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1597

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Apr 07 18:59:06 2011

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Fri Apr 08 01:59:06 2011

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

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

-

---

0 DIA 3216 Ended no 1 0 0

1 DIA 3224 Ended no 1 0 0

2 DIA 3232 Ended no 1 0 0

3 DIA 3240 Ended no 1 0 0

4 DIA 3248 Ended no 1 0 0

5 DIA 3256 Ended no 1 0 0

6 UPD 3264 Ended no 1 0 0

7 ENQ 3272 Ended no 1 0 0

8 BTC 3280 Ended no 1 0 0

9 BTC 3288 Ended no 1 0 0

10 BTC 3296 Ended no 1 0 0

11 SPO 3304 Ended no 1 0 0

12 UP2 3312 Ended no 1 0 0

Dispatcher Queue Statistics Fri Apr 08 01:59:06 2011

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

--------

---

+

---

+

---

+

---

+--

---

+

Typ

now

high

max

writes

reads

--------

---

+

---

+

---

+

---

+--

---

+

NOWP

0

2

2000

5

5

--------

---

+

---

+

---

+

---

+--

---

+

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 12

wake_evt_udp_now 0

wake events total 8, udp 6 ( 75%), shm 2 ( 25%)

since last update total 8, udp 6 ( 75%), shm 2 ( 25%)

Dump of tm_adm structure: Fri Apr 08 01:59:06 2011

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

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

Workprocess Comm. Area Blocks Fri Apr 08 01:59:06 2011

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

Slots: 300, Used: 1, Max: 0

--------

---

+

---

+--

---

+

id

owner

pid

eyecatcher

--------

---

+

---

+--

---

+

0

DISPATCHER

-1

WPCAAD000

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1597

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Apr 07 18:59:11 2011

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >pwsap_PRA_01 < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

[Former Member]

hi,

Can you post dev_w0

Mark

[Former Member]

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

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Thu Apr 07 18:58:16 2011

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\PRA\DVEBMGS01\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\PRA\DVEBMGS01\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\PRA\DVEBMGS01\exe\dboraslib.dll' is "700.08", patchlevel (0.46)

B New connection 0 created

M sysno 01

M sid PRA

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 52

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 3216

M

M kernel runs with dp version 210000(ext=109000) (@(#) DPLIB-INT-VERSION-210000-UC)

M length of sys_adm_ext is 572 bytes

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

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 18304 (1408)

M DpShMCreate: sizeof(tm_adm) 3954072 (19672)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M DpShMCreate: sizeof(comm_adm) 528064 (1048)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1452)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 05C00040, size: 4613144)

M DpShMCreate: allocated sys_adm at 05C00040

M DpShMCreate: allocated wp_adm at 05C01E28

M DpShMCreate: allocated tm_adm_list at 05C065A8

M DpShMCreate: allocated tm_adm at 05C065D8

M DpShMCreate: allocated wp_ca_adm at 05FCBB70

M DpShMCreate: allocated appc_ca_adm at 05FD1930

M DpShMCreate: allocated comm_adm at 05FD3870

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 06054730

M DpShMCreate: allocated gw_adm at 06054770

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 060547A0

M DpShMCreate: allocated wall_adm at 060547A8

X EmInit: MmSetImplementation( 2 ).

X MM diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Thu Apr 07 18:58:17 2011

M ThInit: running on host pwsap

M

M Thu Apr 07 18:58:18 2011

M calling db_connect ...

C Prepending D:\usr\sap\PRA\DVEBMGS01\exe to Path.

C

C Thu Apr 07 18:58:27 2011

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

C Connecting as /@PRA on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0619F158 061A46F4 061A3F7C

C Attaching to DB Server PRA (con_hdl=0,svchp=061A3EC8,svrhp=061B5794)

C Starting user session (con_hdl=0,svchp=061A3EC8,srvhp=061B5794,usrhp=061CA558)

C

C Thu Apr 07 18:58:28 2011

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

[dboci.c 4345]

C Detaching from DB Server (con_hdl=0,svchp=061A3EC8,srvhp=061B5794)

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

[dbsloci.c 10704]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@PRA on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0619F158 061A46F4 061A3F7C

C Attaching to DB Server PRA (con_hdl=0,svchp=061A3EC8,svrhp=061B5794)

C Starting user session (con_hdl=0,svchp=061A3EC8,srvhp=061B5794,usrhp=061CA558)

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

[dboci.c 4345]

C Detaching from DB Server (con_hdl=0,svchp=061A3EC8,srvhp=061B5794)

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

[dbsloci.c 10704]

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

B ***LOG BY2=> sql error 1033 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

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 semaphore = 0

M act_cs_count = 0

M control_flag = 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 vm = V-1

M

M *

M * LOCATION SAP-Server pwsap_PRA_01 on host pwsap (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Apr 07 18:58:28 2011

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10204

M * COUNTER 1

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 720]

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

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

[Former Member]

Hi Santhi,

ORA-01033: ORACLE initialization or shutdown in progress

Please double check your oracle. Looks like the oracle is not running well.

Thanks

[Former Member]

Hi Santhi ,

The solution for this error is to check with oracle whether its available or not. Check the oracle processes in your task manager.If oracle processes are not running then take a clean resatrt of your database with shutdown abort and then start it as startup .

Once oracle is started start your SAP via MMC.

Thanks..

Mohit

Edited by: mohit gupta on Apr 11, 2011 8:21 AM

[Former Member]

Hi,

this looks like environmental....

Please check your environment variables.......

Also check the Oracle service user. You might need to change the user...

By the way, how did you do the system restore

Mark