Skip to Content

How to Unlock SAPSR3/SAPR3 user.

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.

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

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