Skip to Content
avatar image
Former Member

SAP* login locked !!!??? how can i upgrade my license?

Hello gurus,

My SAP* login of one of the system got locked, while updating the license. Now the thing is, my license is expired, can only log in through SAP* and that log in also locked how can i upgrade my license??

Thanks and Regards,

Rahul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jun 07, 2007 at 05:09 AM

    Hi,

    Delete SAP* user manually from the database using sql command for the particular client.

    Then, try to login with sap* and pass combination. It will work.

    Hope this helps.

    Thanks and Regards,

    Sailesh K

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi,

      You can also delete SAP* user in client 000. It will default its password to PASS.

      In SQL

      SELECT * FROM USR02 WHERE BNAME='SAP*' AND MANDT='000'

      Run query to check return. Change Select to Delete and run again.

      1. Reset the password of 'sap*' in client 000

      2. Log on to oracle database using sqlplus.

      sqlplus / nolog

      SQL>connect /as sysdba

      SQL>update <SchemaOwner>.USR01 set bname='SAP1' where bname='SAP' and MANDT=000;

      1. [ e.g.: update SAPR3.USR01 set bname='SAP1' where bname='SAP' and MANDT=000; ]

      2. [e.g. : update SAP<SID>.USR01 set bname='SAP1' where bname='SAP' and MANDT=000;]

      SQL>commit;

      SQL>exit

      1. This will reset the user SAP* in client 000 . After loggin in client with user SAP* change the passwords for other users.

      1. You can user client number of your respective client.

      <b>## Please note do not reset any other user than SAP* with this method. </b>

      Reward points if useful.

      Regards,

      Sreevidya.S

  • avatar image
    Former Member
    Jun 07, 2007 at 05:53 AM

    Hi Sreevidya,

    My backend is MS SQL not oracle, you have any idea, how can i do that in my MS SQL 2005 database, what is the table name where users get stored??

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 13, 2007 at 01:43 AM

    Hi ,

    <b>If all the users are locked, they can be unlocked by</b>

    a)Try this command at ur sql plus query level

    Go to cmd prompt.

    Sqlplus /nolog

    conn /as sysdba

    this will take you to the sqlprompt.

    Just execute the earlier commands there.

    sqlplus><b>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64;</b> this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

    b) You can delete sap* user

    Go to cmd prompt.

    Sqlplus /nolog

    conn /as sysdba

    sqlplus>DELETE SAP .usr02 where mandt=' CLIENT.NO' and bname=SAP*;

    <b>Note:-

    After doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).</b>

    regards,

    kanthi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 13, 2007 at 07:44 PM

    License Issue:

    Logon to the OS where SAP installed. Change to ...\run\exe

    run:

    saplicense -get (it will show you the hardware key)

    saplicense -install (it will allow you to install the license).

    Logon Issue:

    once the lincense is installed logon throug DDIC.

    Add comment
    10|10000 characters needed characters exceeded