This Blog covers the steps of upgrading HANA database having extension node.
Here, We have BW/4HANA installed with extension node. In this blog I will be showing DB Rev upgrade from HANA 2.0 SP3 Rev33 to HANA 2.0 SP3 Rev37
Prerequisite: <sid>adm user on both DB nodes should have the same password
Here i will be using below naming convention
HANA DB primary node : Host1
HANA DB extension node : Host2
Stop HANA on Host1 and Host2
Start SystemDB on Host1 with below command on Host1
On Master Node (Host1) execute # hdblcm –action=update –scope=instance (Note there is two “-” in the command)
(use root user)
Choose option 1 here to update HANA Database software.
choose option 1 here as we need to upgrade HANA client as well.
It will ask for HANA DB admin user and password. Make sure that password should be same in both host as mentioned in prerequisite.
Once upgrade is completed it will show message as HANA DB is updated and run below command on extension node.
Login to Host2 (worker/secondary) and run # hdblcm –action=update_host
(use root user)
make sure you run hdblcm under /hana/shared/<SID>/hdblcm/
Here just we have to choose yes to start the upgrade
HANA will be shutdown on Host2, so start it again
check upgraded HANA version
On APP servers run the HANA client update
Once client is upgraded on all application we can start sap application.
This is how we can successfully upgraded HANA db with extension node. 🙂
Below is reference sap notes which can be useful during upgrade.
2048681 – Performing SAP HANA platform life-cycle management administration tasks on multiple-host systems without SSH or root credentials