on 02-10-2008 10:10 AM
Hi,
I have installed ECC 5.0, Win 2003serv, Oracle 9i, on my test server. installation went fine, i have done post installation also.
then next day i started my server, it is showing all the work process status' ENDED'. I found Oracle all processes, sap processes are running. When i run r3trans -d its thrown an error
' no connection possible "connection failed with DBLI_RC_LOAD_LIB_FAILED." r3trans finished (0012).
could anybody help me to solve this.
Regards,
Ravi Kumar.D
first check whether the database is up from the command prompt. copy paste the trace file here.
Edited by: jet l.....i on Feb 10, 2008 4:31 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here the trace file follows..
-
trc file: "dev_disp", trc level: 1, release: "640"
-
Thu Sep 17 17:29:24 2020
kernel runs with dp version 128(ext=102) (@(#) DPLIB-INT-VERSION-128)
length of sys_adm_ext is 312 bytes
systemid 560 (PC with Windows NT)
relno 6400
patchlevel 0
patchno 43
intno 20020600
make: multithreaded, ASCII
pid 3712
Thu Sep 17 17:29:25 2020
***LOG Q00=> DpSapEnvInit, DPStart (00 3712) [dpxxdisp.c 1100]
shared lib "dw_xml.dll" version 43 successfully loaded
shared lib "dw_xtc.dll" version 43 successfully loaded
shared lib "dw_stl.dll" version 43 successfully loaded
shared lib "dw_gui.dll" version 43 successfully loaded
Thu Sep 17 17:29:30 2020
WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3886]
MtxInit: -2 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: JAVA is not active
DpShMCreate: sizeof(wp_adm) 6624 (828)
DpShMCreate: sizeof(tm_adm) 2219848 (11044)
DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
DpShMCreate: sizeof(comm_adm) 192000 (384)
DpShMCreate: sizeof(vmc_adm) 0 (320)
DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
DpShMCreate: SHM_DP_ADM_KEY (addr: 03AB0040, size: 2505416)
DpShMCreate: allocated sys_adm at 03AB0040
DpShMCreate: allocated wp_adm at 03AB17A8
DpShMCreate: allocated tm_adm_list at 03AB3188
DpShMCreate: allocated tm_adm at 03AB31B0
DpShMCreate: allocated wp_ca_adm at 03CD10F8
DpShMCreate: allocated appc_ca_adm at 03CD5748
DpShMCreate: allocated comm_adm_list at 03CD6EB8
DpShMCreate: allocated comm_adm at 03CD6ED0
DpShMCreate: allocated vmc_adm_list at 03D05CD0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 03D05CF8
DpShMCreate: allocated wall_adm at 03D05D00
MBUF state OFF
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation flat
<EsNT> Memory Reset disabled as NT default
<ES> 535 blocks reserved for free list.
ES initialized.
Thu Sep 17 17:29:31 2020
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG Q0K=> DpMsAttach, mscon ( ehmumd) [dpxxdisp.c 9736]
Thu Sep 17 17:29:32 2020
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 6400, patchlevel 0
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1025]
DpMsgAdmin: Set patchno for this platform to 43
Release check o.K.
Thu Sep 17 17:30:11 2020
ERROR => W0 (pid 4000) died [dpxxdisp.c 12187]
ERROR => W1 (pid 4008) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbf --> 0xbe
ERROR => W2 (pid 4016) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbe --> 0xbc
ERROR => W3 (pid 4024) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbc --> 0xb8
ERROR => W4 (pid 4032) died [dpxxdisp.c 12187]
ERROR => W5 (pid 4040) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xb8 --> 0xb0
ERROR => W6 (pid 4048) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xb0 --> 0xa0
ERROR => W7 (pid 4056) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xa0 --> 0x80
DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
killing W0-4000 (SIGUSR2)
ERROR => DpWpKill(4000, SIGUSR2) failed [dpxxtool.c 2468]
killing W1-4008 (SIGUSR2)
ERROR => DpWpKill(4008, SIGUSR2) failed [dpxxtool.c 2468]
killing W2-4016 (SIGUSR2)
ERROR => DpWpKill(4016, SIGUSR2) failed [dpxxtool.c 2468]
killing W3-4024 (SIGUSR2)
ERROR => DpWpKill(4024, SIGUSR2) failed [dpxxtool.c 2468]
killing W4-4032 (SIGUSR2)
ERROR => DpWpKill(4032, SIGUSR2) failed [dpxxtool.c 2468]
killing W5-4040 (SIGUSR2)
ERROR => DpWpKill(4040, SIGUSR2) failed [dpxxtool.c 2468]
killing W6-4048 (SIGUSR2)
ERROR => DpWpKill(4048, SIGUSR2) failed [dpxxtool.c 2468]
killing W7-4056 (SIGUSR2)
ERROR => DpWpKill(4056, SIGUSR2) failed [dpxxtool.c 2468]
NiWait: sleep (10000 msecs) ...
NiISelect: timeout 10000 ms
NiISelect: maximum fd=1653
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Sep 17 17:30:21 2020
NiISelect: TIMEOUT occured (10000 ms)
dump system status
Workprocess Table (long) Thu Sep 17 12:00:21 2020
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA 4000 Ended no 1 0 0
1 DIA 4008 Ended no 1 0 0
2 UPD 4016 Ended no 1 0 0
3 ENQ 4024 Ended no 1 0 0
4 BTC 4032 Ended no 1 0 0
5 BTC 4040 Ended no 1 0 0
6 SPO 4048 Ended no 1 0 0
7 UP2 4056 Ended no 1 0 0
Dispatcher Queue Statistics Thu Sep 17 12:00:21 2020
===========================
--------
+
Typ | now | high | max | writes | reads |
--------
+
NOWP | 0 | 3 | 2000 | 10 | 10 |
--------
+
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 13
wake_evt_udp_now 0
wake events total 9, udp 7 ( 77%), shm 2 ( 22%)
since last update total 9, udp 7 ( 77%), shm 2 ( 22%)
Dump of tm_adm structure: Thu Sep 17 12:00:21 2020
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Thu Sep 17 12:00:21 2020
=============================
Slots: 300, Used: 1, Max: 0
--------
+
id | owner | pid | eyecatcher |
--------
+
0 | DISPATCHER | -1 | WPCAAD000 |
NiWait: sleep (5000 msecs) ...
NiISelect: timeout 5000 ms
NiISelect: maximum fd=1653
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Sep 17 17:30:26 2020
NiISelect: TIMEOUT occured (5000 ms)
Shutdown server ...
DpJ2eeDisableRestart
DpModState: buffer in state MBUF_PREPARED
NiBufSend starting
NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete
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 (3964) (SOFT_KILL)
Stop icman
killing process (3992) (SOFT_KILL)
Terminate gui connections
[DpProcDied] Process lives (PID:3964 HANDLE:1624)
waiting for termination of gateway
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=1653
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Sep 17 17:30:27 2020
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process died (PID:3964 HANDLE:1624)
[DpProcDied] Process died (PID:3992 HANDLE:1616)
DpHalt: cancel all lcom connections
MPI CancelAll 2 -> 0
MPI DeleteAll 2 -> 0
NiIMyHostName: hostname = 'ehmumd'
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 = 163 bytes
NiBufSend starting
NiIWrite: write 562, 1 packs, MESG_IO, hdl 3, data complete
MsINiWrite: sent 562 bytes
send msg (len 110+452) to name -, type 4, key -
detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9962]
NiBufSend starting
NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete
MsINiWrite: sent 110 bytes
MsIDetach: send logout to msg_server
MsIDetach: call exit function
DpMsShutdownHook called
NiSelClear: removed hdl 3 from selectset
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/8
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 19)
MBUF component DOWN
NiBufClose: clear extensions for hdl 3
NiBufSetStat: bufstat of hdl 3 changed from OK to OFF
NiICloseHandle: shutdown and close hdl 3 / socket 1632
MsIDetach: detach MS-system
EsCleanup ....
***LOG Q05=> DpHalt, DPStop ( 3712) [dpxxdisp.c 8495]
Good Bye .....
-
and could you please tell me how can i check whether database is up and running, from command prompt...!!!
login as sidadm, goto command prompt,
sqlplus /nolog (u will get command prompt after this)
conn /as sysdba. (u will login as sysdba)
if logged in try startup with command
startup
to check the status of the database:
select status from v$instance;
it should be open.
if it is open then there is no problem with database.
ur work process are dying, give trace file of wp.
Edited by: jet l.....i on Feb 10, 2008 6:27 PM
I entered into OS level by SYSDBA. It is connecting.
when entered into BRTOOLS
when i say Instance status it shows - MOUNTED.
the below is workprocess trace file.
pls advise me the solution.
-
trc file: "dev_w0", trc level: 1, release: "640"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Fri Sep 18 02:43:51 2020
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\ECC\SYS\exe\run\dboraslib.dll' ...
B Library 'D:\usr\sap\ECC\SYS\exe\run\dboraslib.dll' loaded
B Version of 'D:\usr\sap\ECC\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.39)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6400
M patchlevel 0
M patchno 43
M intno 20020600
M make: multithreaded, ASCII
M pid 2288
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2288) [dpxxdisp.c 1160]
I MtxInit: -2 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: JAVA is not active
M DpShMCreate: sizeof(wp_adm) 6624 (828)
M DpShMCreate: sizeof(tm_adm) 2219848 (11044)
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: 03AB0040, size: 2505416)
M DpShMCreate: allocated sys_adm at 03AB0040
M DpShMCreate: allocated wp_adm at 03AB17A8
M DpShMCreate: allocated tm_adm_list at 03AB3188
M DpShMCreate: allocated tm_adm at 03AB31B0
M DpShMCreate: allocated wp_ca_adm at 03CD10F8
M DpShMCreate: allocated appc_ca_adm at 03CD5748
M DpShMCreate: allocated comm_adm_list at 03CD6EB8
M DpShMCreate: allocated comm_adm at 03CD6ED0
M DpShMCreate: allocated vmc_adm_list at 03D05CD0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 03D05CF8
M DpShMCreate: allocated wall_adm at 03D05D00
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation flat
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Fri Sep 18 02:43:52 2020
M calling db_connect ...
C Got ORACLE_HOME=D:\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=03912FEC,svrhp=03913BC4)
C
C Fri Sep 18 02:44:28 2020
C Starting user session (con_hdl=0,svchp=03912FEC,srvhp=03913BC4,usrhp=0391C39C)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
[dboci.c 3720]
C Detaching from DB Server (con_hdl=0,svchp=03912FEC,srvhp=03913BC4)
C *** ERROR => CONNECT failed with sql error '1033'
[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=03912FEC,svrhp=03913BC4)
C Starting user session (con_hdl=0,svchp=03912FEC,srvhp=03913BC4,usrhp=0391C39C)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
[dboci.c 3720]
C Detaching from DB Server (con_hdl=0,svchp=03912FEC,srvhp=03913BC4)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 9750]
B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 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) [thxxhead.c 1269]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]
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 ehmumd_ECC_00 on host ehmumd (wp 0)
M * ERROR tskh_init: db_connect
M *
M * TIME Fri Sep 18 02:44:28 2020
M * RELEASE 640
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 9589
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 730]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 252]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2288) [dpnttool.c 357]
regards,
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
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.