on 05-23-2008 8:42 AM
Hi team
As I said in subject I restarted the server and in MMC I observed the error called disp+work.exe stopped.In the
event log I checked and found the errors as--
In Syslog these are the errors found.
SAP-Basis System:Message Server Disconnected.
SAP-Basis System:Initialization DB connect failed,Return code 000256
Database:Database error 1033 at con
-
Also checked with R3trans -d and this is the output
I got is (0012). to this I have posted dev_w0,dev_disp and
developer trace.
please if any one knows the right solution plz do help.dont just
type one line answers which are not upto the mark.
-
-
trc file: "dev_disp", trc level: 1, release: "700"
-
sysno 00
sid DPM
systemid 560 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 111
intno 20050900
make: multithreaded, Unicode, optimized
pid 236
kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)
length of sys_adm_ext is 576 bytes
SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 236) [dpxxdisp.c 1239]
shared lib "dw_xml.dll" version 111 successfully loaded
shared lib "dw_xtc.dll" version 111 successfully loaded
shared lib "dw_stl.dll" version 111 successfully loaded
shared lib "dw_gui.dll" version 111 successfully loaded
shared lib "dw_mdm.dll" version 111 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3900
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >curosysdev_DPM_00 <
DpShMCreate: sizeof(wp_adm) 18672 (1436)
DpShMCreate: sizeof(tm_adm) 4232256 (21056)
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)
DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
DpShMCreate: sizeof(slock_adm) 0 (96)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1536)
DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 06000040, size: 4892312)
DpShMCreate: allocated sys_adm at 06000040
DpShMCreate: allocated wp_adm at 06002090
DpShMCreate: allocated tm_adm_list at 06006980
DpShMCreate: allocated tm_adm at 060069B0
DpShMCreate: allocated wp_ca_adm at 0640FDF0
DpShMCreate: allocated appc_ca_adm at 06415BB0
DpShMCreate: allocated comm_adm at 06417AF0
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 064989B0
DpShMCreate: allocated gw_adm at 064989F0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 06498A20
DpShMCreate: allocated wall_adm at 06498A28
MBUF state OFF
DpCommInitTable: init table for 500 entries
EmInit: MmSetImplementation( 2 ).
MM global diagnostic options set: 0
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 511 blocks reserved for free list.
ES initialized.
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1629]
***LOG Q0K=> DpMsAttach, mscon ( curosysdev) [dpxxdisp.c 11753]
DpStartStopMsg: send start message (myname is >curosysdev_DPM_00 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
CCMS: start to initalize 3.X shared alert area (first segment).
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 111
Release check o.K.
Fri May 23 12:29:48 2008
ERROR => W0 (pid 808) died [dpxxdisp.c 14441]
ERROR => W1 (pid 2668) died [dpxxdisp.c 14441]
ERROR => W2 (pid 2192) died [dpxxdisp.c 14441]
ERROR => W3 (pid 2808) died [dpxxdisp.c 14441]
ERROR => W4 (pid 3588) died [dpxxdisp.c 14441]
ERROR => W5 (pid 2720) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbf --> 0xbe
ERROR => W6 (pid 412) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbe --> 0xbc
ERROR => W7 (pid 2188) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbc --> 0xb8
ERROR => W8 (pid 2792) died [dpxxdisp.c 14441]
ERROR => W9 (pid 1740) died [dpxxdisp.c 14441]
ERROR => W10 (pid 2796) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xb8 --> 0xb0
ERROR => W11 (pid 380) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xb0 --> 0xa0
ERROR => W12 (pid 2956) died [dpxxdisp.c 14441]
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=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:29:58 2008
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Fri May 23 06:59:58 2008
========================
Dispatcher Queue Statistics Fri May 23 06:59:58 2008
===========================
--------
+
Typ | now | high | max | writes | reads |
--------
+
NOWP | 0 | 2 | 2000 | 6 | 6 |
--------
+
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 7 ( 87%), shm 1 ( 12%)
since last update total 8, udp 7 ( 87%), shm 1 ( 12%)
Dump of tm_adm structure: Fri May 23 06:59:58 2008
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Fri May 23 06:59:58 2008
=============================
Slots: 300, Used: 1, Max: 0
--------
+
id | owner | pid | eyecatcher |
--------
+
0 | DISPATCHER | -1 | WPCAAD000 |
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:03 2008
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >curosysdev_DPM_00 < (normal)
DpJ2eeDisableRestart
DpModState: buffer in state MBUF_PREPARED
NiBufSend starting
NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)
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 (3976) (SOFT_KILL)
Stop icman
killing process (180) (SOFT_KILL)
Terminate gui connections
wait for end of work processes
wait for end of gateway
[DpProcDied] Process lives (PID:3976 HANDLE:1580)
waiting for termination of gateway ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:04 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:3976 HANDLE:1580)
wait for end of icman
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:05 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:06 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:07 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:08 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:09 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:10 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:11 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:12 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:13 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:14 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:180 HANDLE:1588)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1609
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri May 23 12:30:15 2008
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:180 HANDLE:1588)
DpStartStopMsg: send stop message (myname is >curosysdev_DPM_00 <)
NiIMyHostName: hostname = 'systemdev'
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 = 189 bytes
NiBufSend starting
NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO)
MsINiWrite: sent 562 bytes
send msg (len 110+452) to name -, type 4, key -
DpStartStopMsg: stop msg sent
NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)
NiBufIIn: NIBUF len=274
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 274 bytes
MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -
DpHalt: received 164 bytes from message server
NiIRead: hdl 2 recv would block (errno=EAGAIN)
NiIRead: read for hdl 2 timed out (0ms)
DpHalt: no more messages from the message server
DpHalt: send keepalive to synchronize with the message server
NiBufSend starting
NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO)
MsINiWrite: sent 114 bytes
send msg (len 110+4) to name MSG_SERVER, type 0, key -
MsSndName: MS_NOOP ok
Send 4 bytes to MSG_SERVER
NiIRead: hdl 2 recv would block (errno=EAGAIN)
NiIPeek: peek successful for hdl 2 (r)
NiIRead: hdl 2 received data (rcd=114,pac=1,MESG_IO)
NiBufIIn: NIBUF len=114
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 114 bytes
MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -
Received 4 bytes from MSG_SERVER
Received opcode MS_NOOP from msg_server, reply MSOP_OK
MsOpReceive: ok
MsSendKeepalive : keepalive sent to message server
NiIRead: hdl 2 recv would block (errno=EAGAIN)
Fri May 23 12:30:16 2008
NiIPeek: peek for hdl 2 timed out (r; 1000ms)
NiIRead: read for hdl 2 timed out (1000ms)
DpHalt: no more messages from the message server
DpHalt: sync with message server o.k.
detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 12099]
NiBufSend starting
NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIDetach: send logout to msg_server
MsIDetach: call exit function
DpMsShutdownHook called
NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0
SiSelNSet: set events of sock 1520 to: ---
NiBufISelRemove: remove hdl 2 from set0
SiSelNRemove: removed sock 1520 (pos=2)
SiSelNRemove: removed sock 1520
NiSelIRemove: removed hdl 2
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/13
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)
MBUF component DOWN
NiICloseHandle: shutdown and close hdl 2 / sock 1520
NiBufIClose: clear extension for hdl 2
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 236) [dpxxdisp.c 10371]
-
dev_w0 trace file
-
trc file: "dev_w0", trc level: 1, release: "700"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Fri May 23 12:29:09 2008
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\MPD\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\MPD\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\MPD\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.107)
B New connection 0 created
M sysno 00
M sid DPM
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 111
M intno 20050900
M make: multithreaded, Unicode, optimized
M pid 808
M
M kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 808) [dpxxdisp.c 1301]
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) 18672 (1436)
M DpShMCreate: sizeof(tm_adm) 4232256 (21056)
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 DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (96)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1536)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 06000040, size: 4892312)
M DpShMCreate: allocated sys_adm at 06000040
M DpShMCreate: allocated wp_adm at 06002090
M DpShMCreate: allocated tm_adm_list at 06006980
M DpShMCreate: allocated tm_adm at 060069B0
M DpShMCreate: allocated wp_ca_adm at 0640FDF0
M DpShMCreate: allocated appc_ca_adm at 06415BB0
M DpShMCreate: allocated comm_adm at 06417AF0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 064989B0
M DpShMCreate: allocated gw_adm at 064989F0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 06498A20
M DpShMCreate: allocated wall_adm at 06498A28
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Fri May 23 12:29:10 2008
M ThInit: running on host systemdev
M
M Fri May 23 12:29:11 2008
M calling db_connect ...
C Prepending D:\usr\sap\DPM\DVEBMGS00\exe to Path.
C Oracle Client Version: '10.2.0.1.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DPM on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 08C50EE8 08C56484 08C55D0C
C Attaching to DB Server DPM (con_hdl=0,svchp=08C55C58,srvhp=08C67854)
C Starting user session (con_hdl=0,svchp=08C55C58,srvhp=08C67854,usrhp=08C7C598)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=08C55C58,srvhp=08C67854)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11042]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@DPM on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 08C50EE8 08C56484 08C55D0C
C Attaching to DB Server DPM (con_hdl=0,svchp=08C55C58,srvhp=08C67854)
C Starting user session (con_hdl=0,svchp=08C55C58,srvhp=08C67854,usrhp=08C7C598)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=08C55C58,srvhp=08C67854)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11042]
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 1426]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10283]
M
M Info for wp 0
M
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source =
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 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 req.vm = no VM
M attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server systemdev_DPM_00 on host systemdev (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Fri May 23 12:29:11 2008
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10486
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 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 808) [dpnttool.c 327]
-
Hi
ORA-01033 stands out when database connect attempt is made while oracle is starting up or shutting down.
Try connect to oracle as sysdba and do shutdown immediate and try starting SAP again.
Hope this helps.
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi manjula,
Please check your listner services .if it is manul than make it to automatic . Did you change the parameter of sap.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi. Are you loged under "sid"adm ? If go to start-->run --> cmd -->
sqlplus "/as sysdba"
shutdown
startup.
If database up after start sap in MMC. Also check logs in trans.log file (find him and check) also check oracle services are started ?. Regards.
Edited by: Sergo Beradze on May 23, 2008 12:04 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am posting trans.log file
-
4 ETW000 r3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 22.05.2008 - 19:16:34
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] Thu May 22 19:16:37 2008 6740 0.006740
4 ETW000 [dev trc ,00000] db_con_init called 28 0.006768
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 47 0.006815
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 34 0.006849
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 76286 0.083135
4 ETW000 [dev trc ,00000] using "D:\usr\sap\MPD\SYS\exe\uc\NTI386\dboraslib.dll"
4 ETW000 34 0.083169
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 18 0.083187
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 30 0.083217
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.107)
4 ETW000 47578 0.130795
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 30 0.130825
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 42 0.130867
4 ETW000 [dev trc ,00000] New connection 0 created 28 0.130895
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 42 0.130937
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 23 0.130960
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 28 0.130988
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 39 0.131027
4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or
4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 8178 0.139205
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 74378 0.213583
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 35 0.213618
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2658 0.216276
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 28 0.216304
4 ETW000 [dev trc ,00000] Connecting as /@MPD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 37 0.216341
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 277 0.216618
4 ETW000 [dev trc ,00000] 0 UTF8 1 0247DD60 02483294 02482B1C
4 ETW000 115 0.216733
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 6948 0.223681
4 ETW000 [dev trc ,00000] Allocating server context handle 184 0.223865
4 ETW000 [dev trc ,00000] Attaching to DB Server MPD (con_hdl=0,svchp=02482A68,srvhp=024942DC)
4 ETW000 59 0.223924
4 ETW000 [dev trc ,00000] Thu May 22 19:16:39 2008 2257608 2.481532
4 ETW000 [dev trc ,00000] Assigning server context 024942DC to service context 02482A68
4 ETW000 44 2.481576
4 ETW000 [dev trc ,00000] Allocating user session handle 33 2.481609
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02482A68,srvhp=024942DC,usrhp=024CFA20)
4 ETW000 51 2.481660
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
4 ETW000 32994 2.514654
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=024942DC) 22 2.514676
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02482A68,srvhp=024942DC)
4 ETW000 31 2.514707
4 ETW000 [dev trc ,00000] Deallocating server context handle 024942DC 473 2.515180
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1033'
4 ETW000 46 2.515226
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 26 2.515252
4 ETW000 [dev trc ,00000] Try to connect with default password 168 2.515420
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@MPD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 36 2.515456
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 36 2.515492
4 ETW000 [dev trc ,00000] 0 UTF8 1 0247DD60 02483294 02482B1C
4 ETW000 37 2.515529
4 ETW000 [dev trc ,00000] Allocating server context handle 20 2.515549
4 ETW000 [dev trc ,00000] Attaching to DB Server MPD (con_hdl=0,svchp=02482A68,srvhp=024942DC)
4 ETW000 52 2.515601
4 ETW000 [dev trc ,00000] Assigning server context 024942DC to service context 02482A68
4 ETW000 11841 2.527442
4 ETW000 [dev trc ,00000] Assigning username to user session 024CFA20 26 2.527468
4 ETW000 [dev trc ,00000] Assigning password to user session 024CFA20 27 2.527495
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02482A68,srvhp=024942DC,usrhp=024CFA20)
4 ETW000 37 2.527532
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
4 ETW000 31376 2.558908
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=024942DC) 21 2.558929
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02482A68,srvhp=024942DC)
4 ETW000 43 2.558972
4 ETW000 [dev trc ,00000] Deallocating server context handle 024942DC 550 2.559522
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1033'
4 ETW000 60 2.559582
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 20 2.559602
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1033 performing CON [dblink#3 @ 431]
4 ETW000 1028 2.560630
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431]
4 ETW000 34 2.560664
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'MPD'"
-
I checked all this but i am not able to reach up to the mark ...could you guide me Sergo Beradze
Hi frds, i m facing a problem of DB connection as similar to U manjula.
CONSOLE MMC .
the instance turns green and turns yellow again
bcz dispatcher is stopping
R/3 Basis System: Initialization DB-Connect Failed, Return Code 000256
R/3 Basis System: Message server disconnected
Database:Database error 1033 at con
need help regarding this
im posting the dev_w0 file , as i m not able to fine the trans.log
______________________________________________________________dev_wo____________________-
trc file: "dev_w0", trc level: 1, release: "640"
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Sun May 25 15:43:58 2008
B create_con (con_name=R/3)
B Loading DB library 'C:\usr\sap\ECC\SYS\exe\run\dboraslib.dll' ...
B Library 'C:\usr\sap\ECC\SYS\exe\run\dboraslib.dll' loaded
B Version of 'C:\usr\sap\ECC\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.6)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6400
M patchlevel 0
M patchno 10
M intno 20020600
M make: multithreaded, ASCII
M pid 3016
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3016) http://dpxxdisp.c 1153
I MtxInit: -2 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: JAVA is not active
M DpShMCreate: sizeof(wp_adm) 12424 (828)
M DpShMCreate: sizeof(tm_adm) 2083168 (10364)
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: 05EC0040, size: 2374536)
M DpShMCreate: allocated sys_adm at 05EC0040
M DpShMCreate: allocated wp_adm at 05EC17A8
M DpShMCreate: allocated tm_adm_list at 05EC4830
M DpShMCreate: allocated tm_adm at 05EC4858
M DpShMCreate: allocated wp_ca_adm at 060C11B8
M DpShMCreate: allocated appc_ca_adm at 060C5808
M DpShMCreate: allocated comm_adm_list at 060C6F78
M DpShMCreate: allocated comm_adm at 060C6F90
M DpShMCreate: allocated vmc_adm_list at 060F5D90
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 060F5DB8
M DpShMCreate: allocated wall_adm at 060F5DC0
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
M Sun May 25 15:43:59 2008
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 SAPECC's password
C Connecting as /@ECC on connection 0 ...
C Attaching to DB Server ECC (con_hdl=0,svchp=077DAC64,svrhp=036C26F4)
C
C Sun May 25 15:44:26 2008
C Starting user session (con_hdl=0,svchp=077DAC64,srvhp=036C26F4,usrhp=036CAF08)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
http://dboci.c 3721
C Detaching from DB Server (con_hdl=0,svchp=077DAC64,srvhp=036C26F4)
C *** ERROR => CONNECT failed with sql error '1033'
http://dbsloci.c 9750
C Try to connect with default password
C Connecting as SAPECC/<pwd>@ECC on connection 0 ...
C Attaching to DB Server ECC (con_hdl=0,svchp=077DAC64,svrhp=036C26F4)
C Starting user session (con_hdl=0,svchp=077DAC64,srvhp=036C26F4,usrhp=036CAF08)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
http://dboci.c 3721
C Detaching from DB Server (con_hdl=0,svchp=077DAC64,srvhp=036C26F4)
C *** ERROR => CONNECT failed with sql error '1033'
http://dbsloci.c 9750
B ***LOG BV3=> severe db error 1033 ; work process is stopped dbsh#1 @ 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) http://thxxhead.c 1270
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) http://thxxhead.c 9377
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 starecc_ECC_00 on host starecc (wp 0)
M * ERROR tskh_init: db_connect
M *
M * TIME Sun May 25 15:44:26 2008
M * RELEASE 640
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 9553
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 http://thxxrun1.c 728
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed http://thxxtool3.c 245
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3016) http://dpnttool.c 357
_________________________________________________
regards.
have a good day.
ajay
Edited by: ajay babu on May 25, 2008 8:07 PM
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.