Steps to unlock SAPSR3 user at Oracle database level

Steps to unlock SAPSR3/SAPR3 user at database level

Login to database using sqlplus / as sysdba
Execute the below sql query  
SQL>select username, account_status from dba_users;

If you see  user SAPSR3 is "Locked".

Unlock the user
Exeute below sql query  
alter user SAPSR3 account unlock;


tags: sapsr3 user lock , sapsr3 usr open, 
Share this article :

Post a Comment

 
Copyright © 2011. SAP BASIS ANSWERS | SAP BASIS ADMIN BLOG - All Rights Reserved
T C P M
Proudly powered by Blogger