Wednesday, 6 May 2020

HANA DB Upgrade


1: SAP HANA Platform 1.0 (all supported SPS) to SAP HANA Platform 2.0 SPS 00 

2: SAP HANA Platform 2.0 to a higher release. 

PREREQUISITES

Before starting the update for the components in your SAP HANA landscape several prerequisites have to be fulfilled.

Make sure you fulfill the following prerequisites:

1: If you are performing an offline update, you have all the necessary installation files for the individual components.

2: You have a valid, permanent SAP license for the SAP HANA database. 

3: You have user names and passwords for the following users:
                 1.      sidadm user
                 2.      sapadm user
                 3.      S-user for the SAP Support Portal 
                 4:  SYSTEM

4: You have carefully read the update instructions for the individual components.

5: You have made the necessary preparations to perform backups for the SAP HANA database and the other components

6:If you are doing Update an SAP HANA System from 1.0 SPS 10 - 1.0 SPS 12 to SAP HANA Platform 2.0 SPS 00.  
              With SAP HANA Platform 2.0, the metadata persistency layout has been changed. Furthermore an older column store persistence format has been deprecated and is not supported anymore. Therefore you need to pay special attention before updating your existing SAP HANA 1.0 system to SAP HANA Platform 2.0.    --  Mandatory Preparation Steps for Upgrading a SAP HANA 1 System to SAP HANA 2 (2372809 )

7: IF you updating to SAP HANA Platform 2.0 SPS 00 or higher, it may be necessary to upgrade the operating system. For more information, 2235581 - SAP HANA: Supported Operating Systems
             Red Hat
                 7.2 (up to HANA 2.0 SPS03)
              SUSE
                12 SP2 (HANA 2.0 SPS01 and newer, up to HANA 2 SPS03)
               12 SP1 (HANA 2.0 SPS00 and newer, up to HANA 2 SPS03)


7: Download software 



Note

With an SAP HANA SPS you also perform updates for SAP HANA revisions and SAP HANA maintenance revisions. For more information, see SAP Note 2378962 - SAP HANA 2.0 Revision and Maintenance Strategy.



Please refer below link to understand when to upgrade HANA Database 

HANA DB upgrade


UPGRADE PROCESS


1: Change to the following directory on the installation medium:

cd /DATA_UNITS/ HDB_ <select as per OS)

2: Run the SAP HANA database lifecycle manager:
 ./hdblcmgui The SAP HANA database lifecycle manager graphical user interface appears.

3. Select a detected software component or add a software component location by selecting Add Component Location. Then select Next.

4. Select Update Existing System, and choose the SID from the drop-down menu. Then select Next.
 5. Select the components you would like to update, then select Next.

 6. Specify the SAP HANA authorization information.
 When asked for the database user, you have the opportunity to specify a lesser-privileged database user if you have previously created one. For more information about creating a database user for the update, see Related Information.

7. Define additional properties, depending on which components are selected.

8. After specifying all system properties, review the summary, and select Update.


please refer another blogs regarding errors doing upgrade