Skip to main content

Update Apache Tomcat from 9.0.26 to 9.0.43

  Download Latest Available Version of Tomcat apache-tomcat-9.0.43.tar.gz copy in /sap/upgrades/ extract : tar zxvf apache-tomcat-9.0.43.tar.gz   Stop Data Services Take Backup of /usr/sap/IPS folder in /sap/upgrades or only Tomcat folder under /use/sap/IPS/sap_bobj/   go back to  /sap/upgrades/ mv apache-tomcat-9.0.43 tomcat cp -rp * /usr/sap/IPS/sap_bobj/tomcat/   Start Data Services

User Locked in SAP

Lock user (unlock)

lock - is  a record in the field  uflag, "0" - the user is not locked,

To Unlock - need to switch field  uflag to "0":

Locked
SQL> select uflag from sapsr3.usr02 where mandt='000' and bname='SAP*';

     UFLAG
----------
       128
Not locked:
SQL> select uflag from sapsr3.usr02 where mandt='431' and bname='USERNAME';

     UFLAG
----------
         0
Unlocking:
SQL> update sapsr3.usr02 set uflag='0' where mandt='000' and bname='DDIC';

1 row updated.

SQL> commit work;




UNLOCK your self
update sapr3.usr02 set uflag='0' where mandt='830' and bname='USER'; 
commit work;

RESET PASSWORD PROCESS:

SQL> select bcode, passcode from sapsr3.usr02 where mandt='000' and bname= 'DDIC';

BCODE            PASSCODE
---------------- ----------------------------------------
EF82F150AB6136BF 6BBFC576AC43020521E2206DBC1A0421A43E91C4

SQL> update sapsr3.usr02 set bcode='11FAF9DD879FE537',
passcode='ECB96161D5BDA8E04CE52AC886DEF5CD318869AE' where mandt='000' and bname='DDIC';

IF DATE EXPIRED:

SQL> select PWDCHGDATE from sapr3.usr02 where mandt='830' and bname='USERNAME';

PWDCHGDATE
------------------------
20190227

SQL> update sapr3.usr02 set PWDCHGDATE='20190728' where mandt='830' and bname='USERNAME';

1 row updated.


Comments

Popular posts from this blog

SUM Email Notification Configuration

edit MailNotifierApp.props this file under SUM folder /usr/sap/<sid>/SUM/abap/mailNotifier sum.host    = servername sum.port    = 1128 sum.user    = <SID>adm sum.pwd     = PASSWORD sum.sid     = <SID> sum.type    = sumabap sum.ssl     = false mail.host  = MAIL SERVERNAME mail.port  = 25 mail.user  = mail.pwd   = mail.from  = senderid@test.com mail.to    = receiver@test.com mail.debug = false save this and exit  then run this following command in terminal you have to keep this terminal open to run notification program. java -jar MailNotifierApp.jar properties=MailNotifierApp.props you will get test email after this

Update Apache Tomcat from 9.0.26 to 9.0.43

  Download Latest Available Version of Tomcat apache-tomcat-9.0.43.tar.gz copy in /sap/upgrades/ extract : tar zxvf apache-tomcat-9.0.43.tar.gz   Stop Data Services Take Backup of /usr/sap/IPS folder in /sap/upgrades or only Tomcat folder under /use/sap/IPS/sap_bobj/   go back to  /sap/upgrades/ mv apache-tomcat-9.0.43 tomcat cp -rp * /usr/sap/IPS/sap_bobj/tomcat/   Start Data Services