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 patches you applied?
Is sap a database ?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?
If you have a long-running Job, how do you analyse?
i am working with NBFC- MNC in personal loan dept. I applied for Internal Job Position in banking Division. My overall (10 years) experience in sales and People Management and in Internal Job Posting they require person for backend activity. There will be not repotees and its individual performance job. My Question is 1. If they will ask why you want to change your field form sales to backend job what should I answer? 2. The opening is in Chennai and since 10 year I am in Gujarat so if they ask why you want to change your home town location? Arpan Thakkar
What is the different architecture between SAP 4.7EE & ECC5.0
How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?
What are the Pre- requisite for system copy?
What is “data sets” in sap?
Explain domain controller?
How to setup RFC connection in ecc6 tells me steps involved?
Where XML file is generated in solution manager?
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?
In my portal ABAP + JAVA I get a bootstrap error message how do I resolve this erroe
How u will give new authorizations?