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 luw (logical unit of work)?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
What will you observe in st06?
At os level how you can change the number of work process? How you can analyze the status of work process at os level?
What is ocm and how to apply ocm patches?
Why can't we do it thru some other client?
what is role of sap administrator in pi & ep?
What are the daily activates?
Which transaction do you use to check buffer statistics ?
What is redolog file? Path?
Why do you use DDIC user not SAP* for Support Packs and SPam?
What is development class? Why to create the development class?
How you connect ECC to EP?
I am installing a sap j2ee engine at crm. When it reaches phase 22 it halts for more than 10 minutes and gives up starting the system. What should I do?
how can i change access to a user who is having access for SPRO display only to change access in sPro