Note: Whenever the SAPR3/SAPSR3 user gets locked, the following ABAP dumps occurs in SAP System.

/wp-content/uploads/2013/08/1_271229.jpg

————————————————————————————————————————————————————————————————————

    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;

/wp-content/uploads/2013/08/2_271230.jpg

    Here the status of the user SAPSR3 is “Locked“.

    To Unlock the user, exeute the query   alter user SAPSR3 account unlock;

/wp-content/uploads/2013/08/3_271232.jpg

/wp-content/uploads/2013/08/6_271234.jpg

    The User altered.

    Now execute the query   select username, account_status from dba_users;

/wp-content/uploads/2013/08/4_271233.jpg

    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.

/wp-content/uploads/2013/08/5_271237.jpg

     Sqlnet.ora file is available in the location ORACLE _HOME \NETWORK\ADMIN.

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

To report this post you need to login first.

7 Comments

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

  1. Suseelan Hari

    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!

    Regards,

    Hari Suseelan

    (0) 

Leave a Reply