SAP所有用户被锁定，处理方法

所有？是否包括超级⽤户SAP*？

如果sap*未锁定，可以⽤sap*登陆解锁，⽤户数少可以⼿⼯在su01⾥解，⽤户数多的话，可以⽤catt or abap程序的⽅式批量改，table字段为usr02-UFLAG.

如果sap*也锁定了，那就得⿊⼀把了：

⾸先，确认参数⽂件login/no_automatic_user_sapstar的值为0；

然后，直接登陆到数据库中，删除USR02表中，相应client的SAP*⽤户，不要删错罗；） 最后嘛，再⽤SAP*登陆该client，使⽤⼝令PASS，进去再做上⾯说的操作。-----------------------所有⽤户都被锁了,当然进不了系统,也⽤不了rz10了,去⽬录底下看/usr/sap/SID/SYS/profile/(instance profile)

找login/no_automatic_user_sapstar这个参数,如果没找到说明sap*可以⽤来登陆,如果值是1,说明sap*被deactive了,要改成0.然后sqlpus去删除sap*:

delete from sapr3.usr02 where mandt='' and bname='SAP*'; commit;

最后重启SAP instance 来activated新的profile.⽤sap*登陆后可⽤su10批量来解其他⽤户.------------------------------------------------------

how to reset DDIC and SAP* password 如何解除DDIC 和SAP* ⽤户全被锁定

I'll give the awnser from my issue practise as below:

1, logon the operate system as adm. for example: logon the server by user slmadm and password. slm is the slm's sid, slmadm is theadmin for slm.

if slm was installed on the single PC, this step can be ignored. if slm and dev or ide or prd were installed on the one server together, thisstep is important.

2, cmd - > sqlplus /nolog3, sql > connect /as sysdba

4, sql > delete from sapsr3.usr02 where bname='SAP*' AND mandt='001';5, sql > commit;6, sql > exit

note: the key step is 4, 001 is the wanted client, you can change it. sapsr3.usr02 is used be. you can see it use : \"selectowner,table_name from dba_tables where table_name='USR02'; \".finally, \";\" cannot be ommitted.

7, then you can logon 001 with sap* (password is pass). needn't restart the instance. and you can change or unlock any other users bysap*.

8, enjoy it!