Unlock & Reset SAP* Password in Oracle

Share this article :

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.



• 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

Related posts

Create SAP RFC User
User SAP* is active. No other users can log on
Unlock & Reset SAP* Password in DB2
SU01: Old SAPoffice data found for this user name
  • Javed

    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.

© 2017 ITsiti. All Rights Reserved
Powered by KEEM