1. Remote Desktop (Windows) / Telnet (Unix/Linux) to OS level and connect to the sql using the command prompt.
C:\Documents and Settings\devadm>sqlplus "/as sysdba"
2. View the SAP* table.
SQL> select UFLAG, BNAME, MANDT from SAPSR3.USR02 where BNAME='SAP*';
3. Unlock the SAP* password.
SQL> update SAPSR3.USR02 set UFLAG=0 where BNAME='SAP*' and MANDT=000;
4. Reset the SAP* password
SQL> delete from SAPSR3.USR02 where BNAME='SAP*' and MANDT=000;
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
Note:
• This example shows for SAP* in client 000 in Oracle environment.
• Default password for sap* is pass / 06071992.
• Execute transaction code /$tab to reset buffer
Please let me know how to find and reset parameter login/no_automatic_user_sapstar since your system is locked.
Hi Javed,
You can set the parameter via OS level.
hey while resetting the password what will be the login id and iam not able to receive password on my mail, because i had changed mail id now what can i do
Trying to unlock my computer