Skip to content


SAPSR3 user locked.

Recently we find an issue that while starting SAP via SAP MMC, work process stop in Ended status. We found in developer trace that it’s a database connectivity issue. In some cases connectivity from SAP to Database does not happen due to SAPSR3 user locked.

Steps to find the issue in Windows Environment.

1. Go to CMD – R3trans -d (it ended with return code 0012)

2. Read the trans.log & search if there any user lock issue found.

if YES then go to below procedure to resolved.

1. Stop the SAP process in SAP MMC.

1. go to sqlplus via “CMD – sqlplus / as sysdba

2. execute statement to check which user(SAPSR3) is locked.

select username, account_status from dba_users;

find the list of dba users with their status. if SAPSR3 user is locked then execute this below statement to unlock.

alter user SAPSR3 account unlock;

again execute to check whether it’s successful or not.

select username, account_status from dba_users;

if successful log out from SQL & execute “R3trans -d“. it finish with RC=0000.

START SAP & it will start.

Posted in IT, SAP.

Tagged with , , , , , , , , .


7 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

  1. Dharshan says

    Hi,
    I am stuck up @ this step
    1. go to sqlplus via “CMD – sqlplus / as sysdba”
    I logged in as administrator, when I try to enter I get this error

    Microsoft Windows [version ]
    (C) Copyright1985-2003 Microsoft Corp

    What should I do?

  2. Dharshan says

    Hi,
    I misunderstood CMD, what a n00b…
    then I went to cmd command prompt and entered sqlplus “/as sysdba”
    it worked fine but now I got another error:

    ora-12560: tns:protocol adapter error

  3. adil says

    Hi
    Check Listener is up and running.
    search for this error 0ra-12560, you will find a lot of notes.

    Thanks

  4. Dharshan says

    Hi, thanks for the reply… what do you mean by listener… I seriously don’t know much here, I searched like hundreds of pages for two days and your blog is the only one that was clear to a newbie… that is why I asked doubts in comments too…

    by listener do you mean start->run->services.msc->oracleservicesSID?

  5. Aliya says

    Hi,
    I found your solution very lucid and to the point since I am aware of this issue. Its been a year since I am in SAP basis..pretty new though but trying hard to learn as much as I can.
    I hope you can give a solution to my problem as well.

    I am facing a similar issue,
    R3trans finished (0012).

    trans.log :

    *** ERROR => CONNECT failed with sql error ‘1017’
    4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017
    4 ETW000 [ dev trc,00000] –>oci_get_errmsg (con=0, rc=1017)
    4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017
    4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied

    When I checked “select username,account_status from dba_users;”
    I see that SAPSR3 is locked! So I unlocked it with “alter user SAPSR3 account unlock;”
    Further I changed the password also of SAPSR3 “alter user SAPSR3 identified by *****(new password) ;”
    But the error persists! What else could be done? I request you to help me.
    I refered note 400241 but was’nt sure how to apply it. Also prior to this I had upgraded the kernal ( 720, patch no 400 to patch no 439),since the system was not coming at all. After upgrade the system partially came up but Disp+work stopped ( I guess because database is not availabe via R3trans).

    Thanks & Regards

  6. Adil says

    Hi Aliya,

    SAPSR3 password can only change by BRTOOLS only.

  7. Aliya says

    Hi Adil,
    Yes, I figured it out. Issue has been resolved.
    Thank you!



Some HTML is OK

or, reply to this post via trackback.


eight + 3 =


viagra