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

Why do you use DDIC user not SAP* for Support Packs and SPam?

676


Is there any report or table in which user log off time is stored in sap?

666


Where is the Deletion Flag or Indicator used in archiving process?

2906


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?

5904


How can a user be able to access only for Customizing requests even if assigned se01 and se10?.

2677






What is the information derived from OSS notes?

6180


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?

1555


If a background job runs more than the time it should be completed normally then what actions will u take?

1343


What is the difference between – support package, kernel and sap note?

1007


What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?

2745


What is the folder it will ask to install oracle?

756


What is process for applying patches?

690


When we install sap r/3 enterprise 4.7, there are several error messages in the sapview.log. What does this mean?

707


Where XML file is generated in solution manager?

1317


Is sap a database ?

634