on 01-31-2007 9:22 PM
Hi everyone.
Could any one tell me show to change PASSCODE in USR02 table.
what is the SQL command.
Thank you
Kiran Kumar
hi ammey
well ammey that was quiet helpful..that actually works..(thank you)
but tell me tell u what i am trying to do..i am trying to change the password
of the SAP* and other users password from the DB level..
not to the target client as you mentioned..
like resetting the password from the DB level..
waiting for your response..
Thank you.
Kiran Kumar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kiran,
Changing / resetting the passwords of users from DB level as you have mentioned will NOT work! (except SAP*, where you delete it from DB and it picks up the PASS password from the kernel)
It's not a good practice to change/reset passwords at DB level. Avoid doing that.
Regards,
Ammey Kesarkar
<i>'Please award points for useful info'</i>
This works:-
For example:-
1. You should know password for at least one user in any client.
2. Verify the same password by logging into SAP once.
I am assuming that you know the password for DDIC in client 100 and you don't know the password for user SAPUSER in client 000. Now we will reset password of SAPUSER in client 000 to the same as DDIC of client 100.
3. Go to OS level as <sid>adm user and use sqlplus "/as sysdba".
4. Fire this command:-
update sap<SID>.usr02 set passcode =
(select passcode
from sap<SID>.usr02
where BNAME='DDIC'
and MANDT=100)
where BNAME='SAPUSER'
and MANDT=000;
5. Login to SAP with your know user (in this case as DDIC in client 100) and in command field type /$CUA and press enter (Dangerous, be careful)
6. Now login to 000 as SAPUSER with the password (you know now).
BCODE is a field name from USR02, it contains a user password and is encrypted. so, manipulating through a DB interface will not work, unless you have the same user ID within the same installation number on another system.
the only way to create a password is to use an ABAP function call. Contact your ABAPPER to obtain it.
PASSCODE is not use in system working on WAS 6.40 and below, so, no need to touch this. BCODE is the good old hash-encrypted password.
You also posted a dev trace file. I do not see the relation between changing password and the fact that your SAP system is down. Please explain why you see a relation between those 2.
unless you are trying to change an DB user password, not a SAP password.
anyways, for SAP system being down, you should open a new topic and also supply contents from dev_w0
hi everyone..
i followed the steps mentioned above..i am still not able to change the password
from the database level.
could anyone help with this..is there any other way to do this..
Thank you.
Kiran Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kiran,
Step 1:
SQLPLUS '/ AS SYSDBA'
Step 2:
Export the Entire USR02 table using R3trans (Backup: just incase you need to revert it back to original)
Step 3:
SQL> SELECT BNAME, BCODE, MANDT FROM SAP<SID>.USR02 WHERE BNAME=<username> AND MANDT=<client>;
Here
MANDT=<client number>
BNAME=<username>
(MANDT & BNAME Who's password you already know.)
The above query will fecth you a single record, Note down the BCODE & BNAME value string.
Step4:
SQL> UPDATE SAP<SID>.USR02 SET BCODE='<STRING you noted above>' WHERE BNAME='<username you noted above>' AND MANDT=<Target Client>;
Step 5:
SQL> COMMIT;
Please note:
The username MUST be SAME in both the queries.
The password in the target client will be same as source client.
Regards,
Ammey Kesarkar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi ammey
First of all i would like to thank you for replying.
I am new to oracle , i do not have in depth knowledge of oracle.
sorry to bother you again.
can you tell me what is the command to export and import ( or structure ) a table
in oracle.
i am going to try the steps which you have sent.
Thank you.
Kiran devarla.
Goto /tmp
Create a file 'export_cntrl_000' with following contents:
EXPORT
FILE='</tmp/exportdata000'>
CLIENT=<client_no>
SELECT * FROM <table_name>
Create individual export files for all clients -> export_cntrl_xxx
Execute the following command
R3trans -w export_log export_cntrl
Check the export_log for details of export, RC must be 0 or 4.
Check if 'exportdata000' file is created
Go through the following link for more details
http://help.sap.com/saphelp_nw04s/helpdata/en/3d/ad5ce54ebc11d182bf0000e829fbfe/frameset.htm
Regards,
Ammey Kesarkar
hi ammey
how r u..thank for replying again..
i have some issues while changing the password of the user at db level ( usr02 )
any how i am trying.
i am just curious to know about u..hope u don't mind.
where r u located ammey..
by-the-way i am working a junior basis consultant.
i am eager to learn few thing about DB..hope u will continue supporting me..
thank you.
kiran
Hello Kiran,
You can view my business card
Keep <b>posting queries</b> & Keep <b>awarding points</b>,
Your questions will always be answered on SDN.
Regards,
Ammey Kesarkar
hello ammey..
I have a stand-alone PC on which i have installed SAP 4.7..whenever i start SAP
dispatcher comes up and wp status shows ended and dispatch will be closed.
i have already followed few troubleshooting steps, they did not help fixing my issues.
I am sendign you the trace file generated by the dispatch ( dev_disp)..
may be u can help me on this
************************************
-
trc file: "dev_disp", trc level: 1, release: "640"
-
Thu Feb 08 20:40:34 2007
kernel runs with dp version 128000(ext=102000) (@(#) DPLIB-INT-VERSION-128000-UC)
length of sys_adm_ext is 524 bytes
systemid 560 (PC with Windows NT)
relno 6400
patchlevel 0
patchno 43
intno 20020600
make: multithreaded, Unicode
pid 1048
***LOG Q00=> DpSapEnvInit, DPStart (01 1048) [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 Feb 08 20:40:51 2007
WARNING => DpNetCheck: NiHostToAddr(www.doesnotexist0151.qqq.nxst) took 17 seconds
Thu Feb 08 20:41:12 2007
WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 21 seconds
***LOG GZZ=> 2 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) 21056 (1316)
DpShMCreate: sizeof(tm_adm) 2780232 (13832)
DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
DpShMCreate: sizeof(comm_adm) 290000 (580)
DpShMCreate: sizeof(vmc_adm) 0 (372)
DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
DpShMCreate: SHM_DP_ADM_KEY (addr: 06A70040, size: 3203216)
DpShMCreate: allocated sys_adm at 06A70040
DpShMCreate: allocated wp_adm at 06A71B58
DpShMCreate: allocated tm_adm_list at 06A76D98
DpShMCreate: allocated tm_adm at 06A76DC0
DpShMCreate: allocated wp_ca_adm at 06D1DA08
DpShMCreate: allocated appc_ca_adm at 06D237C8
DpShMCreate: allocated comm_adm_list at 06D25708
DpShMCreate: allocated comm_adm at 06D25720
DpShMCreate: allocated vmc_adm_list at 06D6C3F0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 06D6C418
DpShMCreate: allocated wall_adm at 06D6C420
MBUF state OFF
Thu Feb 08 20:41:13 2007
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> 920 blocks reserved for free list.
ES initialized.
Thu Feb 08 20:41:15 2007
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 2.6.1 2.6 4.0) [dpxxdisp.c 1462]
***LOG Q0K=> DpMsAttach, mscon ( development) [dpxxdisp.c 9736]
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
Thu Feb 08 20:41:16 2007
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 Feb 08 20:41:55 2007
ERROR => W0 (pid 880) died [dpxxdisp.c 12187]
ERROR => W1 (pid 1808) died [dpxxdisp.c 12187]
ERROR => W2 (pid 2124) died [dpxxdisp.c 12187]
ERROR => W3 (pid 2140) died [dpxxdisp.c 12187]
ERROR => W4 (pid 2152) died [dpxxdisp.c 12187]
ERROR => W5 (pid 2132) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbf --> 0xbe
ERROR => W6 (pid 2172) died [dpxxdisp.c 12187]
ERROR => W7 (pid 2164) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbe --> 0xbc
ERROR => W8 (pid 2176) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xbc --> 0xb8
ERROR => W9 (pid 2212) died [dpxxdisp.c 12187]
ERROR => W10 (pid 2224) died [dpxxdisp.c 12187]
ERROR => W11 (pid 2184) died [dpxxdisp.c 12187]
ERROR => W12 (pid 2160) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xb8 --> 0xb0
ERROR => W13 (pid 2196) died [dpxxdisp.c 12187]
ERROR => W14 (pid 2272) died [dpxxdisp.c 12187]
my types changed after wp death/restart 0xb0 --> 0xa0
ERROR => W15 (pid 2284) 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-880 (SIGUSR2)
ERROR => DpWpKill(880, SIGUSR2) failed [dpxxtool.c 2468]
killing W1-1808 (SIGUSR2)
ERROR => DpWpKill(1808, SIGUSR2) failed [dpxxtool.c 2468]
killing W2-2124 (SIGUSR2)
ERROR => DpWpKill(2124, SIGUSR2) failed [dpxxtool.c 2468]
killing W3-2140 (SIGUSR2)
ERROR => DpWpKill(2140, SIGUSR2) failed [dpxxtool.c 2468]
killing W4-2152 (SIGUSR2)
ERROR => DpWpKill(2152, SIGUSR2) failed [dpxxtool.c 2468]
killing W5-2132 (SIGUSR2)
ERROR => DpWpKill(2132, SIGUSR2) failed [dpxxtool.c 2468]
killing W6-2172 (SIGUSR2)
ERROR => DpWpKill(2172, SIGUSR2) failed [dpxxtool.c 2468]
killing W7-2164 (SIGUSR2)
ERROR => DpWpKill(2164, SIGUSR2) failed [dpxxtool.c 2468]
killing W8-2176 (SIGUSR2)
ERROR => DpWpKill(2176, SIGUSR2) failed [dpxxtool.c 2468]
killing W9-2212 (SIGUSR2)
ERROR => DpWpKill(2212, SIGUSR2) failed [dpxxtool.c 2468]
killing W10-2224 (SIGUSR2)
ERROR => DpWpKill(2224, SIGUSR2) failed [dpxxtool.c 2468]
killing W11-2184 (SIGUSR2)
ERROR => DpWpKill(2184, SIGUSR2) failed [dpxxtool.c 2468]
killing W12-2160 (SIGUSR2)
ERROR => DpWpKill(2160, SIGUSR2) failed [dpxxtool.c 2468]
killing W13-2196 (SIGUSR2)
ERROR => DpWpKill(2196, SIGUSR2) failed [dpxxtool.c 2468]
killing W14-2272 (SIGUSR2)
ERROR => DpWpKill(2272, SIGUSR2) failed [dpxxtool.c 2468]
killing W15-2284 (SIGUSR2)
ERROR => DpWpKill(2284, SIGUSR2) failed [dpxxtool.c 2468]
NiWait: sleep (10000 msecs) ...
NiISelect: timeout 10000 ms
NiISelect: maximum fd=405
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Feb 08 20:42:05 2007
NiISelect: TIMEOUT occured (10000 ms)
dump system status
Workprocess Table (long) Thu Feb 08 15:12:05 2007
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA 880 Ended no 1 0 0
1 DIA 1808 Ended no 1 0 0
2 DIA 2124 Ended no 1 0 0
3 DIA 2140 Ended no 1 0 0
4 DIA 2152 Ended no 1 0 0
5 DIA 2132 Ended no 1 0 0
6 UPD 2172 Ended no 1 0 0
7 UPD 2164 Ended no 1 0 0
8 ENQ 2176 Ended no 1 0 0
9 BTC 2212 Ended no 1 0 0
10 BTC 2224 Ended no 1 0 0
11 BTC 2184 Ended no 1 0 0
12 BTC 2160 Ended no 1 0 0
13 SPO 2196 Ended no 1 0 0
14 SPO 2272 Ended no 1 0 0
15 UP2 2284 Ended no 1 0 0
Dispatcher Queue Statistics Thu Feb 08 15:12:05 2007
===========================
--------
+
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 8 ( 88%), shm 1 ( 11%)
since last update total 9, udp 8 ( 88%), shm 1 ( 11%)
Dump of tm_adm structure: Thu Feb 08 15:12:05 2007
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Thu Feb 08 15:12:05 2007
=============================
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=405
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Feb 08 20:42:10 2007
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 (1232) (SOFT_KILL)
Stop icman
killing process (2096) (SOFT_KILL)
Terminate gui connections
[DpProcDied] Process lives (PID:1232 HANDLE:388)
waiting for termination of gateway
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=405
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Feb 08 20:42:11 2007
NiISelect: TIMEOUT occured (1000 ms)
[DpProcDied] Process died (PID:1232 HANDLE:388)
[DpProcDied] Process died (PID:2096 HANDLE:380)
DpHalt: cancel all lcom connections
MPI CancelAll 2 -> 0
MPI DeleteAll 2 -> 0
NiIMyHostName: hostname = 'development'
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/16
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 244
MsIDetach: detach MS-system
EsCleanup ....
***LOG Q05=> DpHalt, DPStop ( 1048) [dpxxdisp.c 8495]
Good Bye .....
********************************************************
Thank you
kiran deverla.
Hello Manas,
I am aware that the BDcode feild type is of RAW type.
The trick is say:
Client = 000, Username = Myuser, Password = <RAW text>;
the above information you know.
You can assigne the <b>same</b> password to <b>same</b> username, in diffrent clinet
Target Client = 500, Username = Myuser
Now just use the <RAW test> password of client 000 for client 500.
Then just use user Myuser with the password of client 000 to login into client 500.
I have done this several times it works.
Regards,
Ammey Kesarkar
NB: Manas, writing in CAPS = Shouting!
Please use lower case
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
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.