Skip to Content

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.


To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Former Member

    Hi Dino,

    Good Day!

    Thank you so much for explaining clearing about unlocking SAPSR3/SAPR3 user.

    Keep Posting Valuable Blogs like this.

    All the best. Have a nice day!


    Hari Suseelan


Leave a Reply