cancel
Showing results for 
Search instead for 
Did you mean: 

need info......Urgent

Former Member
0 Kudos

Hi everyone.

Could any one tell me show to change PASSCODE in USR02 table.

what is the SQL command.

Thank you

Kiran Kumar

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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>

Former Member
0 Kudos

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).

Former Member
0 Kudos

hi muniraj

what is the difference betwenn BCODE and PASSCODE..

I guess BCODE is the actual password of the user..and wat does 5 th step mean

/$CUA..

anyhow i am going to try the step you mentioned.

Thank you

Kiran kumar..

former_member204746
Active Contributor
0 Kudos

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.

former_member204746
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

I wonder you want to change the password of the users at dblevel instead of using the correct transaction to do it (SU01). Probably it would be much easier!

Former Member
0 Kudos

Hello Kiran,

You can view my business card

http://www.sdn.sap.com:80/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=...

Keep <b>posting queries</b> & Keep <b>awarding points</b>,

Your questions will always be answered on SDN.

Regards,

Ammey Kesarkar

Former Member
0 Kudos

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.

Former Member
0 Kudos

DEAR AMMEY,

THE ABOVE SQL WONT EXECUTE TO CHANGE THE USER PASSWORD AS THE BCODE FIELD IN USRO2 TABLE IS OF RAW TYPE.

CHECK IT.

REGARDS

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Ammmey,

Seems as if i hv hurt u.

I didnt intend the same regarding the caps and was unaware that writing in caps means shouting.

Sorry if i hv hurt u by any means and thnx for the NB.

Will take care in future.

Regards

Former Member
0 Kudos

Hello Kiran,

Pl check whether Oracle is starting up or not.

Also check if the listner service is working properly or not.

regards