HANA DB with extension node upgrade steps

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

(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.