Monday, August 22, 2011

Forgot SAP* Password


Q1: Please help me. I would like to update Support Package from Client 000, but I forgot all the password (DDIC and SAP*). How can I logon?
Q2: My temporary license Expired! I need to install new license, but all user can’t login except SAP*, but I forgot SAP* Password.
Answer:
To reset SAP* password, please follow this step:
1. Set the profile parameter login/no_automatic_user_sapstar to 0 from RZ10 (If you can’t logon, you can edit your Instance Profile directly from the OS level, folder /usr/sap//SYS/profile, )
2. Restart Application Server.
3. Logon to your SQL command (eq: SQL PLUS for Oracle) and connect as SYSDBA.
4. Run: SELECT * FROM [DBSID].USR02 WHERE BNAME=’SAP*’ AND MANDT=’
Example: SELECT * FROM PRD.USR02 WHERE BNAME=’SAP*’ AND MANDT=’000′
5. If exist, then run:
DELETE FROM PRD.USR02 WHERE BNAME=’SAP*’ AND MANDT=’000′
Make sure the user deleted by re-run step 4.
6. Logon to Client 000 with user SAP* and password: pass

1 comment:

Shruti Ramalingam said...

Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai