Unlocked user on Oracle, but user stays locked in SAP

[Former Member]

Hello,

I have a strange problem in one of my SAP systems. My administrator user-id has been locked out in client 000. I have unlocked the user via sqlplus (and a commit), but when I try to log on to SAP the user is still locked.

I have deleted user SAP* in client 000, but SAP still gives me the message "user is locked".

Does anyone know what is happening?

[udayshankarshankar · Accepted solution]

Hi

After deleteting SAP* and u still get the message that the user is locked

logon to a different client and give the Tcode /$sync

This will clear the buffers, after which u will be able to logon to 000 client.

This worked for me without having to recycle SAP.

[Former Member · Accepted solution]

PROCEDURE1

1. Delete the SAP* user from SQLPLUS tool

Login to OS by <oraSID> id

sqlplus u201C/as sysdbau201D

DELETE * from sapsr3.usr02 where bname='sap*' and mandt=<your client>;

commit;

2. Change OR add the profile parameter (Either from RZ10 OR Operating system -- Instance Profile file)

login/no_automatic_user_sapstar to 0

3. Restart the SAP system

Login to the system with Username: SAP* and Password as: PASS

Create Admin IDu2019s you need.

PROCEDURE2

1. Before you do step number 2 , you can unlock the user SAP* and change the

Password with another user ID that has access to Transaction SU01.

You need click on unlock button

1. Since the SAP* was locked you un lock the user by following steps.

Login to OS by <oraSID> id

sqlplus u201C/as sysdbau201D

update sapsr3.usr02 set uflag='0' where bname='SAP*' and mandt='200'; commit;

When users are locked, the uflag is set to 64, when the users are unlocked uflag is set to 0

64  for Locked

0  for UN Locked

[blair_towe2]

Good afternoon, Atos - You may also need to check to see if the following parameters are set in either the instance profile or the default profile:

login/failed_user_auto_unlock = 1

login/no_automatic_user_sapstar = 0

If they are not, add them (to either profile) and restart the system. Then you should be able to log in as sap* in client 000.

Regards,

Blair Towe

[Former Member]

Unlock your admin user from SAP system:

SU01.

Users are not locked or unlocked from Oracle.

They are doen so on the application level.

Message was edited by: Yuksel Guney Hanedan

[Former Member]

The problem here is related with data that remains buffered, you need to wait or restart the SAP system, and then it will work.

Regards,

Federico

[Former Member]

Hi,

can u pls tell me how to unlock user in oracle DB. i got similar problem like u. pls reply ASAP. waiting for reply.

thanking

prakash