Updating SAP HANA Database, Client and Studio

How to Update SAP HANA Database. What is the sequence to be followed to update SAP HANA Database. How to download HANA Media. How to Check SAP HANA Version.

1) Login to SAP Maret Place(http://service.sap.com/swdc) and Navigate to  SAP Software Download Center -> Installation and Upgrades -> My Company’s Application Components -> SAP HANA PLATFORM EDITION -> SAP HANA PLATFORM EDIT. 1.0 -> Installation -> (Download the latest avilable SAP HANA Platform Ed. 1.0 DVD using SAP Download Manager)

2) Copy and extract the Dowloaded HANA DVD’s to the OS of HANA server(SUSE Linux Enterprise Server (SLES) 11).
3) Before Starting the HANA Database Update, Make sure that you have:
    a)    A valid permanent SAP license for SAP HANA database.
    b)    Username and Password for users SIDadm user, SYSTEM user, S-userID
    c)    Take Complete Backup of HANA Database and other components like Name Server, Index Server, Statistics Server, XSEngine.

Also check the following HANA Update and configuration Guides:
http://help.sap.com/hana/SAP_HANA_Master_Update_Guide_en.pdf
http://help.sap.com/hana/SAP_HANA_Update_and_Configuration_Guide_en.pdf (the document is for the outdated Sap HANA SPS 8)

http://help.sap.com/hana/SAP_HANA_Server_Installation_Guide_en.pdf

4) HANA can be updated using HANA Life Cycle Manager(HLM) or from the OS level command line or even update can be executed even when HANA is Offline/Online(required HANA processes will be restarted automatically).

    In this case, we are updating HANA Database with Command Line method.
       HANA Database Update Sequence:
               1) Application Function Library (AFL)
               2) Update HANA Database
               3) Update HANA Client
               4) Update HANA Life Cycle Manager (HML)
               5) Update HANA Sudio

    4.1) Add/Update AFL Plugin: navigate to respective platform folder “HDB_AFL_LINUX_X86_64” and run the script “./hdbinst” as user “root”.

INFO: ALF packages installation path: “/hana/shared/SID/exe/linuxx86_64/plugins/afl_xxxxxxxxx”
NOTE: It is recommended to have AFL component version same as the SAP HANA DATABASE component version.

    4.2) Updating HANA Database Server: navigate to respective platform folder “HDB_SERVER_LINUX_X86_64” and run the script “./hdbupd” as user “root”.

    ->In the prompt, select the instance number you want to Update
    ->Provide the password for user “sidadm”
    ->Provide HANA Database user “SYSTEM” password
    And Update starts…

NOTE: If there is no valid license, the HANA DB update fails.

    4.3) Updating HANA Client: navigate to respective platform HANA Client folder “HDB_CLIENT_LINUX_X86_64” and run any one of the below scripts (GUI/CLI mode) as user “root”.

    ->./hdbsetup (starts in GUI Mode)
    ->./hdbinst (starts in command line mode)
    ->In the prompt, select the SAP HANA Database Client you want to Update.
    And Update starts…

INFO: SAP HANA Database Client installation path: “/hana/shared/SID/hdbclient“

    4.4) Updating HANA Studio: navigate to respective platform folder like “HDB_STUDIO_LINUX_X86_64” and run any one of the below scripts (GUI/CLI mode) as user “root”.

    ->./hdbsetup (starts in GUI Mode)
    ->./hdbinst (starts in command line mode)
    ->In the prompt, select the SAP HANA Studio Installation you want to Update.
    And Update starts…

INFO: SAP HANA Database Client installation path: “/hana/shared/SID/hdbstudio“

How to Check SAP HANA Version after update:
———————————————————–
Once the update is done you can cross check the HANA Database version from one of  the below mathods:
    a) HANA version check from Command Line:
        ->Login to OS level as user “SIDadm“
        ->Run the command “HDB version“

    b) HANA version check from HANA Studio:
        ->Login to Studio and check the “Version History” as below
        ->HANA Studio -> HANA system -> Right Click -> properties -> Version History.