Thursday, March 23, 2017

HANA Database 1.0 - Update from SPS11 to SPS12

Prerequisites:


1.       You have installed SAP HANA Database 1.0 SPS11
2.       You have installed one of the following OS versions:
SLES 11 (SP3 or SP4)
SLES 12
SLES 12 (SP1)
RHEL 6.7
RHEL 7.2

3.       You have SAP Host Agent version 7.21.11 or newer

Attention! More complete information about supported operation systems, you can find in SAP Note 2235581 – SAP HANA: Supported Operating Systems.
Attention! Before update process has been started, recommended complete backup database.

Update Process:

For update, we will use the SAP HANA database lifecycle manager (hdblcm) in console or native GUI mode. For update, we will use user ROOT !!!
Step 1
Unpack the archive in to the extraction directory, passing the option –manifest SIGNATURE.SMF to SAPCAR

SAPCAR -xvf IMDB_SERVER100_122_7-10009569.SAR -manifest SIGNATURE.SMF

p.s. Another case you will get the following error:

File 'SIGNATURE.SMF' cannot be found in the SAP HANA Database installation kit. You can ignore this error and continue with the execution by passing the ignore option 'check_signature_file' to hdblcm, started as root. See SAP note 2078425, section 'How to prepare SAP HANA packages for installation or update' for instructions how to prepare packages for update or implications of ignoring this error.

Step 2
Run the hdblcm tool. You can find it in the extracted directory (SAP_HANA_DATABASE)


Choose the index number 1
Next, choose the index number 2 (server), and enter password for <sid>adm and SYSTEM users.


After this, we will see summary:


After finished update process, we will get confirm message:

SAP HANA components updated

Attention! Please check the created log file, in our case '/var/tmp/hdb_TST_hdblcm_update_2017-03-16_16.47.30/hdblcm.log' 


Possible Problems:

In update process, you can face with different problems. For example, you have installed an additional components, in our case is AFL (Application Function Libraries), and this component is incompatible with new version on HANA database you will want to install. In result you will get the same error message:


For issues this problem you need reinstallation this component as follows:
       1.  Uninstall the AFL component
You can uninstall components by using hdblcm tool. Start the hdblcm tool by super user (root):

[root@<server_name> ~]# /hana/shared/<SID>/hdblcm/hdblcm

Choose the index number 7 (uninstall) and then choose the component for uninstall (for our case is number 3).



      2.  After uninstallation has been completed, you can continue the update of HANA database.
      3.  After HANA database update process has been completed, you must install additional component uninstalled on step 1:

You can install components by using hdblcm tool. Start the hdblcm tool by super user (root):

[root@<server_name> ~]# /hana/shared/<SID>/hdblcm/hdblcm -component_dirs=<component_dir_path>

Choose the index number 14




Then you choose the component you will want to install. In our case Index 2 and after you will input <sid>adm user password, the component will be installed.


Now, all looks like fine!


Good luck! 

No comments:

Post a Comment