on 04-23-2014 3:49 PM
Hi folks,
I've an Virtual Machine with Windows 2003 64 bits with SAP ECC and PI.
When I started the server, process "disp+work.exe" start, but after it die.
My VM now have 256mb RAM. I've tried to 2Gb, after 4Gb, but not working.
I've looked others discussions here, but not works.
Any idea?
Developer Trace:
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "700"
---------------------------------------------------
sysno 86
sid EC6
systemid 562 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 111
intno 20050900
make: multithreaded, Unicode, 64 bit, optimized
pid 2200
Wed Apr 23 06:14:42 2014
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 (86 2200) [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 3986
Wed Apr 23 06:14:47 2014
*** 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 5361]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >p71_EC6_86 <
DpShMCreate: sizeof(wp_adm) 19248 (1480)
DpShMCreate: sizeof(tm_adm) 5584592 (27784)
DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
DpShMCreate: sizeof(comm_adm) 552080 (1088)
DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
DpShMCreate: sizeof(slock_adm) 0 (104)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1864)
DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000D0E0050, size: 6275136)
DpShMCreate: allocated sys_adm at 000000000D0E0050
DpShMCreate: allocated wp_adm at 000000000D0E2150
DpShMCreate: allocated tm_adm_list at 000000000D0E6C80
DpShMCreate: allocated tm_adm at 000000000D0E6CE0
DpShMCreate: allocated wp_ca_adm at 000000000D63A3B0
DpShMCreate: allocated appc_ca_adm at 000000000D640170
DpShMCreate: allocated comm_adm at 000000000D6420B0
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 000000000D6C8D40
DpShMCreate: allocated gw_adm at 000000000D6C8DC0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 000000000D6C8DF0
DpShMCreate: allocated wall_adm at 000000000D6C8E00
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 4096 kByte.
<ES> Info: em/initial_size_MB( 510MB) not multiple of em/blocksize_KB( 4096KB)
<ES> Info: em/initial_size_MB rounded up to 512MB
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 127 blocks reserved for free list.
ES initialized.
Wed Apr 23 06:14:48 2014
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1629]
Wed Apr 23 06:14:49 2014
***LOG Q0K=> DpMsAttach, mscon ( p71) [dpxxdisp.c 11753]
DpStartStopMsg: send start message (myname is >p71_EC6_86 <)
DpStartStopMsg: start msg sent
Wed Apr 23 06:14:50 2014
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
Wed Apr 23 06:16:44 2014
CCMS: start to initalize 3.X shared alert area (first segment).
Wed Apr 23 06:17:05 2014
*** ERROR => W0 (pid 1944) died [dpxxdisp.c 14441]
*** ERROR => W1 (pid 844) died [dpxxdisp.c 14441]
*** ERROR => W2 (pid 728) died [dpxxdisp.c 14441]
*** ERROR => W3 (pid 216) died [dpxxdisp.c 14441]
*** ERROR => W4 (pid 2948) died [dpxxdisp.c 14441]
*** ERROR => W5 (pid 368) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbf --> 0xbe
Wed Apr 23 06:17:06 2014
*** ERROR => W6 (pid 648) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbe --> 0xbc
*** ERROR => W7 (pid 2488) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbc --> 0xb8
*** ERROR => W8 (pid 2496) died [dpxxdisp.c 14441]
*** ERROR => W9 (pid 880) died [dpxxdisp.c 14441]
*** ERROR => W10 (pid 1040) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xb8 --> 0xb0
*** ERROR => W11 (pid 1920) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xb0 --> 0xa0
*** ERROR => W12 (pid 2448) 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=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:13 2014
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Wed Apr 23 13:17:13 2014
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-------------------------------------------------------------------------------------------------------------------------------
0 DIA 1944 Ended no 1 0 0
1 DIA 844 Ended no 1 0 0
2 DIA 728 Ended no 1 0 0
3 DIA 216 Ended no 1 0 0
4 DIA 2948 Ended no 1 0 0
5 DIA 368 Ended no 1 0 0
6 UPD 648 Ended no 1 0 0
7 ENQ 2488 Ended no 1 0 0
8 BTC 2496 Ended no 1 0 0
9 BTC 880 Ended no 1 0 0
10 BTC 1040 Ended no 1 0 0
11 SPO 1920 Ended no 1 0 0
12 UP2 2448 Ended no 1 0 0
Dispatcher Queue Statistics Wed Apr 23 13:17:13 2014
===========================
+------+--------+--------+--------+--------+--------+
| Typ | now | high | max | writes | reads |
+------+--------+--------+--------+--------+--------+
| NOWP | 4 | 4 | 2000 | 4 | 0 |
+------+--------+--------+--------+--------+--------+
| DIA | 2 | 2 | 2000 | 2 | 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 7
wake_evt_udp_now 1
wake events total 6, udp 1 ( 16%), shm 5 ( 83%)
since last update total 6, udp 1 ( 16%), shm 5 ( 83%)
Dump of tm_adm structure: Wed Apr 23 13:17:13 2014
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Wed Apr 23 13:17:13 2014
=============================
Slots: 300, Used: 0, Max: 0
+------+--------------+----------+-------------+
| id | owner | pid | eyecatcher |
+------+--------------+----------+-------------+
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:16 2014
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >p71_EC6_86 < (normal)
DpJ2eeDisableRestart
DpModState: buffer in state MBUF_OFF
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 (832) (SOFT_KILL)
Stop icman
killing process (176) (SOFT_KILL)
Terminate gui connections
wait for end of work processes
wait for end of gateway
[DpProcDied] Process lives (PID:832 HANDLE:544)
waiting for termination of gateway ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:17 2014
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:832 HANDLE:544)
wait for end of icman
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:18 2014
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:19 2014
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:20 2014
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:21 2014
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:22 2014
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:23 2014
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:176 HANDLE:556)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=577
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Apr 23 06:17:24 2014
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:176 HANDLE:556)
DpStartStopMsg: send stop message (myname is >p71_EC6_86 <)
NiIMyHostName: hostname = 'p71'
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
NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes
MsIBufAlloc: allocated buffer
NiIRead: hdl 2 received data (rcd=458,pac=1,MESG_IO)
NiBufIIn: NIBUF len=458
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 458 bytes
MSG received, len 110+348, flag 4, from p71_EC6_86 , typ 0, key FFFFFFFF00000000
DpHalt: received 348 bytes from message server
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 -
DpHalt: received 4 bytes from message server
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 -
DpHalt: received 4 bytes from message server
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 -
DpHalt: received 4 bytes from message server
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 -
DpHalt: received 4 bytes from message server
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 -
DpHalt: received 4 bytes from message server
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 -
DpHalt: received 4 bytes from message server
NiIRead: hdl 2 received data (rcd=214,pac=1,MESG_IO)
NiBufIIn: NIBUF len=214
NiBufIIn: packet complete for hdl 2
NiBufReceive starting
MsINiRead: received 214 bytes
MSG received, len 110+104, flag 3, from MSG_SERVER , typ 0, key -
DpHalt: received 104 bytes from message server
NiIRead: hdl 2 received data (rcd=8,pac=1,MESG_IO)
NiBufIIn: NIBUF len=8
NiBufIProcMsg: hdl 2 received NI_PONG: wait_count: 1
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 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 -
Received 164 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 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)
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 -
DpHalt: received 4 bytes from message server
NiIRead: hdl 2 recv would block (errno=EAGAIN)
Wed Apr 23 06:17:25 2014
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 464 to: ---
NiBufISelRemove: remove hdl 2 from set0
SiSelNRemove: removed sock 464
NiSelIRemove: removed hdl 2
NiICloseHandle: shutdown and close hdl 2 / sock 464
NiBufIClose: clear extension for hdl 2
Wed Apr 23 06:17:26 2014
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 2200) [dpxxdisp.c 10371]
Good Bye .....
Leandro,
256 MB RAM is far too small to try to start an ABAP application server. I believe 2 GB would work with older 7.00 releases, and it looks like you are using 7.00 with an old kernel patch level. Nowadays I don't think ABAP systems will even install in less than 8 GB.
In any case, double-check how much memory you are giving your application (what is PHYS_MEMSIZE set to in your default or instance profile?), and what user the application is starting under (i.e., make sure that the service starts under the SAPService<SID> user).
Regards,
Matt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Leandro,
Can you please check Note 491174 - Composite nor for ORA-01034
Can you also check http://sap.ittoolbox.com/groups/technical-functional/sap-basis/sqlerror-1034-and-sap-connect-problem...
Hope it helps.
Regards,
Deepanshu Sharma
Deepanshu,
I started DB:
SQL> startup
ORACLE instance started.
Total System Global Area 658505728 bytes
Fixed Size 2006576 bytes
Variable Size 339739088 bytes
Database Buffers 314572800 bytes
Redo Buffers 2187264 bytes
Database mounted.
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [53], [27], [], [], [], [],
[]
Then I cheked in CMD:
saplicense -show name=3DEC6
The license shows OK.
Then I started SAP System:
After seconds, disp+work.exe is down and in CMD:
C:\Documents and Settings\ec6adm>saplicense -show name=3DEC6
*** SAPLICENSE (Release 700) ERROR ***
ERROR: Connect to database failed
DETAILS: DbSlConnect failed with return code 99
SQL-ERROR 1034 (check DB manual for explanation)
DB is down...
I tried again to start DB and it shows:
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
I'll check the SAP note
Thanks
hi Leandro,
Please check the below SAP notes and link.
** ERROR => ThrSaveSPAFields: no valid thr_wpadm
*** ERROR => ThCallHooks: event handler ThrSaveSPAFields
Note 556232 - Environment settings for R/3/Oracle on Windows
ORA-00600: internal error code, arguments: [4194], [53], [27], [], [], [], [],
376755 - ORA-00600 - what to do?
ORA-00607, ORA-00600
Regards,
Guys, it's working!!!!!
I followed the steps of link and it's working!!!
http://dbabasis.wordpress.com/2012/07/16/ora-00600-internal-error-code-arguments-4194ab/
Thank you soo much!!!
With regards to your screenshot it is with your admin userid
Please login to <SID>adm and then try R3trans -d and / or also you can try R3trans -x
Please see if database is ON. You can see the same in Task manager in windows.
Regards,
Deepanshu Sharma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
1. Just do the full restart and than try
2. Kindly refer the SAP notes
1054467 - Local host name refers to loopback address
1934023 - Application server startup fail
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Provide the trans.log file after executing R3trans -d
Also provide the dev_w0 trace file.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
dev_w0 log
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Wed Apr 23 20:36:20 2014
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\EC6\DVEBMGS86\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\EC6\DVEBMGS86\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\EC6\DVEBMGS86\exe\dboraslib.dll' is "700.08", patchlevel (0.107)
B New connection 0 created
M sysno 86
M sid EC6
M systemid 562 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 111
M intno 20050900
M make: multithreaded, Unicode, 64 bit, optimized
M pid 3572
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 3572) [dpxxdisp.c 1301]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M
M Wed Apr 23 20:36:21 2014
M DpShMCreate: sizeof(wp_adm) 19248 (1480)
M DpShMCreate: sizeof(tm_adm) 5584592 (27784)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M DpShMCreate: sizeof(comm_adm) 552080 (1088)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (104)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1864)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000F0E0050, size: 6275136)
M DpShMCreate: allocated sys_adm at 000000000F0E0050
M DpShMCreate: allocated wp_adm at 000000000F0E2150
M DpShMCreate: allocated tm_adm_list at 000000000F0E6C80
M DpShMCreate: allocated tm_adm at 000000000F0E6CE0
M DpShMCreate: allocated wp_ca_adm at 000000000F63A3B0
M DpShMCreate: allocated appc_ca_adm at 000000000F640170
M DpShMCreate: allocated comm_adm at 000000000F6420B0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 000000000F6C8D40
M DpShMCreate: allocated gw_adm at 000000000F6C8DC0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 000000000F6C8DF0
M DpShMCreate: allocated wall_adm at 000000000F6C8E00
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 ThInit: running on host p71
M
M Wed Apr 23 20:36:22 2014
M calling db_connect ...
C Prepending D:\usr\sap\EC6\DVEBMGS86\exe to Path.
C
C Wed Apr 23 20:36:24 2014
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 /@EC6 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 0000000013A860C0 0000000008A6EAF0 00000000081BC8F8
C Attaching to DB Server EC6 (con_hdl=0,svchp=00000000081BC7B8,srvhp=0000000013AAAC68)
C Starting user session (con_hdl=0,svchp=00000000081BC7B8,srvhp=0000000013AAAC68,usrhp=0000000008A6F308)
C Now '/@EC6' is connected (con_hdl 0, nls_hdl 0).
C
C Wed Apr 23 20:36:25 2014
C Got SAPSR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=00000000081BC7B8,usrhp=0000000008A6F308)
C Now I'm disconnected from ORACLE
C Connecting as SAPSR3/<pwd>@EC6 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 0000000013A860C0 0000000008A6EAF0 00000000081BC8F8
C Starting user session (con_hdl=0,svchp=00000000081BC7B8,srvhp=0000000013AAAC68,usrhp=0000000008A6F308)
C Now 'SAPSR3/<pwd>@EC6' is connected (con_hdl 0, nls_hdl 0).
C Database NLS settings: AMERICAN_AMERICA.UTF8
C DB instance EC6 is running on P71 with ORACLE version 10.2.0.1.0 since APR 23, 2014, 20:35:45
B Connection 0 opened (DBSL handle 0)
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20140423 203622 P71
M db_connect o.k.
M ICT: exclude compression: *.zip,*.cs,*.rar,*.arj,*.z,*.gz,*.tar,*.lzh,*.cab,*.hqx,*.ace,*.jar,*.ear,*.war,*.css,*.pdf,*.js,*.gzip,*.uue,*.bz2,*.iso,*.sda,*.sar,*.gif
I
I Wed Apr 23 20:50:15 2014
I MtxInit: 0 0 0
M SHM_PRES_BUF (addr: 0000000013DF0050, size: 4400000)
M SHM_ROLL_AREA (addr: 000007FFF3290050, size: 61440000)
M SHM_PAGING_AREA (addr: 0000000014230050, size: 32768000)
M SHM_ROLL_ADM (addr: 0000000016180050, size: 615040)
M SHM_PAGING_ADM (addr: 0000000016220050, size: 525344)
M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 00000000162B0050
M ThCreateNoBuffer index size: 3000 elems
M ThCreateVBAdm allocated 12176 bytes (50 server) at 0000000009080050
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X ES initialized.
C OCI-call failed with -1=OCI_ERROR
C SQL error 3113: 'ORA-03113: end-of-file on communication channel'
C *** ERROR => Error 3113 in stmt_fetch() from oci_execute_stmt(), orpc=0
[dbsloci.c 12714]
C *** ERROR => ORA-3113 occurred when executing SQL stmt (parse error offset=0)
[dbsloci.c 12733]
C sc_p=0000000008A3A958,no=1,idc_p=0000000008A548C0,con=0,act=1,slen=66,smax=256,#vars=0,stmt=0000000013AF1FA0,table=DDNTT
C SELECT COUNT(*) FROM DDNTT WHERE TABFORM <> 'J' AND TABFORM <> 'V';
C sc_p=0000000008A3A958,no=1,idc_p=0000000008A548C0,con=0,act=1,slen=66,smax=256,#vars=0,stmt=0000000013AF1FA0,table=DDNTT
C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=0000000000000000,ocistmth_p=0000000013AB24F8
C IN : cols=0,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=0,vmax=0,bound=0,iobuf_p=0000000000000000,vda_p=0000000000000000
C lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0
C OUT: cols=1,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=-1,rsize=4,vmax=32,bound=1,iobuf_p=00000000003BC220,vda_p=000000000890FFA0
C lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0
C SELECT COUNT(*) FROM DDNTT WHERE TABFORM <> 'J' AND TABFORM <> 'V';
B ***LOG BYM=> severe DB error 3113 ; work process in reconnect status [dbsh#2 @ 1123] [dbsh 1123 ]
B ***LOG BY4=> sql error 3113 performing SEL on table DDNTT [dbstat#4 @ 693] [dbstat 0693 ]
B ***LOG BY0=> ORA-03113: end-of-file on communication channel [dbstat#4 @ 693] [dbstat 0693 ]
B init: Got no entries from DDNTT !
B init failed
B db_stinit failed
M *** ERROR => ThCallHooks: event handler db_init for event CREATE_SHM failed [thxxtool3.c 260]
M *** ERROR => ThIPCInit: hook failed [thxxhead.c 2067]
M ***LOG R19=> ThInit, ThIPCInit ( TSKH-IPC-000001) [thxxhead.c 1509]
M in_ThErrHandle: 1
M *** ERROR => ThInit: ThIPCInit (step 1, th_errno 17, 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 = 40
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 p71_EC6_86 on host p71 (wp 0)
M * ERROR ThInit: ThIPCInit
M *
M * TIME Wed Apr 23 20:50:15 2014
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 17
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 3572) [dpnttool.c 327]
trans.log
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 : 23.04.2014 - 20:53:51
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Wed Apr 23 20:53:54 2014 15221 0.015221
4 ETW000 [dev trc ,00000] db_con_init called 31 0.015252
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 50 0.015302
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 38 0.015340
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 17581 0.032921
4 ETW000 [dev trc ,00000] using "D:\usr\sap\EC6\SYS\exe\uc\NTAMD64\dboraslib.dll"
4 ETW000 38 0.032959
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 16 0.032975
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 24 0.032999
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.107)
4 ETW000 21561 0.054560
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 33 0.054593
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 38 0.054631
4 ETW000 [dev trc ,00000] New connection 0 created 25 0.054656
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 51 0.054707
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 26 0.054733
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 34 0.054767
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 28 0.054795
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 1581 0.056376
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 76300 0.132676
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 23 0.132699
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1384 0.134083
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 13 0.134096
4 ETW000 [dev trc ,00000] Connecting as /@EC6 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 15 0.134111
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 15 0.134126
4 ETW000 [dev trc ,00000] 0 UTF8 1 0000000005294090 0000000004FA7CF0 0000000004FAD4B8
4 ETW000 50 0.134176
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 13 0.134189
4 ETW000 [dev trc ,00000] Allocating server context handle 8 0.134197
4 ETW000 [dev trc ,00000] Attaching to DB Server EC6 (con_hdl=0,svchp=0000000004FAD378,srvhp=00000000052B30E8)
4 ETW000 25 0.134222
4 ETW000 [dev trc ,00000] Assigning server context 00000000052B30E8 to service context 0000000004FAD378
4 ETW000 10963 0.145185
4 ETW000 [dev trc ,00000] Allocating user session handle 23 0.145208
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000004FAD378,srvhp=00000000052B30E8,usrhp=0000000004FA8508)
4 ETW000 19 0.145227
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034
4 ETW000 13923 0.159150
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=00000000052B30E8)
4 ETW000 10 0.159160
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0000000004FAD378,srvhp=00000000052B30E8)
4 ETW000 10 0.159170
4 ETW000 [dev trc ,00000] Deallocating server context handle 00000000052B30E8
4 ETW000 947 0.160117
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'
4 ETW000 20 0.160137
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 8 0.160145
4 ETW000 [dev trc ,00000] Try to connect with default password 47 0.160192
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@EC6 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 9 0.160201
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 10 0.160211
4 ETW000 [dev trc ,00000] 0 UTF8 1 0000000005294090 0000000004FA7CF0 0000000004FAD4B8
4 ETW000 17 0.160228
4 ETW000 [dev trc ,00000] Allocating server context handle 7 0.160235
4 ETW000 [dev trc ,00000] Attaching to DB Server EC6 (con_hdl=0,svchp=0000000004FAD378,srvhp=00000000052B30E8)
4 ETW000 14 0.160249
4 ETW000 [dev trc ,00000] Assigning server context 00000000052B30E8 to service context 0000000004FAD378
4 ETW000 6432 0.166681
4 ETW000 [dev trc ,00000] Assigning username to user session 0000000004FA8508
4 ETW000 13 0.166694
4 ETW000 [dev trc ,00000] Assigning password to user session 0000000004FA8508
4 ETW000 17 0.166711
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000004FAD378,srvhp=00000000052B30E8,usrhp=0000000004FA8508)
4 ETW000 13 0.166724
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034
4 ETW000 19465 0.186189
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=00000000052B30E8)
4 ETW000 10 0.186199
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0000000004FAD378,srvhp=00000000052B30E8)
4 ETW000 9 0.186208
4 ETW000 [dev trc ,00000] Deallocating server context handle 00000000052B30E8
4 ETW000 880 0.187088
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'
4 ETW000 14 0.187102
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 5 0.187107
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1034 performing CON [dblink#3 @ 431]
4 ETW000 14471 0.201578
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01034: ORACLE not available 10 0.201588
4 ETW000 ORA-27101: shared memory realm does not exist [dblink#3 @ 431]
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'EC6'"
Hi Leandro,
Please check whether database is running
Also share R3trans -d log
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
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.