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,
Popular post
-
Released On 21.10.2014 Component BC-UPG-RDM README: Upgrade Supplements Symptom Errors in the update process; preparations for the u...
-
OS LEVEL: #cd /sapmnt<SID>/exe/igs* #cat igsmanifest.mf OUTPUT: igs release: 720 igs patch number: 4
-
Check that the SCS instance (the SAP Central Services instance containing the Message Server and the Enqueue Server for the J2EE Engine) o...
-
As a part of SAP Basis life, we need to import many transports at a time, which is very crucial for the project at the same time its very b...
-
What to check when you get the below R3trans ERROR? Check #1 Verify if SAPSR3 user is locked in database level Check #2 Verify if yo...
-
With this parameter you can configure Modifications of HTTP Requests in the Web Dispatcher or ICM. You can define rules by which the Web Dis...
-
Perform the following steps on SAP Solution Manager System T-Code to Generate Stack.xml SM_WORKCENTER RELATED: SAP SOLUTION MAN... -
For both of them, SAP dynamically creates a function module that must be called from an ABAP program to generate the form In Smart Forms,...
-
Error: -bash: SAPCAR: command not found Symptom: When you try to extract a .SAR file using SAPCAR you get this error. Reason: You are ...
-
When you see this kind of issue in SAP world it means the users work process has used up all allocated memory and entered into HEAP Area whi...
Copyright © 2011. SAP BASIS ANSWERS | SAP BASIS ADMIN BLOG - All Rights Reserved
Post a Comment