SAP Library - Find your answers

Hi,

This is a quite common error and the solution step-by-step is:
1. Search for notes with keyword ORA-01034.
2. Implement the relevant notes.
This issue has also been coverer in this group a number of times, so you'll
find some good hints in the archive.

Regards,
LEH

From: donny agustinus via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 25. juli 2009 07:35
To: Lars-Erik Hallsten
Subject: [sap-basis] disp+work.exe stopped after a few seconds.



I installed SAP ECC 6.0 with oracle 10.2 in windows XP SP3.
Everything went fine until i started SAP System through SAP Management
Console, this problem occur --> msg_server.EXE and igswd.EXE are running
but, disp+work.exe only running in a few seconds, afterwards, it stopped.
I have already running oracle listener in control panel> administrative tool
> service, but still the same problem occur. :(
can u guys kindly give me the solution step by step? since i do not know
very well about this problem.
and this is the log files :
1. sapstartsrv.log
---------------------------------------------------
trc file: "sapstartsrv.log", trc level: 0, release: "700"
---------------------------------------------------
Fri Jul 24 21:52:05 2009
<<- ERROR: SapSSLInit(read_profile=1)==SSSLERR_LIB_NOT_FOUND
2. dev_wo
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Fri Jul 24 22:11:57 2009
B create_con (con_name=R/3)
B Loading DB library 'C:\usr\sap\ID1\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'C:\usr\sap\ID1\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'C:\usr\sap\ID1\DVEBMGS00\exe\dboraslib.dll' is "700.08",
patchlevel (0.73)
B New connection 0 created
M sysno 00
M sid ID1
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 2224
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 2224) [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: 05DE0040, size: 4653368)
M DpShMCreate: allocated sys_adm at 05DE0040
M DpShMCreate: allocated wp_adm at 05DE1E40
M DpShMCreate: allocated tm_adm_list at 05DE65C0
M DpShMCreate: allocated tm_adm at 05DE65F0
M DpShMCreate: allocated wp_ca_adm at 061B5890
M DpShMCreate: allocated appc_ca_adm at 061BB650
M DpShMCreate: allocated comm_adm at 061BD590
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 0623E450
M DpShMCreate: allocated gw_adm at 0623E490
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 0623E4C0
M DpShMCreate: allocated wall_adm at 0623E4C8
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 Fri Jul 24 22:11:58 2009
M ThInit: running on host IDESTEST
M
M Fri Jul 24 22:11:59 2009
M calling db_connect ...
C Prepending C:\usr\sap\ID1\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 /@ID1 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C Nls CharacterSet NationalCharSet C EnvHp
ErrHp ErrHpBatch
C 0 UTF8 1 06336CF8
0633C294 0633BB1C
C Attaching to DB Server ID1 (con_hdl=0,svchp=0633BA68,svrhp=0634B7F4)
C Starting user session
(con_hdl=0,svchp=0633BA68,srvhp=0634B7F4,usrhp=0635EBF8)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
[dboci.c 4391]
C Detaching from DB Server (con_hdl=0,svchp=0633BA68,srvhp=0634B7F4)
C *** ERROR => CONNECT failed with sql error '1034'
[dbsloci.c 10933]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@ID1 on connection 0 (nls_hdl 0) ... (dbsl 700
110706)
C Nls CharacterSet NationalCharSet C EnvHp
ErrHp ErrHpBatch
C 0 UTF8 1 06336CF8
0633C294 0633BB1C
C Attaching to DB Server ID1 (con_hdl=0,svchp=0633BA68,svrhp=0634B7F4)
C Starting user session
(con_hdl=0,svchp=0633BA68,srvhp=0634B7F4,usrhp=0635EBF8)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
[dboci.c 4391]
C Detaching from DB Server (con_hdl=0,svchp=0633BA68,srvhp=0634B7F4)
C *** ERROR => CONNECT failed with sql error '1034'
[dbsloci.c 10933]
B ***LOG BV3=> severe db error 1034 ; work process is stopped [dbsh#2 @
1199] [dbsh 1199 ]
B ***LOG BY2=> sql error 1034 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist [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 IDESTEST_ID1_00 on host IDESTEST (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Fri Jul 24 22:11:59 2009
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 ***LOG Q02=> wp_halt, WPStop (Workproc 0 2224) [dpnttool.c 327]
3. dev_ms
---------------------------------------------------
trc file: "dev_ms", trc level: 1, release: "700"
---------------------------------------------------
[Thr 4092] Fri Jul 24 22:11:52 2009
[Thr 4092] MsSSetTrcLog: trc logging active, max size = 20971520 bytes
systemid 560 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 73
intno 20050900
make: multithreaded, Unicode, optimized
pid 4088
[Thr 4092] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 4088) [msxxserv.c
1824]
[Thr 4092] load acl file = C:\usr\sap\ID1\SYS\global\ms_acl_info.DAT
[Thr 4092] MsGetOwnIpAddr: my host addresses are :
[Thr 4092] 1 : [161.101.221.18] IDESTEST (HOSTNAME)
[Thr 4092] 2 : [127.0.0.1] localhost (LOCALHOST)
[Thr 4092] 3 : [192.168.0.101] IDESTEST (NILIST)
[Thr 4092] MsHttpInit: full qualified hostname = IDESTEST
[Thr 4092] HTTP logging is switch off
[Thr 4092] set HTTP state to LISTEN
[Thr 4092] ms/icf_info_server : deleted
[Thr 4092] *** I listen to port sapmsID1 (3600) ***
[Thr 4092] *** I listen to internal port 3900 (3900) ***
[Thr 4092] *** HTTP port 8100 state LISTEN ***
[Thr 4092] CUSTOMER KEY: >C1933564024<
[Thr 4092] Fri Jul 24 22:13:04 2009
[Thr 4092] *** ERROR => MsSClientHandle: no server provides service ENQ (4),
requested from IDESTEST_ID1_00 [msxxserv.c 4679]
[Thr 1208] Fri Jul 24 22:21:24 2009
[Thr 1208] Ms __.____._