HANA DB with extension node upgrade steps

Hello  Everyone,

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

https://launchpad.support.sap.com/#/notes/2048681

Regards

Bhargav Bhatt