How to Unlock SAPSR3/SAPR3 user.
Note: Whenever the SAPR3/SAPSR3 user gets locked, the following ABAP dumps occurs in SAP System.
Steps to Unlock SAPSR3/SAPR3 user in database level (Oracle).
Login to database using sqlplus / as sysdba
Execute the query select username, account_status from dba_users;
Here the status of the user SAPSR3 is “Locked“.
To Unlock the user, exeute the query alter user SAPSR3 account unlock;
The User altered.
Now execute the query select username, account_status from dba_users;
The Account_Status of user SAPSR3 has been altered (open).
Hence the user SAPSR3 has been unlocked.
Note: Make sure that while login into Oracle DB, the SQLNET.AUTHENTICATION_SERVICES = (NTS) is not quoted (#) in sqlnet.ora file.
If it is quoted (#) you are not authorized to log in as sysdba.
Sqlnet.ora file is available in the location ORACLE _HOME \NETWORK\ADMIN.