unlock and reset SAP* Password in Oracle

Follow the below steps

1. Use windows Command prompt /Unix and Linux use Terminal to connect SQL. 

C:\Documents and Settings\<SID>adm>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 check in RZ11  You need to restart the SAP Application  once the parameter is change.

login/no_automatic_user_sapstar