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
EmoticonEmoticon
Note: only a member of this blog may post a comment.