SAP Users are locked - How to unlock them?

[Former Member]

Hi all,

I running SAP NetWeaver 2004s on Linux x86_64 and Oracle 10g.

All my SAP Users are locked. I can't access SU01 or SU10.

<b>Please help me how to unlock them.</b>

Thanks,

Nagarjuna.

[Former Member · Accepted solution]

Hi ,

If all the users are locked, they can be unlocked by

a) GO to command prompt type <b>tp unlocksys <SID> pf=//usr/sap/trans/bin/TP_DOMAIN_<SID>.pfl</b>;

b) or else try this command at ur sql plus query level

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

this will take you to the sqlprompt.

Just execute the earlier commands there.

sqlplus><b>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64</b>;

this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

c) You can delete sap*

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus><b>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;</b>

<u><b>Note:-</b></u>

<b>After doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).</b>

regards,

kanthi

[Former Member · Accepted solution]

Hi All,

Thanks for the Help. I am able to resolve my issue.

I followed the above procedure -b, but one small change; instead of <b>SAP<SID></b> I had to use<b> SAPSR3</b> and <b>UFLAG</b> was having value <b>128</b> not <b>64</b>.

May be these changes are specific to 2004s.

After that I restared SAP & Linux system.

Thanks,

Nagarjuna.

Message was edited by:

Maha Nagarjuna Angalakuditi

[praveenkumar_kadi]

Hi,

Check this thread

Hope that helps

[Former Member]

Hi,

Check the parameter "login/no_automatic_user_sapstar= 0" in your instance profile after delete statement in database.

- Yvan GENUER

[Former Member]

Hi,

tp unlocksys <sid>

Regards

Umesh K