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
How can you view locked transactions?
What is a developer key? and how to generate a developer key?
Transport request types and its syntax?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
What are the errors you got while applying support pack?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
What is oracle Architecture?
What will you do if u got Update failure?
What is JVM switch. Why JVM switch is required ?
Explain the developer trace?
Mention what is the purpose of table usr02?
Explain what is business kpis ?
How client refresh is different than client copy?
Explain logon groups?
How do you check the installed software components and product versions on sap system?