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
How will u send mail after completion of backup?
Do you have done System copy? What are the steps?
What is an “ok” code is and what is the difference between “t-code” and “ok” code?
How many types of work processes?
Error in the phase import_proper while applying support packages?
What is process for applying patches?
In what ways you would know whether a system is unicode or non-unicode?
Is there a difference between user ddic and sap_all/sap_new?
Explain the developer trace?
How do you check the users logs in your system and how many sessions each user is generating?
Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com
in oracle script @? "?" question mark means what it indicate?
what are the main issues you faced in the implementation project?
What is a background processing batch scheduler?
What is the need of having Development system?