SAP* locked,

[former_member759680]

Hello,

When I try to log into client 100 using SAP*, it gives me error - Password locked-too many failed attempts.

I cant remember password of any other user.

I am able to log into Client 000 though.

Kindly help me unlock SAP* in 100 client.

Thanks.

[Former Member]

In instance profile set the parameter login/no_automatic_user_sapstar to 0. Now at database level delete the user sap* by executing following query

delete from sapr3.usr02 where bname='sap*' and mandt =100.

Now you will be able to login with username sap* and password pass on client 100.

reset the parameter login/no_automatic_user_sap* to 1.

<removed by moderator>

Edited by: Bernhard Hochreiter on Oct 14, 2008 1:23 PM

[former_member759680]

Thanks all.

I need one more favor.... I have not used SQL previously.. so could u guide me on the commands as well for AIX as teh OS.

Thanks

[Former Member]

which db r u using?. IF u r using SQL server right click and retreve all data by searching for table USR02 and then right and delete the entry corresponding for sap* and client 100.

U can edit the profiles and change the parameter from RZ10

<removed_by_moderator>

Edited by: Anish John on Oct 14, 2008 3:06 PM

Edited by: Julius Bussche on Oct 14, 2008 2:00 PM

[Former Member]

Hi Gautam,

If you are using Oracle as the DB then

Login to OS i.e AIX as ORASID

In AIX type:

Connect SQLPLUS as Sysdba;

After you are connected to the database then execute

delete from sapr3.usr02 where bname='sap*' and mandt =100;

Commit;

If you have to bounce the SAP system then use the command

stopsap; - this will stop the SAP instance first and then the database

startsap;- this will start the databse first and then SAP

Please ensure to set the value for the profile parameter before you perform the above steps.

Thanks,

Saby..

[former_member759680]

Saby, thanx a bunch.

Just one more doubt, how do I change the parameter before the above steps, if I am not able to log onto the system.

Thanks again.

[jurjen_heeck]

> Just one more doubt, how do I change the parameter before the above steps, if I am not able to log onto the system.

The instance profile is a text file on the filesystem of the server. If you search the forum for instance profile you should be able to get some pointers for any OS.

In my minisap (sid NSP) on windows it is: C:\SAP\NSP\SYS\profile\NSP_DVEBMGS00_systemname

[Former Member]

Hi Gautam,

Login to OS level as SIDADM

hostname>cdpro ( or migrate to usr/sap/SID/SYS/profile or /sapmnt/SID/profile )

ls -l

Take a back up of the current profile as follows:

( cp -p <instanceSID.pfl> <instanceSID.pfl.backup>)

vi instanceSID.pfl

edit the profile parameter login/no_automatic_user_sapstar to set value to 0

save it.

stopsap r3

startsap r3

Thanks,

Saby..

[Bernhard_SAP]

Hi,

you mentioned, that you are able to log on to client 000.... so change

the parameter value there....

b.rgds, Bernhard

[former_member759680]

Hello,

I changed the profile parameter to 0.

However I am not able to connect to the DB using the command. I get the following error -

1. su - oradxb

evoxidevp:oradxb 1> connect SQLPLUS as sysdba

connect: Command not found.

[Former Member]

Try connecting sqlplus "/ as sysdba" and execute the query

[former_member759680]

Still not working. The OS is AIX btw.

evoxidevp:oradxb 7> sqlplus "/ as sysdba"

sqlplus: Command not found.

evoxidevp:oradxb 8> oslevel

5.3.0.0

[Former Member]

oracle version.?

[former_member759680]

I found the solution, I am able to connect to sqlplus.... BUt now i have this new issue

SQL> delete from sapr3.usr02 where bname='sap*' and mandt =100;

delete from sapr3.usr02 where bname='sap*' and mandt =100

*

ERROR at line 1:

ORA-00942: table or view does not exist

[Former Member]

Please note that USR02 is owned by SAP. so you've to give the correct schema-id which owns this table.

DELETE FROM <schema-id>.USR02

WHERE BNAME='SAP*' AND MANDT='<client no.>'

try if ur schema id is sap<SID>

better execute the following query

select owner from dba_tables where table_name = 'USR02';

result of this query is the <schema-id>

Edited by: Anish John on Oct 15, 2008 2:19 PM

[former_member759680]

I tried using sapSID as well.

SQL> delete from sapdxb.usr02 where bname='sap*' and mandt =100;

delete from sapdxb.usr02 where bname='sap*' and mandt =100

*

ERROR at line 1:

ORA-00942: table or view does not exist

Can you guide me to determine the schema id from OS level

Thanks.

[Former Member]

better execute the following query

select owner from dba_tables where table_name = 'USR02';

result of this query is the <schema-id>

Try to give USR02 in caps

Edited by: Anish John on Oct 15, 2008 2:47 PM

[former_member759680]

It's done guys!!!!

Thanks a ton to each and everyone of you!!

[Former Member]

Hi Gautam,

In addition to what Anish has said, please execute the command "commit " after deleting the user SAP* from USR02.

This will then enable you to log in to the client with the user sap* and the password "pass" (as if you had created a new client for a client copy).

You will then have to recreate the user SAP* and this will write the entry back into table USR02.

You must make sure that the value for the parameter login/no_automatic_user_sapstar that is set to '0'. Otherwise, SAP* with password "pass" will not be enabled automatically.

For the value of this profile parameter to be effective you will have to bounce SAP.

Hope this helps!

Thanks,

Saby..

[former_member759680]

Solved!!