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
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?
What are the different modules of SAP?
Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?
How database extend?
how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?
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?
What do you understand by sap client administration?
What is heterogenous system copy and homogenous system copy ?
At o.s level where to check for system logs of sap application?
What is the difference between asynchronous and synchronous transport?
How to find users used transaction codes which are not authorized for?
What is a support package? What is its purpose?
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 purpose user group in SU01?