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
Why do you use DDIC user not SAP* for Support Packs and SPam?
Is there any report or table in which user log off time is stored in sap?
Where is the Deletion Flag or Indicator used in archiving process?
If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?
How can a user be able to access only for Customizing requests even if assigned se01 and se10?.
What is the information derived from OSS notes?
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?
If a background job runs more than the time it should be completed normally then what actions will u take?
What is the difference between – support package, kernel and sap note?
What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?
What is the folder it will ask to install oracle?
What is process for applying patches?
When we install sap r/3 enterprise 4.7, there are several error messages in the sapview.log. What does this mean?
Where XML file is generated in solution manager?
Is sap a database ?