Skip to main content

Posts

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

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;

SLPProxyHand 500

SUM Issue *** ERROR => SLPProxyHandlerFactory::ConnectContext called but ctx->operationID is NULL   [SLPProxyHand 500] Upgrade SAP Host Agent *** ERROR => SLPProxyHandlerFactory::ConnectContext called but ctx->operationID is NULL   [SLPProxyHand 503] Kill all services starting with   : ps -ef|grep sap

How to reset password for user "sys" in Oracle?

How to reset password for user "sys" in Oracle? Solution: Delete pwdniku.ora from /$ORACLE_HOME/dbs folder  Run command orapwd file=/$ORACLE_HOME/dbs/orapwniku.ora password=system entries=10  Connect to Oralce using sqlplus /nolog  Run command inside SQL prompt: connect sys/system as sysdba  Run command: alter user system identified by system;  At this point your user "system" password has been changed to system in this example  Connect to SQLPLUS: sqlplus system/system  Run command: alter user sys identified by system;  Your sys password now has been changed

cleanipc

error :  kernel runs with dp version 140000(ext=121000) (@(#) DPLIB-INT-VERSION-140000-UC) length of sys_adm_ext is 592 bytes *** ERROR => Shared Memory Key 57 (SHM_PROFILE) already exist [dpxxdisp.c   1124] *** ERROR => dispatcher already running ???? [dpxxdisp.c   1125] *** ERROR => I better EXIT before I do any (more) damage [dpxxdisp.c   1126] Fix cleanipc <Instance Number> remove