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
please share sap basis admin interview questions .. thanks sadik
Where can you find a list of object keys included in a transport?
What are the activities you done in EP?
What are steps for DB Refresh?
can we give one check for all vendors in automatic payment run? how?
If job is slow?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
how to do system refresh?not the client copy but the-standard-system-refresh.
What are the daily activates?
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?
i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com
How you can assign an object to 100 roles at time?
On a particular system how you can get a list of the users with development access on a particular system?
Is there a difference between user ddic and sap_all/sap_new?
What is the difference between st06 and st03?