on 02-05-2012 1:57 PM
hiiii.....when i try to start SAP server its not geting start.....
may be problem related with dialog work process....
i attached DEV_W0 log file please help mi out
thanks
-
trc file: "dev_w0", trc level: 1, release: "620"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Sun Feb 05 19:01:08 2012
B create_con (con_name=R/3)
B Loading DB library 'F:\usr\sap\A12\SYS\exe\run\dboraslib.dll' ...
B Library 'F:\usr\sap\A12\SYS\exe\run\dboraslib.dll' loaded
B Version of 'F:\usr\sap\A12\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6200
M patchlevel 0
M patchno 674
M intno 20020600
M pid 2172
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2172) [dpxxdisp.c 1028]
I MtxInit: -2 0 0
M DpShMCreate: sizeof(wp_adm) 12784 (752)
M DpShMCreate: sizeof(tm_adm) 1690816 (8412)
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(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 034E0040, size: 1977824)
M DpShMCreate: allocated sys_adm at 034E0040
M DpShMCreate: allocated wp_adm at 034E0560
M DpShMCreate: allocated tm_adm_list at 034E3750
M DpShMCreate: allocated tm_adm at 034E3778
M DpShMCreate: allocated wp_ca_adm at 03680438
M DpShMCreate: allocated appc_ca_adm at 03684A88
M DpShMCreate: allocated comm_adm_list at 036861F8
M DpShMCreate: allocated comm_adm at 03686210
M DpShMCreate: allocated ca_info at 036B5010
M DpShMCreate: allocated wall_adm at 036B5018
X
X Sun Feb 05 19:01:09 2012
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=F:\oracle\ora92 from environment
C Client NLS settings: AMERICAN_AMERICA.WE8DEC
C Logon as OPS$-user to get SAPA12's password
C Connecting as /@A12 on connection 0 ...
C Attaching to DB Server A12 (con_hdl=0,svchp=075513DC,svrhp=07553644)
C
C Sun Feb 05 19:01:19 2012
C Starting user session (con_hdl=0,svchp=075513DC,srvhp=07553644,usrhp=0755BE24)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
[dboci.c 3718]
C *** ERROR => CONNECT failed with sql error '1033'
[dboci.c 9601]
C Try to connect with default password
C Connecting as SAPA12/<pwd>@A12 on connection 0 ...
C Starting user session (con_hdl=0,svchp=075513DC,srvhp=07553644,usrhp=0755BE24)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
[dboci.c 3718]
C *** ERROR => CONNECT failed with sql error '1033'
[dboci.c 9601]
B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 957] [dbsh 0957 ]
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 1102]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8437]
M
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M tid = -1
M mode = 255
M len = -1
M rq_id = -1
M rq_source = 255
M last_tid = 0
M last_mode = 0
M rfc_req = 0
M report = > <
M action = 0
M tab_name = > <
M
M *****************************************************************************
M *
M * LOCATION SAP-Server wagh_A12_00 on host wagh (wp 0)
M * ERROR tskh_init: db_connect
M *
M * TIME Sun Feb 05 19:01:19 2012
M * RELEASE 620
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 8569
M * COUNTER 1
M *
M *****************************************************************************
M
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 237]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2172) [dpnttool.c 346]
Hi,
SAP system dispatcher is getting down and hence instance is not able to bring up.
Can you please also paste logs of file dev_server0, dev_icm_sec,dev_icm, dev_jcontrol etc.
Also have you verified if your database running correctly? also your SAP system (SAP<SID>_<Instance no>)services are up??
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hiii guys,
My problem still not solve..now paste DEV_disp log file...here show work process died...plz look that n give mi solution..
-
trc file: "dev_disp", trc level: 1, release: "620"
-
Wed Feb 08 17:06:12 2012
kernel runs with dp version 3(ext=1) (@(#) DPLIB-INT-VERSION-3)
length of sys_adm_ext is 304 bytes
Wed Feb 08 17:06:13 2012
systemid 560 (PC with Windows NT)
relno 6200
patchlevel 0
patchno 674
intno 20020600
pid 2412
***LOG Q00=> DpSapEnvInit, DPStart (00 2412) [dpxxdisp.c 978]
shared lib "dw_xml.dll" version 674 successfully loaded
shared lib "dw_xtc.dll" version 674 successfully loaded
shared lib "dw_stl.dll" version 674 successfully loaded
Wed Feb 08 17:06:17 2012
WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3212]
MtxInit: -2 0 0
DpShMCreate: sizeof(wp_adm) 11280 (752)
DpShMCreate: sizeof(tm_adm) 1690816 (8412)
DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
DpShMCreate: sizeof(comm_adm) 192000 (384)
DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
DpShMCreate: SHM_DP_ADM_KEY (addr: 034E0040, size: 1976320)
DpShMCreate: allocated sys_adm at 034E0040
DpShMCreate: allocated wp_adm at 034E0560
DpShMCreate: allocated tm_adm_list at 034E3170
DpShMCreate: allocated tm_adm at 034E3198
DpShMCreate: allocated wp_ca_adm at 0367FE58
DpShMCreate: allocated appc_ca_adm at 036844A8
DpShMCreate: allocated comm_adm_list at 03685C18
DpShMCreate: allocated comm_adm at 03685C30
DpShMCreate: allocated ca_info at 036B4A30
DpShMCreate: allocated wall_adm at 036B4A38
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 1207 MB
<ES> 1206 blocks reserved for free list.
ES initialized.
***LOG Q0K=> DpMsAttach, mscon ( wagh) [dpxxdisp.c 9115]
Wed Feb 08 17:06:18 2012
CCMS: Initalizing shared memory of size 20000000 for monitoring segment.
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 6200, patchlevel 0
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 941]
DpMsgAdmin: Set patchno for this platform to 674
Release check o.K.
Wed Feb 08 17:06:58 2012
ERROR => W5 (pid 2712) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W5
ERROR => W9 (pid 2744) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W9
ERROR => W11 (pid 2760) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W11
my types changed after wp death/restart 0xbf --> 0xbb
Wed Feb 08 17:07:18 2012
ERROR => W0 (pid 2672) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W0
ERROR => W1 (pid 2680) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W1
ERROR => W3 (pid 2696) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W3
ERROR => W4 (pid 2704) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W4
ERROR => W7 (pid 2728) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W7
ERROR => W8 (pid 2736) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W8
ERROR => W10 (pid 2752) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W10
ERROR => W12 (pid 2768) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W12
ERROR => W13 (pid 2776) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W13
my types changed after wp death/restart 0xbb --> 0xa1
Wed Feb 08 17:07:38 2012
ERROR => W2 (pid 2688) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W2
ERROR => W6 (pid 2720) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W6
ERROR => W14 (pid 2784) died [dpxxdisp.c 11523]
force unlock of wp_adm mutex W14
my types changed after wp death/restart 0xa1 --> 0x80
DP_FATAL_ERROR => DpEnvCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
DpModState: change server state from STARTING to SHUTDOWN
Wed Feb 08 17:07:45 2012
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9341]
MBUF state OFF
MBUF component DOWN
***LOG Q05=> DpHalt, DPStop ( 2412) [dpxxdisp.c 7883]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is nothing new in dev_disp. We already knew that work processes died, from the dev_w0 you posted above.
It would help more if you could reply to other suggestions given above, like 'what is the output of R3trans -d' or what did you try from the ideas in SAP note 655240, which what result. For example what about environment variables?
hope this helps
Hi,
Pls ensure to start your database in running status first , before you start SAP applications.
It seems there is problem at database end caz "ORA-01033: ORACLE initialization or shutdown in progress dblink#1 @ 419 dblink 0419 "
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vicky,
Is R3trans -d successful. Please paste the log if u still have issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vicky,
Looks like database is not open or in mount state. Can you start the database manually, check the listener and start SAP again.
Also Make sure you able to login with SAPSR3 user @ DB level (login with SAPSR3 user and password @ database level )
Regards,
Arjun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
From the logs:
ORA-01033: ORACLE initialization or shutdown in progress
Check SAP Note ORA-01033: 655240, all the possible causes for this error are mentioned.
Regards,
Srikishan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.