Forgot SAP* Password

14Feb08

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/<SID>/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='<client>’

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

11 Responses to “Forgot SAP* Password”

Feed for this Entry Trackback Address

1 sree on December 14, 2009 said:

Nice postings.

only thing I have observed is we have to perform commint after the changes.

The last step will be

7. Do a commit after executing the the sql to make the chages permanant.
sql> commit;

Reply
2 Dellibabu on February 26, 2011 said:

Hi,

In case if the parameter does not eixst in instance profile, do we need to add it and save the file? could you clarify my doubt.

Regards
Delli

Reply
3 gsoekirno on February 28, 2011 said:

@Dellibabu: Yes, if the parameter not exist, you may add it. Please make sure the parameter name via transaction code RZ11 before you add it.

Reply
4 srinivaas t on December 3, 2011 said:

i run the commend but it shows below messge error

Msg 208, Level 16, State 1, Line 1
Invalid object name ‘ecc.USR02’

could you pls tell me.

Reply
- 5 gsoekirno on December 3, 2011 said:
  
  hi, try to change the DBSID to your SAP-SCHEMA-ID. Usually its SAPSR3. Make sure you are able to Select first before delete it.
  
  Reply
6 popo on July 7, 2012 said:

hi,
i don’t understand the first step, you said, go to the directory “/usr/sap//SYS/profile” but i don’t understand what i must edit

Reply
- 7 gsoekirno on July 7, 2012 said:
  
  Hi,
  You must edit your instance profile. Means file “dvebmgs_00” for example.
  
  Reply
8 Jared on February 11, 2013 said:

This is my first time pay a quick visit at here and i am
in fact happy to read all at one place.

Reply
9 kids love cats on April 12, 2013 said:

Wow, that’s what I was looking for, what a data! existing here at this blog, thanks admin of this website.

Reply
10 Juan Carlos on May 18, 2013 said:

Excelent!!!!!

Reply
11 Chadwick Krupiak on October 11, 2018 said:

Ӏ visit daily a few web sites and infօrmation sites tⲟ reɑԁ articles, but tһis webpage рresents quality based
articles.

Reply