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.

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

0 comments:

Subscribe to: Post Comments (Atom)
Copyright © 2013 VENKAT SAP BASIS