SAP* deleted but logon with password pass not posible

[Former Member]

Dear all,

I need to implement some patches on the system. I "forgot" my user's password on client 000 and then I deleted the sap* user in order to have possibility to loggon with sap* and password pass.

What I did, on Oracle level now I have:

SQL> delete from sapr3.usr02 where bname = 'SAP*' and mandt = '000';

1 row deleted.

SQL> commit;

Commit complete.

SQL> select bname, UFLAG from sapr3.usr02 where mandt = '000';

BNAME UFLAG

-

---

-

---

SAPCPIC 64

RPO 128

DDIC 128

TMSADM 0

SQL>

But now when I tried to loggon with the GUI I got "Name or password is incorrect (repeat logon)" .

Do I need to restart the instance? I think no, but now I'm not sure.

It's the production system so I must wait till tonignt for the restart.

Does anyone have idea?

Thanks you,

Ruzica

[Former Member · Accepted solution]

The password is PASS (not pass) also in instance profile are you create the parameter -->

login/no_automatic_user_sapstar (value = 0) ; Regards.

[Former Member · Accepted solution]

Yes I have the parameter login/no_automatic_user_sapstar =1

"The default value of the login/no_automatic_user_sapstar profile parameter has been changed (previously 0, now 1). "

I need to change the parameter in RZ10 and restart the production? There is no other way, to do this dinamically?

Before when I tried to loggon SAP GUI with my user "Password logon no longer possible - too many failed attempts" .

I tried to enable my user RPO:

SQL> update sapr3.usr02 set UFLAG = '0' where mandt = '000' and BNAME = 'RPO';

1 row updated.

SQL> commit;

Commit complete.

And when I tried again to logon with my user on client 000 with user RPO and password I remember I got again the same message "Password logon no longer possible...". I was expected something else like Incorect password or ...

Thanks,

Ruzica

[Former Member · Accepted solution]

Hello Ruzica,

Since login/no_automatic_user_sapstar is NOT a dynamic SAP parameter, you have to restart your SAP system for the parameter to take effect.

Regards,

Ammey Kesarkar

[Former Member · Accepted solution]

After changing the value of login/no_automatic_user_sapstar did you bounce R3

[Former Member · Accepted solution]

Thanks Ammey,

I will restart the instance tonight and try SAP*

What about my user RPO do you know why the message is still the same after changing the uflag =0?

Shaji, what do you mean by "did you bounce R3" I will change the profile tonight and what shoud I do else?

Ruzica

[Former Member · Accepted solution]

Hi Ruzica,

Bounce i meant -> Restart

Cheers

Shaji

[Former Member · Accepted solution]

:-)((

Thanks