DDIC & SAP* locked in CI Installtion

[Former Member]

Hello,experts

In ERP Central Instance installtion, 000 DDIC and SAP* locked.

I deleted sap* record in USR02, however cannot logon due to too many failed attemps.

In this case, how to unlock SAP* ,and logon Client 000?

Please help  me to solve this problem.

Best Regards,

Naomi Yamane

[Former Member]

Hi Naomi Yamane,

Your issue resolved or not?

Thank you

Mahendran

[Former Member]

Hi Naomi ,

Like you said in your question.

Are you facing this problem during installation of ERP Central instance ?? please provide info.

If you are facing this problem during installation then I have gone through this before when i was installing Netweaver 2004s sr2 on distributed system, during Central instance part installation last stages it gave me error ddic user is locked. Though i can see system is up can green and correct password still cannot login. I followed procedure to unlock it and continued installation.

Have a look at this document for unlocking Sap*.

http://scn.sap.com/docs/DOC-49479

Regards

Syed Athesham.

[former_member182034]

hi Naomi,

First check the value of parameter login/no_automatic_user_sapstar in instance profile which should be 0.

If User SAP* is locked and you have no other user to unlock then you need to run below SQL command to reset the password.

SQL> delete from SAPSR3.USR02 where bname='SAP*' and mandt='Client_Number';

now you can logon with SAP*

Regards,

[Former Member]

Hi,

As you are saying that the id is locked. you can unlock it at os level.

If the user is locked you will need to update UFLAG field in table USR02.

Example:

Update SAPSR3.USR02 set UFLAG=0 where BNAME='DDIC' and MANDT=000

Thanks

Rishi Abrol

[Former Member]

Hi Naomi,

Here are some steps that can help you.

1. Delete the SAP* from client 000 using SQL query at database level.

2. commit the changes in database.

3. Set SAP parameter "login/no_automatic_user_sapstar=0" in SAP instance profile.

4. Restart the SAP system and use default password ,i.e.,pass.

Regards,

Shashi

[Former Member]

Hi Naomi,

Did you try to login using login 'SAP*' with 'pass' password after deletition.

br,

kamil

[hasanajsh]

First of all, you need to check

login/no_automatic_user_sapstar parameter in the system profile (default or instance).

If needed, in operating system it is in

/usr/sap/<sid>/SYS/profile folder.

Be default it is 1, so if it is not there you need to add it and reset to 0.

Anyway, deleteing from USR02 is not enoguh; you need to restart the system.

Good luck!