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.<\/p>\n
Steps to find the issue in Windows Environment.<\/p>\n
1. Go to CMD – R3trans -d<\/strong><\/em> (it ended with return code 0012)<\/p>\n 2. Read the trans.log<\/strong><\/em> & search if there any user lock issue found.<\/p>\n if YES then go to below procedure to resolved.<\/p>\n 1. Stop the SAP process in SAP MMC.<\/p>\n 1. go to sqlplus via “CMD – sqlplus \/ as sysdba<\/strong><\/em>”<\/p>\n 2. execute statement to check which user(SAPSR3) is locked.<\/p>\n select username, account_status from dba_users;<\/strong><\/em><\/p>\n find the list of dba users with their status. if SAPSR3 user is locked then execute this below statement to unlock.<\/p>\n alter user SAPSR3 account unlock;<\/strong><\/em><\/p>\n again execute to check whether it’s successful or not.<\/p>\n select username, account_status from dba_users;<\/strong><\/em><\/p>\n if successful log out from SQL & execute “R3trans -d<\/strong><\/em>“. it finish with RC=0000.<\/p>\n START SAP<\/strong> & it will start.<\/p>\n","protected":false},"excerpt":{"rendered":" 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[36,72,156,174,187,209,210,258,276],"class_list":["post-200","post","type-post","status-publish","format-standard","hentry","category-sap-updates","tag-alter-user","tag-dba-user-locked","tag-oracle","tag-r3trans-d","tag-sap","tag-sapsr3","tag-sapsr3-lock","tag-sql","tag-trans-log"],"_links":{"self":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/comments?post=200"}],"version-history":[{"count":1,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/200\/revisions"}],"predecessor-version":[{"id":1133,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/200\/revisions\/1133"}],"wp:attachment":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/media?parent=200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/categories?post=200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/tags?post=200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}