SAP* Problem

[Former Member]

Hi Friends,

I tried to login SAP* and password PASS form 000 client but i am unable login it show's message like

"Paswword logon no longer possible-too many failed attempts"

I tired in sevearal ways like

1. I looged into 000 and user id is SAP and password 06071992 it's not working.*

2. 000 client userid DDIC and Password 19920706 but it's not working.

3. I looged into 800 client with diffrent user i checked SAP is not locked.*

4. I Excute command in SQLPLUS like

*SQL> update sapdcp.usr01 set bname='SAP1' where bname='SAP' and MANDT=000;*

*update sapdcp.usr01 set bname='SAP1' where bname='SAP' and MANDT=000*

*****

*ERROR at line 1:*

*ORA-00942: table or view does not exist*

then it's show above error.

can any body help me .

My environment:-

ECC6.0.

Oracle:-10.2.0.2

windows2003.

Best Regards,

vijay

[Former Member]

you should add parameters login/no_automatic_user_sapstar value '0' by rz10

[Former Member]

Hi,

The above reply is a perfect one.

Adding to it.

After deleting make sure that login/no_ automatic_ user_ sapstar value is set to 0.( Refer SAP Notes 2383 and 68048 for more info) If the value is set to 1 SAP* will not be able to login to the system, and only then restart the system.

Thanks and Regards

Jaianandh V

Edited by: Jaianandh V on Apr 7, 2010 8:45 AM

[Former Member]

If you forgot SAP* Password (R/3 side)

You can delete the user at database level and perform a stop/start of the system and also check the parameter login/no_automatic_user_sapstar should have the value 0.

You can delete it from database with below command

-login to OS level with SIDadm or oraSID

-sqlplus "/ as sysdba"

-At the SQL prompt, type the following command

SQL>DELETE * FROM USR02 WHERE MANDT="000" AND BNAME="SAP*"

SQL> Commit

SQL>Exit

-Restart the system and login with SAP* and default password

Hope this helps.

Regards,

Snehal Bhaidasna

SAP, CA(USA)

[Former Member]

Hi Vijay,

Ecc 6.00 cannot possible to logon user id is SAP* and password 06071992

what is ur master password. u can use that master password otherwise not possible.

Regards

kesavan

[Former Member]

Hi Kesvan,

i tried using master pasword but it's not working.Any other option.

Regards.vijay

[Former Member]

Dear Vijay,

No vijay u can use above queory thats all.

u want make a client copy or other things like post installation activities.

Regards

kesavan

[Former Member]

Hi Vijay,

You can delete the SAP* in sql level, and login to the R3 using 'pass'

login/no_automatic_user_sap* should be zero for the above condition.

Thanks and Regards

Purna

[Former Member]

Hi,

Please go through the below link, i think it helps

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP-Howtounlocktheuser%27sSAPlogon+id

Thanks,

Sreeni.