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 an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?

645


How can you find a list of objects that have been repaired in the system?

748


What is “data sets” in sap?

690


describe how to setup a printer in SAP or where they would look to research why a user/users can not print?

652


can any send unix admin doc? if u have please send it to chanduk29@gmail.com

1502






Explain segment?

702


What is the use of commit value while deleting jobs in sap system?

663


what are the current support stack levels at market place?

1815


what are the pre-requisites to apply support patch?

648


how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?

2019


What are common transport errors and their codes?

1469


how can i change access to a user who is having access for SPRO display only to change access in sPro

1897


What is the difference between st06 and st03?

1294


In what ways you would know whether a system is unicode or non-unicode?

594


What is business kpis ?

581