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 Help Members By Posting Answers For Below Questions

please share sap basis admin interview questions .. thanks sadik

878


Where can you find a list of object keys included in a transport?

634


What are the activities you done in EP?

1301


What are steps for DB Refresh?

1412


can we give one check for all vendors in automatic payment run? how?

1691






If job is slow?

1345


How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3171


how to do system refresh?not the client copy but the-standard-system-refresh.

1622


What are the daily activates?

598


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?

1858


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

1665


How you can assign an object to 100 roles at time?

888


On a particular system how you can get a list of the users with development access on a particular system?

639


Is there a difference between user ddic and sap_all/sap_new?

945


What is the difference between st06 and st03?

1277