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 is role of sap administrator in pi & ep?
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
How to add authorizations, how you will maintain profiles?
In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?
What is your UNIX experience and the types of UNIX systems you have worked on.
What is a support package? What is its purpose?
Explain reference and service user in sap. What are their uses?
describe how SAP handles Memory Management?
How to apply java stacks ? expalin step by step prcoess
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
How you will rate yourself in SAP, Oracle from a scale 1 - 10?
what is the difference between with core
please share sap basis admin interview questions .. thanks sadik
what is the procedure for java stack upgradation?
How can you find the list of objects that have been repaired in the system?