on 02-27-2012 3:48 PM
Dear Experts,
I was installed SAP in my system,But When i start my server WP tables status is showing ENDED and also Dispatcher is getting stopped but Message server is running .i tried by changing the ip address and all the ways which i can do.Being not a basis guy, i couldnt find the solution. Please help me out.
The following is the developer trace
*** ERROR => W0 (pid 2460) died [dpxxdisp.c 11651]
*** ERROR => W1 (pid 2468) died [dpxxdisp.c 11651]
*** ERROR => W2 (pid 2476) died [dpxxdisp.c 11651]
. . .
*** ERROR => W11 (pid 2552) died [dpxxdisp.c 11651]
*** ERROR => W12 (pid 2592) died [dpxxdisp.c 11651]
my types changed after wp death/restart 0xbf --> 0x80
*** DP_FATAL_ERROR => DpEnvCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
with regards
Naresh
Hi Naresh,
Your dispatcher is shutting down because all the work process are dying... Can you attach your dev_w0 to this thread or paste it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi the following is the dev_w0 trace.
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Mon Feb 27 21:32:39 2012
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\ECC\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\ECC\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\ECC\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.73)
B New connection 0 created
M sysno 00
M sid ECC
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 3512
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 3512) [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: 05D70040, size: 4653368)
M DpShMCreate: allocated sys_adm at 05D70040
M DpShMCreate: allocated wp_adm at 05D71E40
M DpShMCreate: allocated tm_adm_list at 05D765C0
M DpShMCreate: allocated tm_adm at 05D765F0
M DpShMCreate: allocated wp_ca_adm at 06145890
M DpShMCreate: allocated appc_ca_adm at 0614B650
M DpShMCreate: allocated comm_adm at 0614D590
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 061CE450
M DpShMCreate: allocated gw_adm at 061CE490
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 061CE4C0
M DpShMCreate: allocated wall_adm at 061CE4C8
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 Mon Feb 27 21:32:40 2012
M ThInit: running on host gcecc62
M
M Mon Feb 27 21:32:41 2012
M calling db_connect ...
C Prepending D:\usr\sap\ECC\DVEBMGS00\exe to Path.
C
C Mon Feb 27 21:32:42 2012
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 /@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 063A7AF8 063AD094 063AC91C
C Attaching to DB Server ECC (con_hdl=0,svchp=063AC868,svrhp=063BE134)
C Starting user session (con_hdl=0,svchp=063AC868,srvhp=063BE134,usrhp=063D2E88)
C Now '/@ECC' is connected (con_hdl 0, nls_hdl 0).
C Got SAPSR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=063AC868,usrhp=063D2E88)
C Now I'm disconnected from ORACLE
C Connecting as SAPSR3/<pwd>@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 063A7AF8 063AD094 063AC91C
C Starting user session (con_hdl=0,svchp=063AC868,srvhp=063BE134,usrhp=063D2E88)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000
[dboci.c 4391]
C Detaching from DB Server (con_hdl=0,svchp=063AC868,srvhp=063BE134)
C *** ERROR => CONNECT failed with sql error '28000'
[dbsloci.c 10933]
B ***LOG BY2=> sql error 28000 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY2=> sql error 28000 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-28000: the account is locked [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1411]
M in_ThErrHandle: 1
M
M Mon Feb 27 21:32:43 2012
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 gcecc62_ECC_00 on host gcecc62 (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Mon Feb 27 21:32:43 2012
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 3512) [dpnttool.c 327]
with regards
Naresh
Hi Venky,
Yes you are right .SAPR3 is Locked.i executed the query please find the output here
SQL> conn /as sysdba
Connected.
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
OPS$GCECC62\ECCADM OPEN
OPS$GCECC62\SAPSERVICEECC OPEN
SYS OPEN
SYSTEM OPEN
SAPSR3 LOCKED(TIMED)
OUTLN LOCKED
TSMSYS EXPIRED & LOCKED
DIP EXPIRED & LOCKED
DBSNMP EXPIRED & LOCKED
Please tell me how to UNLOCK the account.
Hi Naresh,
Pls unlock with alter user sapsr3 account unlock;
And set the password to never expiry and invalid login attempts to unlimited.
select profile from DBA_USERS where username = <username>
Remember the profile name
alter profile <profile_name> limit password_life_time UNLIMITED;
alter <profile_name> default limit failed_login_attempts unlimited;
Br,
Venky
Hi Naresh,
Please mention the environment details like OS version, SAP release etc..
Just a check
Goto your profile directory and run sappfpar check pf=<instance_profile>
And correct the errors.
Br,
Venky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
I am facing problem in dual stack system (Java+Abap) on windows 2008. Its showing SAPSR3 and SAPSR3DB password expired and same has bee change password but when I start dispatcher then automatic sapsr3 locked(Timed). Then again unlock sapsr3 and start dispatcher and again stop and locked sapsr3. Now I run following command and same problem dispatcher stop and but now sapsr3/sapsr3db not locking.
drop user "OPS$UBSBWD\sidADM" cascade;
drop public synonym SAPUSER;
create user "OPS$UBSBWD\SIDADM" default tablespace <<usually psapsr3usr>> temporary tablespace <<usually psaptemp>> identified externally;
grant connect, resource to "OPS$UBSBWD\SIDADM";
create table "OPS$UBSBWD\SIDADM".SAPUSER ( USERID VARCHAR2(256), PASSWD VARCHAR2 (256));
insert into "OPS$UBSBWD\SIDADM".SAPUSER values ('SAPBID', 'sap');
alter user SAPBID identified by sap;
create public synonym sapuser for OPS$UBSBWD\SIDADM.SAPUSER;
grant select, update on sapuser to "OPS$UBSBWD\SIDADM";
Please help............
Thanks,
Jitendra Kumar
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.