Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

Unlock & Reset SAP* Password in Oracle

1. Remote Desktop (Windows) / Telnet (Unix/Linux) to OS level and connect to the sql using the command prompt.

C:\Documents and Settings\devadm>sqlplus”/as sysdba”

2. View the SAP* table.

SQL> select UFLAG, BNAME, MANDT from SAPSR3.USR02 where BNAME=’SAP*’;

3. Unlock the SAP* password.

SQL> update SAPSR3.USR02 set UFLAG=0 where BNAME=’SAP*’ and MANDT=000;

4. Reset the SAP* password

SQL>delete from SAPSR3.USR02 where BNAME=’SAP*’ and MANDT=000;

5. Set the parameter login/no_automatic_user_sapstar is set to 0. You also can check in RZ11. You need to reboot the SAP once the parameter is change.

login/no_automatic_user_sapstar=0

Note:

• This example shows for SAP* in client 000 in Oracle environment.
• Default password for sap* is pass / 06071992.
• Execute transaction code /$tab to reset buffer

Source: http://itsiti.com/unlock-reset-sap-password-in-oracle

Comments are closed.