Unlock & Reset SAP* and other User Password in Oracle

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