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

Kill Oracle Sessions

select inst_id,sid,serial# from gv$session where username='DBSNMP';

   INST_ID        SID    SERIAL#
---------- ---------- ----------
         1        282        730
         1        284      18914
         1        305      28470



alter system kill session '282,730,@1';

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

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 6BBFC576

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