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

Do you know about oss what do you do with oss?

686


What are common background jobs that will run in your system?

2118


What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?

1498


Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com

1004


Explain what is sap ides?

647






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).

1374


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

1484


What is an interface in SAP?

800


How many types of work processes are there in sap ?

634


TMS Configuration?

1445


What is the use of patches in sap system? Could you name few common patch types?

696


How can you define login policy for users in sap system?

670


When should we use Transactional RFC?

647


What are patches you applied?

794


How do you generate (recover) old system logs in a newly created SLOG00?

1688