on 10-03-2016 9:38 AM
Hi friends,
When I am starting SAP MMC then after some times work process is stop and MSG sever and ISG 'watchdog are running,
Please check the below all task developer trace file..
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "700"
---------------------------------------------------
sysno 00
sid SPI
systemid 560 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 75
intno 20050900
make: multithreaded, Unicode, optimized
pid 3744
Mon Oct 03 13:46:21 2016
kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)
length of sys_adm_ext is 572 bytes
*** SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 3744) [dpxxdisp.c 1237]
shared lib "dw_xml.dll" version 75 successfully loaded
shared lib "dw_xtc.dll" version 75 successfully loaded
shared lib "dw_stl.dll" version 75 successfully loaded
shared lib "dw_gui.dll" version 75 successfully loaded
shared lib "dw_mdm.dll" version 75 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3900
Mon Oct 03 13:46:26 2016
*** 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 5273]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >spi_SPI_00 <
DpShMCreate: sizeof(wp_adm) 18304 (1408)
DpShMCreate: sizeof(tm_adm) 3994272 (19872)
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 (1440)
DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 05CF0040, size: 4653368)
DpShMCreate: allocated sys_adm at 05CF0040
DpShMCreate: allocated wp_adm at 05CF1E40
DpShMCreate: allocated tm_adm_list at 05CF65C0
DpShMCreate: allocated tm_adm at 05CF65F0
DpShMCreate: allocated wp_ca_adm at 060C5890
DpShMCreate: allocated appc_ca_adm at 060CB650
DpShMCreate: allocated comm_adm at 060CD590
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 0614E450
DpShMCreate: allocated gw_adm at 0614E490
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 0614E4C0
DpShMCreate: allocated wall_adm at 0614E4C8
MBUF state OFF
DpCommInitTable: init table for 500 entries
Mon Oct 03 13:46:27 2016
EmInit: MmSetImplementation( 2 ).
MM global 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.
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1623]
Mon Oct 03 13:46:28 2016
***LOG Q0K=> DpMsAttach, mscon ( spi) [dpxxdisp.c 11586]
DpStartStopMsg: send start message (myname is >spi_SPI_00 <)
DpStartStopMsg: start msg sent
Mon Oct 03 13:46:29 2016
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
Mon Oct 03 13:46:36 2016
CCMS: start to initalize 3.X shared alert area (first segment).
Mon Oct 03 13:46:39 2016
DpMsgAdmin: Set release to 7000, patchlevel 0
MBUF state PREPARED
MBUF component UP
Mon Oct 03 13:46:40 2016
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1050]
Mon Oct 03 13:46:41 2016
DpMsgAdmin: Set patchno for this platform to 75
Release check o.K.
Mon Oct 03 13:48:08 2016
*** ERROR => W0 (pid 2656) died [dpxxdisp.c 14241]
*** ERROR => W1 (pid 2668) died [dpxxdisp.c 14241]
*** ERROR => W2 (pid 2672) died [dpxxdisp.c 14241]
*** ERROR => W3 (pid 2648) died [dpxxdisp.c 14241]
*** ERROR => W4 (pid 2644) died [dpxxdisp.c 14241]
*** ERROR => W5 (pid 2700) died [dpxxdisp.c 14241]
Mon Oct 03 13:48:09 2016
my types changed after wp death/restart 0xbf --> 0xbe
*** ERROR => W6 (pid 2712) died [dpxxdisp.c 14241]
my types changed after wp death/restart 0xbe --> 0xbc
*** ERROR => W7 (pid 2720) died [dpxxdisp.c 14241]
my types changed after wp death/restart 0xbc --> 0xb8
*** ERROR => W8 (pid 2732) died [dpxxdisp.c 14241]
*** ERROR => W9 (pid 2692) died [dpxxdisp.c 14241]
*** ERROR => W10 (pid 2684) died [dpxxdisp.c 14241]
my types changed after wp death/restart 0xb8 --> 0xb0
*** ERROR => W11 (pid 2104) died [dpxxdisp.c 14241]
my types changed after wp death/restart 0xb0 --> 0xa0
*** ERROR => W12 (pid 404) died [dpxxdisp.c 14241]
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=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:19 2016
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Mon Oct 03 08:18:19 2016
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-----------------------------------------------------------------------------------------------------------------------
0 DIA 2656 Ended no 1 0 0
1 DIA 2668 Ended no 1 0 0
2 DIA 2672 Ended no 1 0 0
3 DIA 2648 Ended no 1 0 0
4 DIA 2644 Ended no 1 0 0
5 DIA 2700 Ended no 1 0 0
6 UPD 2712 Ended no 1 0 0
7 ENQ 2720 Ended no 1 0 0
8 BTC 2732 Ended no 1 0 0
9 BTC 2692 Ended no 1 0 0
10 BTC 2684 Ended no 1 0 0
11 SPO 2104 Ended no 1 0 0
12 UP2 404 Ended no 1 0 0
Dispatcher Queue Statistics Mon Oct 03 08:18:19 2016
===========================
+------+--------+--------+--------+--------+--------+
| Typ | now | high | max | writes | reads |
+------+--------+--------+--------+--------+--------+
| NOWP | 0 | 2 | 2000 | 5 | 5 |
+------+--------+--------+--------+--------+--------+
| DIA | 6 | 6 | 2000 | 6 | 0 |
+------+--------+--------+--------+--------+--------+
| UPD | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| ENQ | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| BTC | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
| SPO | 1 | 1 | 2000 | 1 | 0 |
+------+--------+--------+--------+--------+--------+
| UP2 | 0 | 0 | 2000 | 0 | 0 |
+------+--------+--------+--------+--------+--------+
max_rq_id 14
wake_evt_udp_now 0
wake events total 10, udp 7 ( 70%), shm 3 ( 30%)
since last update total 10, udp 7 ( 70%), shm 3 ( 30%)
Dump of tm_adm structure: Mon Oct 03 08:18:19 2016
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Mon Oct 03 08:18:19 2016
=============================
Slots: 300, Used: 1, Max: 0
+------+--------------+----------+-------------+
| id | owner | pid | eyecatcher |
+------+--------------+----------+-------------+
| 0 | DISPATCHER | -1 | *WPCAAD000* |
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:24 2016
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >spi_SPI_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
Mon Oct 03 13:48:25 2016
ShmProtect( 57, 1 )
ShmProtect(SHM_PROFILE, SHM_PROT_RD
DpWakeUpWps: wake up all wp's
Stop work processes
Stop gateway
killing process (3116) (SOFT_KILL)
Stop icman
killing process (3108) (SOFT_KILL)
Terminate gui connections
wait for end of work processes
wait for end of gateway
[DpProcDied] Process lives (PID:3116 HANDLE:1608)
waiting for termination of gateway ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:26 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:3116 HANDLE:1608)
wait for end of icman
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:27 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:28 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:29 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:30 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:31 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:32 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:33 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:34 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:35 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:3108 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Mon Oct 03 13:48:36 2016
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:3108 HANDLE:1612)
DpStartStopMsg: send stop message (myname is >spi_SPI_00 <)
NiIMyHostName: hostname = 'spi'
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)
Mon Oct 03 13:48:37 2016
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 11899]
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 1548 to: ---
NiBufISelRemove: remove hdl 2 from set0
SiSelNRemove: removed sock 1548 (pos=2)
SiSelNRemove: removed sock 1548
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 17)
MBUF component DOWN
NiICloseHandle: shutdown and close hdl 2 / sock 1548
NiBufIClose: clear extension for hdl 2
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 3744) [dpxxdisp.c 10259]
Thank you
sandeep
Is this you dummy or IDES system? If its your Live or Production system, then I would like to ask you to shut down your SAP systems & restart the Domain-Controller server for SAP Systems & then you start starting the SAP systems 1by1, which will sort out your network matter because its obvious the IP DNS is assigned to the SAP Active Directory Server/Domain-Controller Server, which its not able to locate at the start of this server only. Also this same matter you can notice in the system Event-Viewer Logs also. Also would like to know whether a recent kernel upgrade has been done on the system or you are starting this server after long days back?
Thanks,
Kaushik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That is why , I guess, its required for you to have a deep look whatever or whenever you take a look. Ok, coming to the main point, as I am a bit knowledgeable person on the Domain Controllers, that why I asked the User to confirm whether its a dummy or Live system. Because the below scenario
will only come for the DNS matter, if you have started the SAP this system before the SAP Domain Controller in your company because its too possible that in the Primary or Secondary DNS he has mentioned the SAP Domain Controller, which the SAP System was not able to get while checking the IP address details. So need the User to check the corresponding DNS IP mentioned servers to be up & running & also SAP Active Directory is fine there.
Thanks,
Kaushik
Hi Kaushik,
thanks. The check for 1.0.0.0 has nothing to do with Domain Controllers. And I hope SAP development will change this piece of code, soon.
The dispatcher checks if the Windows OS returns a hostname for IP address 1.0.0.0. This should guarantee, that the naming resolution on Windows is properly configured, also for a reverse lookup.
The problem is, that almost any Windows configuration will need more than 3 seconds for a reverse lookup for 1.0.0.0.
A simple check with ping command proofs this:
ping -a 1.0.0.0
(ping command also uses function call getnameinfo() to retrieve a hostname for an IP address)
So above lines will be seen in many (almost any?) dev_disp work traces on Windows. Regardless if you disable NetBIOS over TCP/IP or WINS. There is an ugly workaround of course available: Add "1.0.0.0 whateverhost" to \etc\hosts and then ping -a 1.0.0.0 will answer fast and the "error" line in dev_disp will disappear.
Here, the dispatcher trace clearly shows that the work processes were started, but died somehow. The reason for this cannot be seen in the dispatcher trace.
Best regards,
Kalle
Hi all,
The "possible network issue" for IP 1.0.0.0 has nothing to do with the startup issue.
Mon Oct 03 13:48:08 2016
*** ERROR => W0 (pid 2656) died
*** ERROR => W1 (pid 2668) died
*** ERROR => W2 (pid 2672) died
*** ERROR => W3 (pid 2648) died
*** ERROR => W4 (pid 2644) died
*** ERROR => W5 (pid 2700) died
The wok processes are unable to start. This points to the root cause.
If you need assistance to analyze it, then post the dev_w0 contents to this thread.
Cheers!
Isaías
Please check my dev_w0 trace file.
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Tue Oct 04 19:55:01 2016
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\SPI\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\SPI\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\SPI\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.73)
B New connection 0 created
M sysno 00
M sid SPI
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 75
M intno 20050900
M make: multithreaded, Unicode, optimized
M pid 3032
M
M kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)
M length of sys_adm_ext is 572 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3032) [dpxxdisp.c 1299]
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) 3994272 (19872)
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 (1440)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05CF0040, size: 4653368)
M DpShMCreate: allocated sys_adm at 05CF0040
M DpShMCreate: allocated wp_adm at 05CF1E40
M DpShMCreate: allocated tm_adm_list at 05CF65C0
M DpShMCreate: allocated tm_adm at 05CF65F0
M DpShMCreate: allocated wp_ca_adm at 060C5890
M DpShMCreate: allocated appc_ca_adm at 060CB650
M DpShMCreate: allocated comm_adm at 060CD590
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 0614E450
M DpShMCreate: allocated gw_adm at 0614E490
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 0614E4C0
M DpShMCreate: allocated wall_adm at 0614E4C8
X EmInit: MmSetImplementation( 2 ).
X MM global 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 Tue Oct 04 19:55:14 2016
M ThInit: running on host spi
M
M Tue Oct 04 19:55:16 2016
M calling db_connect ...
C
C Tue Oct 04 19:55:17 2016
C Prepending D:\usr\sap\SPI\DVEBMGS00\exe to Path.
C
C Tue Oct 04 19:55:23 2016
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 /@SPI on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 08FBBEB8 08FC1454 08FC0CDC
C Attaching to DB Server SPI (con_hdl=0,svchp=08FC0C28,svrhp=08FD2134)
C
C Tue Oct 04 19:55:27 2016
C Starting user session (con_hdl=0,svchp=08FC0C28,srvhp=08FD2134,usrhp=08FE6DF8)
C Now '/@SPI' is connected (con_hdl 0, nls_hdl 0).
C Got SAPSR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=08FC0C28,usrhp=08FE6DF8)
C Now I'm disconnected from ORACLE
C Connecting as SAPSR3/<pwd>@SPI on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 08FBBEB8 08FC1454 08FC0CDC
C Starting user session (con_hdl=0,svchp=08FC0C28,srvhp=08FD2134,usrhp=08FE6DF8)
C
C Tue Oct 04 19:55:28 2016
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000
[dboci.c 4391]
C Detaching from DB Server (con_hdl=0,svchp=08FC0C28,srvhp=08FD2134)
C *** ERROR => CONNECT failed with sql error '28000'
[dbsloci.c 10933]
B ***LOG BY2=> sql error 28000 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY2=> sql error 28000 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-28000: the account is locked [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]
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 *
M * LOCATION SAP-Server spi_SPI_00 on host spi (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Tue Oct 04 19:55:28 2016
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10354
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
M Tue Oct 04 19:55:29 2016
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3032) [dpnttool.c 327]
Hello Sandeep,
The root cause is:
C Tue Oct 04 19:55:28 2016
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000
C Detaching from DB Server (con_hdl=0,svchp=08FC0C28,srvhp=08FD2134)
C *** ERROR => CONNECT failed with sql error '28000'
B ***LOG BY2=> sql error 28000 performing CON
B ***LOG BY0=> ORA-28000: the account is locked
B ***LOG BY2=> sql error 28000 performing CON
B ***LOG BY0=> ORA-28000: the account is locked
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256)
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1)
Involve your Oracle team so they fix this.
Regards,
Isaías
Hi Isaias,
Thanks for your reply.
As I am using a dummy system so I can not get support from Oracle team.
Could you please suggest an alternative to fix this.
Please take a look to R3trans logs also,
D:\usr\sap\SPI\SYS\exe\uc\NTI386>R3trans -d
This is R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).
unicode enabled version
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
R3trans finished (0012).
Regards,
Sandeep
Hello Sandeep,
I do not work with Oracle... I searched for SAP notes using the keyword "ORA-28000" and I found the SAP note 951167. I hope it helps.
Regards,
Isaías
Thank you Joseph,
I run in Command prompt sqlplus "/ as sysdba and passed query show user;
result was 'SYS'
and after that passed
alter user SYS account unlock;
result was user alterd,
but in SQL Plus I Can login with Scott user but not with SYS user(I dont know password), I login with Scott user and try to alter user SYS.
but result was Insufficient privileges,
Thank you
sandeep
Hi Sandeep.
1. Have you change the any host name ?
2. Try to restart the system and then check the SAP startup .. if possible add the local host file enter hostname - IP address.
3. Currently you kernel release and level are low you may require to upgrade the kernel..
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
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.