Login Failed

[Former Member]

Password no longer possible - too many failed attemps

in sap solution manager i m not able to login by Sap* DDIC Basis or any user ..........

All Comments are appreciable .......

[Former Member · Accepted solution]

Hi Sukhbir,

You can unlock the user at database level.

#su - ora<sid>
# sqlplus / as sysdba;
SQL> UPDATE SAPSR3.USR02 SET UFLAG='0' WHERE UFLAG='64' AND MANDT='000';

Above procedure only UNLOCK ALL THE LOCKED USERS from the client 000 (MANDT='000').

If you don't remember the password of any superuser then follow the below procedure.

1. Edit the INSTANCE or DEFAULT profile at OS level and add the below parameter

(Location = /sapmnt/<SID>/profile/START_DVEBMGS<no>_<hostname>)

login/no_automatic_user_sapstar = 0

2. Delete the SAP* user from the table at database leve.

#su - ora<sid>
# sqlplus / as sysdba;
SQL> DELETE FROM SAPSR3.USR02 WHERE BNAME='SAP*' AND MANDT='000';
SQL> COMMIT;

(You can use the same method for other client also. Just change MANDT='<Client No' in above command)

3. Then restart the SAP and login to client 000 with user SAP* and password 'PASS'

Regards.

Rajesh Narkhede