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
Post a Comment

Oracle Fragmentation

select
   table_name,round((blocks*8),2) "size (kb)" ,
   round((num_rows*avg_row_len/1024),2) "actual_data (kb)",
   (round((blocks*8),2) - round((num_rows*avg_row_len/1024),2)) "wasted_space (kb)"
from
   dba_tables
where
   (round((blocks*8),2) > round((num_rows*avg_row_len/1024),2))
order by 4 desc;

Labels:

Comments

Post a Comment

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
Post a Comment
Read more

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
Post a Comment
Read more

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
Post a Comment
Read more