Hi,
I have a question ,suppose all users are unable to login
into (sap system including basis administrator)then what
are the ways to check the system and how to unlock it.
Answer Posted / tulasi
Hi Try this..
1. Login to the Operating System.
2. Login to the database using sqlplus / as sysdba;
3. Execute the Query Delete from <schema_name>.usr02 where bname = 'SAP*' and client = '000';
This will reset the password of sap* to pass
Once the password for SAP* is reset, the other users can be unlocked.
If the procedure doesn't work, then,
The parameter login/no_automatic_user_sapstar would be set to 1.
You will have to include this line login/no_automatic_user_sapstar=0 in your default and the instance profile.
Restart your system and then retry.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
How can you find a list of objects that have been repaired in the system?
What is “data sets” in sap?
describe how to setup a printer in SAP or where they would look to research why a user/users can not print?
can any send unix admin doc? if u have please send it to chanduk29@gmail.com
Explain segment?
What is the use of commit value while deleting jobs in sap system?
what are the current support stack levels at market place?
what are the pre-requisites to apply support patch?
how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?
What are common transport errors and their codes?
how can i change access to a user who is having access for SPRO display only to change access in sPro
What is the difference between st06 and st03?
In what ways you would know whether a system is unicode or non-unicode?
What is business kpis ?