How to reset SAP* password..

[former_member185534]

Hello to All,

I installed IDES Server with Oracle and Windows Server 2003,I forgot the password of SAP*.Now i want to reset the password of SAP*.

Can you please let me know how to do this.?

Please reply..

Reagrds,

JUNAID

[Z1007832]

Cbo

[Former Member]

Hi Junaid,

hope your doing good. Can you please confirm if the response helped you and if the issue is resolved request you to close the thread.

Regards,

ram

[Former Member]

Hi Junaid

Try to join with default user to next clients:

User SAP*

Password : 06071992

User DDIC

Password : 19920706

Or...

Set the parameter login/no_automatic_user_sapstart = 0

Restart thh system.

And the password is pass

Regards.

Josué Acuña

[Former Member]

Hello Ahmed,

1-Check actual value of this and if not update and restart SAP login/no_automatic_user_sapstar = 0

2-delete from sapsr3.usr02 where bname='SAP*' and mandt=XXX; commit;

3-You can login sap*/pass and you can create sap* again. Then update the password how you wish.

Regards,

Serhat

[Former Member]

Hi Junaid,

Please refer below document to reset and unlock sap*

http://scn.sap.com/community/oracle/blog/2013/11/21/how-to-delete-sap-from-database-level

• Start the database server manager with the command:
  sqlplus "/as sysdba"
  Now you're able to execute SQL statements:
• to view the entries of the "sap*" user type in following command:
  select * from <db_schema>.usr02 where mandt = '000' and bname = 'SAP*'; (maybe you have to change "mandt" to your client)
• to delete the "sap*" user type in the following commands:
  delete from <db_schema>.usr02 where mandt = '000' and bname = 'SAP*'; (maybe you have to change "mandt" to your client)
  commit;

Let us know if this helps.

Regards,

Ram

[Former Member]

Hi Junaid,

1. Set the parameter login/no_automatic_user_sapstar to 0 (zero) in instance profile by navigating to path /usr/sap/SID/SYS/profile.

2. Delete the SAP* from OS level, present in that particular client and then restart the system; as mentioned above.

3. Restart the system. Now you can login in the system with User as SAP* and Password as pass.

Regards,

Prithviraj.