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

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


How to reset password for user "sys" in Oracle?
Solution:
  1. Delete pwdniku.ora from /$ORACLE_HOME/dbs folder 

  2. Run command orapwd file=/$ORACLE_HOME/dbs/orapwniku.ora password=system entries=10 

  3. Connect to Oralce using sqlplus /nolog 

  4. Run command inside SQL prompt: connect sys/system as sysdba 

  5. Run command: alter user system identified by system; 

  6. At this point your user "system" password has been changed to system in this example 

  7. Connect to SQLPLUS: sqlplus system/system 

  8. Run command: alter user sys identified by system; 

  9. Your sys password now has been changed

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