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
At o.s level where to check for system logs of sap application?
What is development class? Why to create the development class?
What is the information derived from OSS notes?
What is a support package?
what is role of sap administrator in pi & ep?
i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value
What is the need of having Development system?
How can you define login policy for users in sap system?
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
what are the current support stack levels at market place?
Is it possible to install sap patches when other users are online?
If brtools is not working how you will add datafile?
Mention what is the difference between central instance & application server?
list some common errors faced with jspm while updating java stcks.and solutions.
Explain kernel upgrade?