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


Please Help Members By Posting Answers For Below Questions

What is transport domain?

1589


How to update SAP

1569


How to see when were the optimizer stats last time run?

853


How to set predecessor relationship between two transport requests?

2397


What is the different architecture between SAP 4.7EE & ECC5.0

2773


What is SSO? How to configure SSO?

1468


In my portal ABAP + JAVA I get a bootstrap error message how do I resolve this erroe

4644


What is a support package? What is its purpose?

817


Have u applied patches what is the transaction code?

811


What is upgrade process? And how u will do that?

1456


I have solman 7.1 Stack3. I want to upgrade to stack13. My question is can I directly download stack13 files from marketplace, if yes, will those files includes xml file ? (MOPZ is not configured in my system).

1575


What is the purpose of tdevc ?

1157


If a background job runs more than the time it should be completed normally then what actions will u take?

1570


Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

978


Mention what is the difference between sdm and jspm?

853