Situation : The user that you trying to log on is locked, plus you do not have any other user on that same client to unlock that user. And you cannot restart the system to change the parameter login/no_automatic_user_sapstar.In our case BASIS is the user & we are trying to log on in client 300.

What you have : We are having DDIC / SAP* user password for 000 Client . 

Logic :Logon the database with SQLPlus,and with those commands below,you going to change the CLIENT of your locked user (example user:BASIS)to anotherclient

In this case, from 300 to 000

Commands : SQL> UPDATE sapsr3.usr02 SET MANDT = ‘000’  where BNAME = ‘BASIS’ AND MANDT = ‘300’;

This command will bring BASIS user from client 300 to client 000.

Now you can easily reset password for BASIS user by logging into client 000.

Once this is done , we need to revert the change you made earlier .

Move this user to its original client i:e move it from 000 to 300 by using below command.

SQL> UPDATE sapsr3.usr02 SET MANDT = ‘300’  where BNAME = ‘BASIS’ AND MANDT = ‘000’;

That’s it, now the user BASIS is unlocked (or password reset) on the CLIENT 300.

Note :In the case of productive environments follow the way of SAP* (Login/no_automatic_user_sapstar )