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.
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?
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
Hi
Check Listener is up and running.
search for this error 0ra-12560, you will find a lot of notes.
Thanks
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?