Unlock & Reset SAP User Password in Oracle
Step 1:
Take Remote Desktop (Windows) / Telnet (Unix/Linux) to OS level and connect to the sql using the command prompt.
C:\Documents and Settings\<SID>adm>sqlplus"/as sysdba"
Step 2:
View the User table.
SQL> select UFLAG, BNAME, MANDT from SAPSR3.USR02 where BNAME='USERNAME';
Step 3:
Unlock the User(failed attempt lock).
SQL> update SAPSR3.USR02 set UFLAG=0 where BNAME='USERNAME' and MANDT=CLIENT No;
Now User has been unlocked!!!
Reset SAP* user Password
Step 1:
Take Remote Desktop (Windows) / Telnet (Unix/Linux) to OS level and connect to the sql using the command prompt.
C:\Documents and Settings\<SID>adm>sqlplus"/as sysdba"
Step 2:
View the User table.
SQL> select UFLAG, BNAME, MANDT from SAPSR3.USR02 where BNAME='SAP*';
Step 3:
Unlock the User(failed attempt lock).
SQL> update SAPSR3.USR02 set UFLAG=0 where BNAME='SAP*' and MANDT=000;
Reset the SAP* password
Step 4:
SQL>delete from SAPSR3.USR02 where BNAME='SAP*' and MANDT=000;
Step 5:
Set the parameter login/no_automatic_user_sapstar is set to 0. You also can check in RZ11. You need to reboot the SAP once the parameter is change.
login/no_automatic_user_sapstar=0
EmoticonEmoticon
Note: only a member of this blog may post a comment.