if someone lock standard user such as sap* and ddic in
client 800? and client 000 is working fine so how can i log
in client 800?
is there any other standard user with standard password?

Answer Posted / sanjay

check the profile parameter
login/no_automatic_user_sapstar= o or 1 if this is 1 make
the vaue 0
Restart instance

If this not works then try for

SQLPLUS "/AS SYSDBA"
SQL> delete sapsr3.usr02 where mandt='800'and bname='SAP*';

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the pre requisite for the SAP Installation?

1802


Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?

2920


Which transaction do you use to check buffer statistics ?

926


what is your project architecture?

1835


Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?

808


How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3398


A user moved the transport request from dev to qua. How would you trace him?

996


What is your UNIX experience and the types of UNIX systems you have worked on.

1800


what is garbage collector. is there any way to set the time to gc?

3912


How do you check the users logs in your system and how many sessions each user is generating?

844


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?

990


How to uncar car/sar files in a single shot?

994


If client copy is stopped in middle, what happens if you want to start it again?

1823


what is the common storage file for oracle ?

1858


How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?

2948