on 08-06-2009 2:21 PM
Hi Friends,
I have upgraded kernel from patch 133 to 175 disp +work stopped , i have tried all the possible ways, checked the notes and googled but still not successfull.
I have pastedthe log file
-
trc file: "dev_disp", trc level: 1, release: "700"
-
sysno 06
sid DOL
systemid 560 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 175
intno 20050900
make: multithreaded, Unicode, optimized
pid 89712
Thu Aug 06 14:11:08 2009
kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
length of sys_adm_ext is 576 bytes
SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (01 89712) [dpxxdisp.c 1261]
shared lib "dw_xml.dll" version 175 successfully loaded
shared lib "dw_xtc.dll" version 175 successfully loaded
shared lib "dw_stl.dll" version 175 successfully loaded
shared lib "dw_gui.dll" version 175 successfully loaded
shared lib "dw_mdm.dll" version 175 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3901
Thu Aug 06 14:11:13 2009
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 5418]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >sdcdolm01_DOL_01 <
DpShMCreate: sizeof(wp_adm) 42600 (1704)
DpShMCreate: sizeof(tm_adm) 4415616 (21968)
DpShMCreate: sizeof(wp_ca_adm) 24064 (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 (1544)
DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 05F30040, size: 5099800)
DpShMCreate: allocated sys_adm at 05F30040
DpShMCreate: allocated wp_adm at 05F32118
DpShMCreate: allocated tm_adm_list at 05F3C780
DpShMCreate: allocated tm_adm at 05F3C7B0
DpShMCreate: allocated wp_ca_adm at 06372830
DpShMCreate: allocated appc_ca_adm at 06378630
DpShMCreate: allocated comm_adm at 0637A570
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 063FB430
DpShMCreate: allocated gw_adm at 063FB470
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 063FB4A0
DpShMCreate: allocated wall_adm at 063FB4A8
MBUF state OFF
DpCommInitTable: init table for 500 entries
rdisp/queue_size_check_value : -> off
ThTaskStatus: rdisp/reset_online_during_debug 0
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.
***LOG Q0I=> NiIBindSocket: bind (10013: WSAEACCES: Permission denied) [nixxi.cpp 3227]
ERROR => NiIBindSocket: SiBind failed for hdl 0 / sock 1548
(SI_EPORT_INUSE/10013; I4; DG; 127.0.0.1:3201) [nixxi.cpp 3227]
ERROR => DpCommInit: NiDgHdlBindName failed: -4 [dpxxdisp.c 9955]
DP_FATAL_ERROR => DpSapEnvInit: DpCommInit
DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
NiWait: sleep (10000ms) ...
NiISelect: timeout 10000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Aug 06 14:11:23 2009
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Thu Aug 06 13:11:23 2009
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA -1 Run no 0 0 0
1 DIA -1 Run no 0 0 0
2 DIA -1 Run no 0 0 0
3 DIA -1 Run no 0 0 0
4 DIA -1 Run no 0 0 0
5 DIA -1 Run no 0 0 0
6 DIA -1 Run no 0 0 0
7 DIA -1 Run no 0 0 0
8 DIA -1 Run no 0 0 0
9 DIA -1 Run no 0 0 0
10 DIA -1 Run no 0 0 0
11 DIA -1 Run no 0 0 0
12 DIA -1 Run no 0 0 0
13 DIA -1 Run no 0 0 0
14 DIA -1 Run no 0 0 0
15 UPD -1 Run no 0 0 0
16 UPD -1 Run no 0 0 0
17 ENQ -1 Run no 0 0 0
18 BTC -1 Run no 0 0 0
19 BTC -1 Run no 0 0 0
20 BTC -1 Run no 0 0 0
21 SPO -1 Run no 0 0 0
22 SPO -1 Run no 0 0 0
23 SPO -1 Run no 0 0 0
24 UP2 -1 Run no 0 0 0
Dispatcher Queue Statistics Thu Aug 06 13:11:23 2009
--------
+
max_rq_id 0
wake_evt_udp_now 0
wake events total 0, udp 0 ( 0%), shm 0 ( 0%)
since last update total 0, udp 0 ( 0%), shm 0 ( 0%)
Dump of tm_adm structure: Thu Aug 06 13:11:23 2009
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Thu Aug 06 13:11:23 2009
=============================
Slots: 300, Used: 0, Max: 0
--------
+
id | owner | pid | eyecatcher |
--------
+
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Aug 06 14:11:28 2009
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >sdcdolm01_DOL_01 < (normal)
DpJ2eeDisableRestart
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
[DpWpDied] W0 handle not set (PID:-1)
[DpWpDied] W1 handle not set (PID:-1)
[DpWpDied] W2 handle not set (PID:-1)
[DpWpDied] W3 handle not set (PID:-1)
[DpWpDied] W4 handle not set (PID:-1)
[DpWpDied] W5 handle not set (PID:-1)
[DpWpDied] W6 handle not set (PID:-1)
[DpWpDied] W7 handle not set (PID:-1)
[DpWpDied] W8 handle not set (PID:-1)
[DpWpDied] W9 handle not set (PID:-1)
[DpWpDied] W10 handle not set (PID:-1)
[DpWpDied] W11 handle not set (PID:-1)
[DpWpDied] W12 handle not set (PID:-1)
[DpWpDied] W13 handle not set (PID:-1)
[DpWpDied] W14 handle not set (PID:-1)
[DpWpDied] W15 handle not set (PID:-1)
[DpWpDied] W16 handle not set (PID:-1)
[DpWpDied] W17 handle not set (PID:-1)
[DpWpDied] W18 handle not set (PID:-1)
[DpWpDied] W19 handle not set (PID:-1)
[DpWpDied] W20 handle not set (PID:-1)
[DpWpDied] W21 handle not set (PID:-1)
[DpWpDied] W22 handle not set (PID:-1)
[DpWpDied] W23 handle not set (PID:-1)
[DpWpDied] W24 handle not set (PID:-1)
Stop work processes
Terminate gui connections
wait for end of work processes
not attached to the message server
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 89712) [dpxxdisp.c 10908]
Good Bye .....
Krishna,
Your main issue was with
***LOG Q0I=> NiIBindSocket: bind (10013: WSAEACCES: Permission denied) [nixxi.cpp 3140]
ERROR => NiIBindSocket: SiBind failed for hdl 0 / sock 1704 (SI_ESYSCALL; I4; DG; 127.0.0.1:64998)
and then I could see it is for ORA 01017( password issue)..
but what have you done to get rid of the first error for the binding??
Regards
Prash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
as per you log posted it is showing error " ORA-28000: the account is locked ".
Please unlock user SAPSR3 from database level. use follwing command as an example to unlock. you need to login on database level with user SYSTEM having previlages sysdba.
SQL> ALTER USER SAPSR3 ACCOUNT UNLOCK;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Krishna
Did you go through https://service.sap.com/sap/support/notes/400241?
Hi,
Is your R3trans -d working? I think it shouldn't. Please paste the trans.log.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Log file
-
trc file: "dev_w0", trc level: 1, release: "700"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Mon Aug 10 13:13:38 2009
B create_con (con_name=R/3)
B Loading DB library 'M:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' ...
B Library 'M:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' loaded
B Version of 'M:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' is "700.08", patchlevel (0.167)
B New connection 0 created
M sysno 06
M sid DOL
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 175
M intno 20050900
M make: multithreaded, Unicode, optimized
M pid 6848
M
M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 6848) [dpxxdisp.c 1323]
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) 42600 (1704)
M DpShMCreate: sizeof(tm_adm) 4415616 (21968)
M DpShMCreate: sizeof(wp_ca_adm) 24064 (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 (1544)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05F30040, size: 5099800)
M DpShMCreate: allocated sys_adm at 05F30040
M DpShMCreate: allocated wp_adm at 05F32118
M DpShMCreate: allocated tm_adm_list at 05F3C780
M DpShMCreate: allocated tm_adm at 05F3C7B0
M DpShMCreate: allocated wp_ca_adm at 06372830
M DpShMCreate: allocated appc_ca_adm at 06378630
M DpShMCreate: allocated comm_adm at 0637A570
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 063FB430
M DpShMCreate: allocated gw_adm at 063FB470
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 063FB4A0
M DpShMCreate: allocated wall_adm at 063FB4A8
M rdisp/queue_size_check_value : -> off
M ThTaskStatus: rdisp/reset_online_during_debug 0
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 Mon Aug 10 13:13:39 2009
M ThInit: running on host sdcdolm01
M calling db_connect ...
C Prepending E:\usr\sap\DOL\DVEBMGD01\exe to Path.
C Oracle Client Version: '10.2.0.2.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Attaching to DB Server DOL (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44)
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
[dboci.c 4532]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11145]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
[dboci.c 4532]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11145]
B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY2=> sql error 1017 performing CON [dblink#5 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#5 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10534]
M
M Info for wp 0
M
M pid = 6848
M severity = 0
M status = 0
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 mode_cleaned_counter = 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 attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server sdcdolm01_DOL_01 on host sdcdolm01 (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Mon Aug 10 13:13:39 2009
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10754
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 723]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
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 6848) [dpnttool.c 333]
>
> B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]
> B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh 1204 ]
> B ***LOG BY2=> sql error 1017 performing CON [dblink#5 @ 431] [dblink 0431 ]
> B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#5 @ 431] [dblink 0431 ]
> M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]
The already mentioned note
Note 400241 - Problems with ops$ or sapr3 connect to Oracle
is the one to follow.
What do you mean with "I didn't succeed"? The note contains a step-by-step list which commands to execute and what to do...
The reason why the system is not coming up is that the the disp+work can't connect to the database because the OPS$-user is missing/wrong.
Markus
When i run brtools selecting option 8 and then 4 to change the password i get return code 3
BR0657I Input menu 59 - please enter/check input values
-
BRCONNECT options for changing password of database user
1 - BRCONNECT profile (profile) ............... [initDOL.sap]
2 - Database user/password (user) ............. [system/*******]
3 ~ Database owner to change password (owner) . [SAPSR3]
4 ~ Log file name (log) ....................... []
5 - Message language (language) ............... [E]
6 - BRCONNECT command line (command) .......... [-p initDOL.sap -l E -f chpass -o SAPSR3]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
__________________________________________________________
I get BR0292I Execution of BRCONNECT finished with return code 3
or when i run as below
brconnect -u system/<password> -f chpass -o sapsr3 -p <password> -
i get command not successfull.
Should i give password for sapsr3 same as system
for e.g
brconnect -u system/manager -f chpass -o sapsr3 -p manager
Alternatively when i execute at sql as below
DELETE FROM "OPS$DOLADM".SAPUSER;
INSERT INTO "OPS$DOLADM".SAPUSER VALUES ('sapsr3','manager');
When i execute command is not exedcuted, sorry can you please correct me. thanks.
kris
Hi,
When ever i am excuting the folowing commands for SAPUSER i get ORA-1031, can some one help me i have followed note
Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role, but still i get the same error message.
SQL> select* from sapuser;
select* from sapuser
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> alter user OPS$SAPSERVICEDO1 default role all;
alter user OPS$SAPSERVICEDO1 default role all
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> create table "OPS$DOLADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
create table "OPS$DOLADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256))
*
ERROR at line 1:
ORA-01031: insufficient privileges
Please some one help me.
trc file: "dev_w0", trc level: 1, release: "700"
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Tue Aug 11 13:37:43 2009
B create_con (con_name=R/3)
B Loading DB library 'E:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' ...
B Library 'K:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' loaded
B Version of 'E:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' is "700.08", patchlevel (0.167)
B New connection 0 created
M sysno 06
M sid DOL
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 175
M intno 20050900
M make: multithreaded, Unicode, optimized
M pid 9376
M
M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 9376) [dpxxdisp.c 1323]
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) 42600 (1704)
M DpShMCreate: sizeof(tm_adm) 4415616 (21968)
M DpShMCreate: sizeof(wp_ca_adm) 24064 (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 (1544)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05F30040, size: 5099800)
M DpShMCreate: allocated sys_adm at 05F30040
M DpShMCreate: allocated wp_adm at 05F32118
M DpShMCreate: allocated tm_adm_list at 05F3C780
M DpShMCreate: allocated tm_adm at 05F3C7B0
M DpShMCreate: allocated wp_ca_adm at 06372830
M DpShMCreate: allocated appc_ca_adm at 06378630
M DpShMCreate: allocated comm_adm at 0637A570
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 063FB430
M DpShMCreate: allocated gw_adm at 063FB470
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 063FB4A0
M DpShMCreate: allocated wall_adm at 063FB4A8
M rdisp/queue_size_check_value : -> off
M ThTaskStatus: rdisp/reset_online_during_debug 0
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 sdcDOLm01
M
M Tue Aug 11 13:37:44 2009
M calling db_connect ...
C Prepending E:\usr\sap\DOL\DVEBMGD01\exe to Path.
C Oracle Client Version: '10.2.0.2.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Attaching to DB Server DOL (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44)
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
[dboci.c 4532]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11145]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C Now 'SAPSR3/<pwd>@DOL' is connected: con_hdl=0, nls_hdl=0, session_id=61.
C Database NLS settings: AMERICAN_AMERICA.UTF8
C DB instance DOL is running on sdcDOLM01 with ORACLE version 10.2.0.2.0 since AUG 09, 2009, 16:00:52
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 20090811 133744 sdcDOLM01
C build_stmt: reallocating stmt buffer: 256 -> 2000 characters
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 Tue Aug 11 13:37:51 2009
I MtxInit: 0 0 0
M SHM_PRES_BUF (addr: 09B00040, size: 4400000)
M SHM_ROLL_AREA (addr: 788A0040, size: 61440000)
M SHM_PAGING_AREA (addr: 09F40040, size: 32768000)
M SHM_ROLL_ADM (addr: 0BE90040, size: 615040)
M SHM_PAGING_ADM (addr: 0BF30040, size: 525344)
M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 0BFC0040
M ThCreateNoBuffer index size: 3000 elems
M ThCreateVBAdm allocated 12160 bytes (50 server) at 0C050040
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet
C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Attaching to DB Server DOL (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44)
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C*** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017 [dboci.c 4532]
C *** ERROR => CONNECT failed with sql error '1017' [dbsloci.c 11145]
C Try to connect with default password
C Connecting as SAPSR3/@DOL on connection 0 (nls_hdl 0) ...
You stil have the problem with ORA 1017
Please try this..
alter user OPS$<SID>ADM identified by <PASSWORD>;
insert into OPS$ORA<SID>.sapuser values (u2018SAPSR3u2019,u2019PASSWORDu2019);
alter user SAPSR3 identified by <PASSWORD>;
Commit;
OR
DROP the OPS$ user & re-create it by OSS Note Note 50088 - Creating OPS$ users on Windows NT/Oracle
This might be help you.
Shambo
Log file of dev_w0 is as below
kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 10124) [dpxxdisp.c 1323]
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) 42600 (1704)
M DpShMCreate: sizeof(tm_adm) 4415616 (21968)
M DpShMCreate: sizeof(wp_ca_adm) 24064 (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 (1544)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05F30040, size: 5099800)
M DpShMCreate: allocated sys_adm at 05F30040
M DpShMCreate: allocated wp_adm at 05F32118
M DpShMCreate: allocated tm_adm_list at 05F3C780
M DpShMCreate: allocated tm_adm at 05F3C7B0
M DpShMCreate: allocated wp_ca_adm at 06372830
M DpShMCreate: allocated appc_ca_adm at 06378630
M DpShMCreate: allocated comm_adm at 0637A570
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 063FB430
M DpShMCreate: allocated gw_adm at 063FB470
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 063FB4A0
M DpShMCreate: allocated wall_adm at 063FB4A8
M rdisp/queue_size_check_value : -> off
M ThTaskStatus: rdisp/reset_online_during_debug 0
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 sdcCOLm01
M
M Tue Aug 11 15:46:44 2009
M calling db_connect ...
C Prepending E:\usr\sap\DOL\DVEBMGD01\exe to Path.
C Oracle Client Version: '10.2.0.2.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Attaching to DB Server DOL (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44)
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
[dboci.c 4532]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11145]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C Now 'SAPSR3/<pwd>@DOL' is connected: con_hdl=0, nls_hdl=0, session_id=52.
C Database NLS settings: AMERICAN_AMERICA.UTF8
C DB instance DOL is running on sdcCOLm01 with ORACLE version 10.2.0.2.0 since AUG 09, 2009, 16:00:52
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 20090811 154644 sdcCOLm01
C build_stmt: reallocating stmt buffer: 256 -> 2000 characters
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 Tue Aug 11 15:46:52 2009
I MtxInit: 0 0 0
M SHM_PRES_BUF (addr: 09B00040, size: 4400000)
M SHM_ROLL_AREA (addr: 788A0040, size: 61440000)
M SHM_PAGING_AREA (addr: 09F40040, size: 32768000)
M SHM_ROLL_ADM (addr: 0BE90040, size: 615040)
M SHM_PAGING_ADM (addr: 0BF30040, size: 525344)
M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 0BFC0040
M ThCreateNoBuffer index size: 3000 elems
M ThCreateVBAdm allocated 12160 bytes (50 server) at 0C050040
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X ES initialized.
B dbntab: NTAB buffers attached
B dbntab: Buffer FTAB(hash header) (addr: 0C0F0088, size: 536)
B dbntab: Buffer FTAB(anchor array) (addr: 0C0F02A0, size: 160036)
B dbntab: Buffer FTAB(item array) (addr: 0C1173C8, size: 720000)
B dbntab: Buffer FTAB(data area) (addr: 0C1C7048, size: 30720000)
B dbntab: Buffer IREC(hash header) (addr: 0DF20088, size: 536)
B dbntab: Buffer IREC(anchor array) (addr: 0DF202A0, size: 160036)
B dbntab: Buffer IREC(item array) (addr: 0DF473C8, size: 180000)
B dbntab: Buffer IREC(data area) (addr: 0DF732E8, size: 6144000)
B dbntab: Buffer STAB(hash header) (addr: 0E550088, size: 536)
B dbntab: Buffer STAB(anchor array) (addr: 0E5502A0, size: 160036)
B dbntab: Buffer STAB(item array) (addr: 0E5773C8, size: 180000)
B dbntab: Buffer STAB(data area) (addr: 0E5A32E8, size: 3072000)
B dbntab: Buffer TTAB(hash header) (addr: 0E8A0088, size: 3136)
B dbntab: Buffer TTAB(anchor array) (addr: 0E8A0CC8, size: 160036)
B dbntab: Buffer TTAB(item array) (addr: 0E8C7DF0, size: 480000)
B dbntab: Buffer TTAB(data area) (addr: 0E93D0F0, size: 5840000)
B db_con_shm_ini: WP_ID = 0, WP_CNT = 25, CON_ID = -1
B dbstat: TABSTAT buffer attached (addr: 0EEE2C50)
B dbtbxbuf: Buffer TABL (addr: 126C00C8, size: 30000000, end: 1435C448)
B dbtbxbuf: Buffer TABLP (addr: 108C00C8, size: 10240000, end: 112840C8)
B dbexpbuf: Buffer EIBUF (addr: 112900D0, size: 4194304, end: 116900D0)
B dbexpbuf: Buffer ESM (addr: 116A00D0, size: 4194304, end: 11AA00D0)
B dbexpbuf: Buffer CUA (addr: 11AB00D0, size: 3072000, end: 11D9E0D0)
B dbexpbuf: Buffer OTR (addr: 11DA00D0, size: 4194304, end: 121A00D0)
B dbcalbuf: Buffer CALE (addr: 0FE60040, size: 500000, end: 0FEDA160)
M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
S *** init spool environment
Hi Shambo,
thanks for the information. You said
insert into OPS$ORA<SID>.sapuser values (u2018SAPSR3u2019,u2019PASSWORDu2019);
Is it ---> insert into OPS$<SID>ADM.sapuser values (u2018SAPSR3u2019,u2019PASSWORDu2019);
When i am trying to insert i get the following
SQL> insert into OPS$ORA<SID>.sapuser values ('SAPSR3', 'PASSWORD');
insert into OPS$ORA<SID>.sapuser values ('SAPSR3', 'PASSWORD')
*
ERROR at line 1:
ORA-00942: table or view does not exist
After following the note 400241, i still having the same problem, please some one suggest.
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
[dboci.c 4532]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11145]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
[dboci.c 4532]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11145]
B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY2=> sql error 1017 performing CON [dblink#5 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#5 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10534]
M
Hi Krisha,
Actually I dont want to suggest this was thinking that your problem will resolve the by earlier suggested steps.
But unfortunately it didn't work.
I wil suggest to drop your OPS$ user & re-reate it again.
Please refer below steps.
SQL>drop user OPS$<SID>adm cascade;
SQL>create user OPS$<SID>adm identified by <PASSWORD> default tablespace SYSTEM temporary tablespace PSAPTEMP;
SQL> grant connect,resource to OPS$<SID>ADM with admin OPTION;
SQL> create table OPS$<SID>ADM.sapuser (USERID VARCHAR2(255),PASSWD VARCHAR2(255));
SQL>insert into OPS$<SID>ADM.sapuser values(u2018SAPSR3u2019,u2019<PASSWORD>u2019);
SQL>alter user SAPSR3 identified by <PASSWORD>;
Use <PASSWORD> same at all places.
Also refer the OSS Note 50088.
Thanks,
Shambo
> ***LOG Q0I=> NiIBindSocket: bind (10013: WSAEACCES: Permission denied) [nixxi.cpp 3227]
It seems something is blocking binding to a socket. You have a virus scanner running?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
trc file: "dev_disp", trc level: 1, release: "700"
-
sysno 02
sid DOL
systemid 560 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 175
intno 20050900
make: multithreaded, Unicode, optimized
pid 7872
Fri Aug 07 11:04:11 2009
kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
length of sys_adm_ext is 576 bytes
SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (01 7872) [dpxxdisp.c 1261]
shared lib "dw_xml.dll" version 175 successfully loaded
shared lib "dw_xtc.dll" version 175 successfully loaded
shared lib "dw_stl.dll" version 175 successfully loaded
shared lib "dw_gui.dll" version 175 successfully loaded
shared lib "dw_mdm.dll" version 175 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3901
Fri Aug 07 11:04:16 2009
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 5418]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >sdcdolm01_DOL_01 <
DpShMCreate: sizeof(wp_adm) 42600 (1704)
DpShMCreate: sizeof(tm_adm) 4415616 (21968)
DpShMCreate: sizeof(wp_ca_adm) 24064 (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 (1544)
DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 05F30040, size: 5099800)
DpShMCreate: allocated sys_adm at 05F30040
DpShMCreate: allocated wp_adm at 05F32118
DpShMCreate: allocated tm_adm_list at 05F3C780
DpShMCreate: allocated tm_adm at 05F3C7B0
DpShMCreate: allocated wp_ca_adm at 06372830
DpShMCreate: allocated appc_ca_adm at 06378630
DpShMCreate: allocated comm_adm at 0637A570
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 063FB430
DpShMCreate: allocated gw_adm at 063FB470
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 063FB4A0
DpShMCreate: allocated wall_adm at 063FB4A8
MBUF state OFF
DpCommInitTable: init table for 500 entries
rdisp/queue_size_check_value : -> off
ThTaskStatus: rdisp/reset_online_during_debug 0
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.
J2EE server info
start = TRUE
state = STARTED
pid = 1268
argv[0] = E:\usr\sap\DOL\DVEBMGD01\exe\jcontrol.EXE
argv[1] = E:\usr\sap\DOL\DVEBMGD01\exe\jcontrol.EXE
argv[2] = pf=E:\usr\sap\DOL\SYS\profile\DOL_DVEBMGD01_sdcdolm01
argv[3] = -DSAPSTART=1
argv[4] = -DCONNECT_PORT=65000
argv[5] = -DSAPSYSTEM=01
argv[6] = -DSAPSYSTEMNAME=DOL
argv[7] = -DSAPMYNAME=sdcdolm01_DOL_01
argv[8] = -DSAPPROFILE=E:\usr\sap\DOL\SYS\profile\DOL_DVEBMGD01_sdcdolm01
argv[9] = -DFRFC_FALLBACK=ON
argv[10] = -DFRFC_FALLBACK_HOST=localhost
start_lazy = 0
start_control = SAP J2EE startup framework
DpJ2eeStart: j2ee state = STARTED
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1668]
***LOG Q0K=> DpMsAttach, mscon ( sdcdolm01) [dpxxdisp.c 12364]
DpStartStopMsg: send start message (myname is >sdcdolm01_DOL_01 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
CCMS: Checking Downtime Configuration of 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 175
Release check o.K.
DpJ2eeLogin: j2ee state = CONNECTED
Fri Aug 07 11:04:18 2009
***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4424]
ERROR => NiIRead: SiRecv failed for hdl 4 / sock 1376
(SI_ECONN_BROKEN/10054; I4; ST; 127.0.0.1:2483) [nixxi.cpp 4424]
DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)
DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=1268)
ERROR => DpProcKill: kill failed [dpntdisp.c 371]
DpIJ2eeShutdown: j2ee state = SHUTDOWN
Fri Aug 07 11:04:56 2009
my types changed after wp death/restart 0xbf --> 0xbe
my types changed after wp death/restart 0xbe --> 0xbc
my types changed after wp death/restart 0xbc --> 0xb8
my types changed after wp death/restart 0xb8 --> 0xb0
my types changed after wp death/restart 0xb0 --> 0xa0
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=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:06 2009
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Fri Aug 07 10:05:06 2009
========================
max_rq_id 12
wake_evt_udp_now 0
wake events total 8, udp 6 ( 75%), shm 2 ( 25%)
since last update total 8, udp 6 ( 75%), shm 2 ( 25%)
Dump of tm_adm structure: Fri Aug 07 10:05:06 2009
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Fri Aug 07 10:05:06 2009
=============================
Slots: 300, Used: 1, Max: 0
--------
+
id | owner | pid | eyecatcher |
--------
+
0 | DISPATCHER | -1 | WPCAAD000 |
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:11 2009
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >sdcdolm01_DOL_01 < (normal)
DpJ2eeDisableRestart
DpModState: buffer in state MBUF_PREPARED
NiBufSend starting
NiIWrite: hdl 3 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 (3800) (SOFT_KILL)
Stop icman
killing process (5776) (SOFT_KILL)
Terminate gui connections
wait for end of work processes
wait for end of gateway
[DpProcDied] Process lives (PID:3800 HANDLE:1520)
waiting for termination of gateway ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:12 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:3800 HANDLE:1520)
wait for end of icman
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:13 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:14 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:15 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:16 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:17 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:18 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:19 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:20 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:21 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:22 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:5776 HANDLE:1524)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1549
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Fri Aug 07 11:05:23 2009
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:5776 HANDLE:1524)
[DpProcDied] Process died (PID:1268 HANDLE:1504)
DpStartStopMsg: send stop message (myname is >sdcdolm01_DOL_01 <)
NiIMyHostName: hostname = 'sdcdolm01'
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
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 3 recv would block (errno=EAGAIN)
NiIRead: read for hdl 3 timed out (0ms)
DpHalt: no more messages from the message server
DpHalt: send keepalive to synchronize with the message server
NiBufSend starting
NiIWrite: hdl 3 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 3 in set0
SiSelNSet: set events of sock 1400 to: ---
NiBufISelRemove: remove hdl 3 from set0
SiSelNRemove: removed sock 1400 (pos=3)
SiSelNRemove: removed sock 1400
NiSelIRemove: removed hdl 3
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/25
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 3 / sock 1400
NiBufIClose: clear extension for hdl 3
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 7872) [dpxxdisp.c 10908]
Good Bye .....
> ***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4424]
> *** ERROR => NiIRead: SiRecv failed for hdl 4 / sock 1376
> (SI_ECONN_BROKEN/10054; I4; ST; 127.0.0.1:2483) [nixxi.cpp 4424]
> DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)
> DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=1268)
> *** ERROR => DpProcKill: kill failed [dpntdisp.c 371]
> DpIJ2eeShutdown: j2ee state = SHUTDOWN
Please post dev_w0.
Markus
trc file: "dev_w0", trc level: 1, release: "700"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Fri Aug 07 11:04:16 2009
B create_con (con_name=R/3)
B Loading DB library 'E:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' ...
B Library 'E:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' loaded
B Version of 'E:\usr\sap\DOL\DVEBMGD01\exe\dboraslib.dll' is "700.08", patchlevel (0.167)
B New connection 0 created
M sysno 06
M sid DOL
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 175
M intno 20050900
M make: multithreaded, Unicode, optimized
M pid 5968
M
M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 5968) [dpxxdisp.c 1323]
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) 42600 (1704)
M DpShMCreate: sizeof(tm_adm) 4415616 (21968)
M DpShMCreate: sizeof(wp_ca_adm) 24064 (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 (1544)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05F30040, size: 5099800)
M DpShMCreate: allocated sys_adm at 05F30040
M DpShMCreate: allocated wp_adm at 05F32118
M DpShMCreate: allocated tm_adm_list at 05F3C780
M DpShMCreate: allocated tm_adm at 05F3C7B0
M DpShMCreate: allocated wp_ca_adm at 06372830
M DpShMCreate: allocated appc_ca_adm at 06378630
M DpShMCreate: allocated comm_adm at 0637A570
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 063FB430
M DpShMCreate: allocated gw_adm at 063FB470
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 063FB4A0
M DpShMCreate: allocated wall_adm at 063FB4A8
M rdisp/queue_size_check_value : -> off
M ThTaskStatus: rdisp/reset_online_during_debug 0
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 Aug 07 11:04:17 2009
M ThInit: running on host edcDOLm01
M calling db_connect ...
C Prepending E:\usr\sap\DOL\DVEBMGD01\exe to Path.
C Oracle Client Version: '10.2.0.2.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Attaching to DB Server DOL (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44)
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
[dboci.c 4532]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11145]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@DOL on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 05CD9FE8 05CDF684 05CDEF0C
C Starting user session (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44,usrhp=05D066F8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=28000
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=05CDEE58,srvhp=05CF0A44)
C *** ERROR => CONNECT failed with sql error '28000'
[dbsloci.c 11145]
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#5 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-28000: the account is locked [dblink#5 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10534]
M
M Info for wp 0
M
M pid = 5968
M severity = 0
M status = 0
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 mode_cleaned_counter = 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 attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server edcDOLm01_DOL_01 on host edcDOLm01 (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Fri Aug 07 11:04:17 2009
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10754
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 723]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
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 5968) [dpnttool.c 333]
*I have followed the SAP Note 951167, but still the same issue*
Hi Friends, I have upgraded kernel from patch 133 to 175 but the status of the shows disp +work stopped , i have tried all the possible ways, checked the notes and googled but still not successfull.
I have pasted the log file as above.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.