How to unlock and reset SAP* from ORACLE

( You can Skip Step 2,3 and 4, for information purpose only)

Step 1: Login with the <SID>adm user and connect to sqlplus.

Step 2: Select owner from DBA_TABLES where TABLE_NAME=’T000’;

Step 3: List the SAP* table. Check for UFLAG column, if value is ‘0’, the user is fine in corresponding client. If the value is other than ‘0’, it means the user is lock in relevant client that needs to be unlocked.

Step 4: To unlock:

            update SAPSR3.USR02 set UFLAG=0 where BNAME=’SAP’ and MANDT=000;

Step 5: Reset SAP* password by deleting the relevant row:

            Delete from SAPSR3.USR02 where BNAME=’SAP*’ and MANDT=000;

Step 6: change the relevant parameter either in DEFAULT.PFL file or in RZ10 T-code (restart the system)

            login/no_automatic_user_sapstar = 0

USR02 is a standard SAP Table to store Logon Data (e.g. user name, password in encrypted form, validity of user, last logon date and time, etc.) and is available within R/3 SAP systems.

UFLAG is a standard field within SAP Table USR02 that stores User Lock Status information.

BNAME is a field of username 

MANDT is for relevant client