How to Unlock SAPSR3/SAPR3 user.

[Former Member]

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.

==================================================================