how to repair the sap* default password,r3 sys log file
accur error..
Answer Posted / hari kiran vemula
For SAP* purpose, Need to set parameter as below:
login/no_automatic_user_sapstar = 1
This should be 0
--> To change DDIC password, Need to change the password
from OS level as below:
To unlock DDIC:
sqlplus /nolog
conn /as sysdba
update <schema_name>.usr02 set uflag='0' where
mandt='client_no' and bname='DDIC';
commit;
(Schema_name is usually SAPR3)
To change DDIC password:
Suppose you know the password of User - XYZ in this system
select bcode from <schema_name>.usr02 where
mandt='client_no' and bname='XYZ';
This will display the bcode - a long key. This is the
encrypted password of user XYZ
Copy this key.
update <schema_name>.usr02 set bcode='key' where
mandt='client_no' and bname='DDIC';
commit;
The password of DDIC is same as XYZ now.
Note: Then restart your server, and check it, Let us know
as same..
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what are the current support stack levels at market place?
What are the activities you done in EP?
How database extend?
Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?
What are the different types of sap profiles?
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?
If possible send me screenshot doc for installation of ecc6
What is the use of profile paramater ztta/roll_area?
How to apply job on OS Level?
What is “data sets” in sap?
Is it possible to install ecc 5.0 as a test system and not production, without installing solution manager?
What is the system's configuration required to implement SAP.
What is the use of account id in logon tab?
If a background job runs more than the time it should be completed normally then what actions will u take?
How do you check the users logs in your system and how many sessions each user is generating?