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

About these ads


10 Responses to “Forgot SAP* Password”

  1. 1 sree

    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;

  2. 2 Dellibabu

    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

  3. 3 gsoekirno

    @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.

  4. 4 srinivaas t

    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.

    • 5 gsoekirno

      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.

  5. 6 popo

    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

    • 7 gsoekirno

      Hi,
      You must edit your instance profile. Means file “dvebmgs_00″ for example.

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

  7. 9 kids love cats

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

  8. 10 Juan Carlos

    Excelent!!!!!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: