SAP HANA Lifecycle Manager !!!

SAP HANA Lifecycle Manager
SAP HLM by default will get installed together with HANA platform SPS06 installation and I’ll give a brief walkthrough on how to access, to start and to install HLM on HANA platform lower than rev60.

 

 

a) to access HLM:

• via browser: https://fqdn:1129/lmsl/HLM/SID/ui/?sid=SID
• via Hana Studio rev60 -> Lifecycle management
• via command -> /hana/shared/SID/HLM/hlmcli/hlmcli.sh --sid --sidadm_pwd - --help

 

Before you can access HLM, you need to ensure HLM is running on the server by ps -ef | grep -i HLM and you’ll get something return as below:


SIDadm   25882 25598  0 15:05 ?        00:00:00 /bin/bash /usr/sap/hlm_bootstraps/start-hlm.sh SID
SIDadm   25948 25882  0 15:05 ?        00:00:00 bash /usr/sap/SID/HDB10/../HLM/bootstrap-hlm.sh
SIDadm   25971 25948  0 15:05 ?        00:00:00 /bin/bash /usr/sap/hlm_bootstraps/SID/HLM/hlm.sh
SIDadm   26009 25971  0 15:05 ?        00:00:00 /bin/bash ./daemon.sh console -Dhlm.nonssl.port=51000 -Dhlm.installation.path=/hana/shared/SID/HLM -Dhlm.bootstrap.path=/usr/sap/hlm_bootstraps/SID/HLM -Dlogback.configurationFile=/usr/sap/hlm_bootstraps/SID/HLM/configuration/serviceability.xml -Dosgi.resolver.usesMode=ignore
SIDadm   26163 26009  0 15:05 ?        00:00:00 /bin/bash -c cd "/usr/sap/hlm_bootstraps/SID/HLM" ; "/usr/sap/hlm_bootstraps/SID/HLM/jvm/jre/bin/java" -server -XtraceFile=log/vm_@PID_trace.log -XX:ErrorFile=/usr/sap/hlm_bootstraps/SID/HLMserviceabilityerror.log -XX:HeapDumpPath=/usr/sap/hlm_bootstraps/SID/HLM/serviceability/heap_dump.hprof "-XX:+HeapDumpOnOutOfMemoryError" "-XX:+DisableExplicitGC" "-Xms512m" "-Xmx1024m" "-XX:PermSize=256M" "-XX:MaxPermSize=256M" "-Dosgi.requiredJavaVersion=1.6" "-DuseNaming=osgi" "-Dosgi.install.area=." "-Djava.io.tmpdir=./work/tmp" "-Djava.endorsed.dirs=lib/endorsed" "-Dorg.eclipse.equinox.simpleconfigurator.exclusiveInstallation=false" "-Dcom.sap.core.process=ljs_node" "-Declipse.ignoreApp=true" "-Dosgi.noShutdown=true" "-Dosgi.framework.activeThreadType=normal" "-Dosgi.embedded.cleanupOnSave=true" "-Dosgi.usesLimit=30" "-Dcatalina.config=file:config/catalina.properties" "-Dhttp.hostcontrol.connection" -classpath /usr/sap/hlm_bootstraps/SID/HLM/plugins/org.eclipse.equinox.launcher_1.3.0.v20120308-1358.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.nano.authentication_3.6.0.RC1.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.nano.shutdown_3.6.0.RC1.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.util.env_3.6.0.RC1.jar -Dhlm.nonssl.port=51000 -Dhlm.installation.path=/hana/shared/SID/HLM -Dhlm.bootstrap.path=/usr/sap/hlm_bootstraps/SID/HLM -Dlogback.configurationFile=/usr/sap/hlm_bootstraps/SID/HLM/configuration/serviceability.xml -Dosgi.resolver.usesMode=ignore org.eclipse.equinox.launcher.Main -console 2>>"/usr/sap/hlm_bootstraps/SID/HLM/hlm_daemon.log"
SIDadm   26164 26163  6 15:05 ?        00:01:11 /usr/sap/hlm_bootstraps/SID/HLM/jvm/jre/bin/java -classpath /usr/sap/hlm_bootstraps/SID/HLM/plugins/org.eclipse.equinox.launcher_1.3.0.v20120308-1358.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.nano.authentication_3.6.0.RC1.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.nano.shutdown_3.6.0.RC1.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.util.env_3.6.0.RC1.jar -server -XtraceFile=log/vm_@PID_trace.log -XX:ErrorFile=/usr/sap/hlm_bootstraps/SID/HLMserviceabilityerror.log -XX:HeapDumpPath=/usr/sap/hlm_bootstraps/SID/HLM/serviceability/heap_dump.hprof -XX:+HeapDumpOnOutOfMemoryError -XX:+DisableExplicitGC -Xms512m -Xmx1024m -XX:PermSize=256M -XX:MaxPermSize=256M -Dosgi.requiredJavaVersion=1.6 -DuseNaming=osgi -Dosgi.install.area=. -Djava.io.tmpdir=./work/tmp -Djava.endorsed.dirs=lib/endorsed -Dorg.eclipse.equinox.simpleconfigurator.exclusiveInstallation=false -Dcom.sap.core.process=ljs_node -Declipse.ignoreApp=true -Dosgi.noShutdown=true -Dosgi.framework.activeThreadType=normal -Dosgi.embedded.cleanupOnSave=true -Dosgi.usesLimit=30 -Dcatalina.config=file:config/catalina.properties -Dhttp.hostcontrol.connection -Dhlm.nonssl.port=51000 -Dhlm.installation.path=/hana/shared/SID/HLM -Dhlm.bootstrap.path=/usr/sap/hlm_bootstraps/SID/HLM -Dlogback.configurationFile=/usr/sap/hlm_bootstraps/SID/HLM/configuration/serviceability.xml -Dosgi.resolver.usesMode=ignore org.eclipse.equinox.launcher.Main -console

 

b) If nothing returns, start HLM:


/hana/shared//HLM/bootstrap-hlm.sh


If folder /HLM don’t exist on the server, means HLM is not installed on the server.


c) to install HLM:


via HANA studio rev60 by using SUM4HANA.
I’ll skip this method where the steps are just similar when performing HANA DB revision update using SUM4HANA.

 

Manual Installation:
i) download SAPHANALM06_0-10012745.SAR or latest from SMP
ii) extract it to temp directory, eg: HLM_install
iii) copy SAPHANALM06_0-10012745.SAR to the temp directory where you extracted the SAR earlier, eg: HLM_install as the SAR is needed during installation.
iv) Ensure SAPHOSTAGENT is above level 149, advisable to update it to the latest level. Level 153 till today.
v) go to the extracted temp directory and run ./hdbinst
Just click enter when prompt if you are running single Hana Database.


SAP HANA Lifecycle Manager Installation kit detected.
SAP HANA Database Installation Manager - SAP HANA HLM Installation 1.50.00.000000
*********************************************************************************
Options:
  SAP HANA system ID | Description
---------------------------------------------------------
  SID                | SAP HANA Database SID 1.00.57.378530
Enter SAP HANA system ID [SID]:
Root user password (SSH connectivity):
Root user SSH key passphrase (SSH connectivity):

 

 

The installation will complete in jiffy and now, enjoy using HLM!

Setup and Configure a SAP Hana Dynamic Tiering...!!!

I’ll explain how to setup and configure a SAP Hana Dynamic Tiering scenario in my test environment. I will show in detail step and configuration point to achieve this configuration.

 

For my HDT test case I’ll use my own lab on Vmware Vsphere 5.1.0 and run Hana revision 91, I’ll reuse my existing environment setup in my previous documentation.

 

Disclaimer:  this is a personal documentation for test purpose; I will take in consideration the sizing for DT.

 

In order execution

 

• Download Hana DT media
• Prepare DT specific filesystem
• Install DT component
• Add new host for DT worker
• Configure DT storage
• Monitoring of DT in hana cockpit

 

Guide used

 

SAP Hana Dynamic Tiering Administration Guide SP9
SAP Hana Dynamic Tiering Operation

 

Note used

 

2140959 - SAP HANA dynamic tiering - additional information
2086829 - SAP HANA DT: Sizing of Dynamic Tiering component of SAP HANA

 

Link used

 

http://help.sap.com/hana_platform
 

 

Overview Architecture

 

In my previous documentation “SAP Hana TDI setup - VMware 5.1” I have explain and setup different scenario of Hana deployment, I’ll reuse my master hana system “hana01” and create a new host from template to add it as “Hana DT worker” host.
 

 

Download Hana DT media

 

In order to install Hana DT specific media needs to be download, those media can be download unde :
“Install & Upgrade -> Hana Platform Edition -> SAP Hana Dynamic Tiering”

 

Once downloaded, I unzip the file and place the media in my repository

 

 

Prepare DT specific filesystem

 

Before to start with the setup of Hana DT, specifics filesystem needs to be mounted on the hosts

 

Make sure the folder SID exist under “/hana/data_es/” before to run the installer.

 

 
Install DT component

 

Now that the media and the filesystem are ready it’s time to deploy the DT component on the master node.
The deployment can be performed in 3 different ways:

 

Using the command line tool “hdblcm” by choosing option 9 under “/hana/shared/HB1/hdblcm”

 

Using the graphical tool “hdblcmgui” under under “/hana/shared/HB1/hdblcm”

 

And finally by the web over “Hana Lifecycle Management”

 

For my document I’ll use the web option

 

I specify my DT component folder with sub folder







Installation done

 

 
Add new host for DT worker

 

Now completed we need to install the additional host which will be used as “Hana DT worker”, to do this we can use “hdblcm” or “hdblcmgui” option.

 

I’ll go by the hdblcmgui option:

 

I want to use all my NIC so I keep the Global option

 

Review and launch
Done

 

  

Configure DT storage

 

The new worker host deployed we can check on hana studio to validate

 

On the overview dashboard we can see now that DT has been installed but still need to be configured

 

Do perform it we need to do it over the Hana cockpit, but before the dynamic role needs to be assign

 

Once assigned, add the necessary dashboard in the cockpit

 

I define my storage size for my Extended Table and hit create

  

Done
Note: the configuration can be change to extend disk size to meet requirements

 

Now check hana studio

 

 
Monitoring of DT in HANA cockpit

 

The monitoring of DT is done over the cockpit, its straight forward

 

The configuration is completed.

How to Install SAP Hana SP10 on a Linux Red Hat 6.6.

In my documentation I’ll explain how to install SAP Hana SP10 on a Linux Red Hat 6.6 system in my test environment.

 

I will show in detail step and configuration point to achieve it.

 

For my setup I’ll use my own lab on Vmware Vsphere 5.1.0 and run Hana revision 101, I’ll reuse my existing environment setup in my previous documentation.

 

In order execution

• Download Red Hat 6.6 release
• Install the minimal RHEL
• Configure RHEL
• SAP Hana installation

 

Guide used

 

Red Hat Enterprise Linux (RHEL) 6.x Configuration Guide for SAP HANA
SAP HANA Master Guide

 

Note used

 

SAP Note 171356 - SAP Software on Linux: General information
SAP Note 2009879 - SAP HANA Guidelines for Red Hat Enterprise Linux (RHEL) Operating System
SAP Note 1496410 - Red Hat Enterprise Linux 6.x: Installation and Upgrade
SAP Note 2136965 - SAP HANA DB: Recommended OS settings for RHEL 6.6
SAP Note 2001528 - Linux: SAP HANA Database SPS 08 revision 80 (or higher) on RHEL 6 or SLES 1

 

Link used

 

Red Hat Enterprise Linux for SAP HANA: system updates and supportability
Help SAP Hana
RedHat access documentation

 

Overview Architecture

 

In my previous documentation “SAP Hana TDI setup - VMware 5.1” I have explain and setup different scenario of Hana deployment, I’ll use same proceed to create my vm and template for reuse later.

 

 

Download Red Hat 6.6 release

 

In order to be able to download Red Hat dvds you must first register

 

Once done, validate your account and download the necessary media

 

Now downloaded I store it in my datastore

 

 

 

Install the minimal RHEL

 

My vm ready and my dvd ready I start to install the base Red Hat system

 

 

 

 

 

Make sure the automatic connection to the network card is enabled

 

Set the time zone and system clock according your location

 

 

I choose the first option since my system is just about to be created

 

 

Choose minimal option

 

Installation in progress

 

Installation completed

 

 

Configure RHEL

 

The base installation is now over the system needs to be compliant to host SAP Hana, the configuration consist of the following activities:

 

•    Subscribe your system to Red Hat channels
•    Install the base package group and xfs tools
•    Create the /usr/sap/ storage for SAP HANA.
•    Mount the file system for SAP HANA instance
•    Install dependencies package for Hana
•    Install the SAP Java Virtual Machine or IcedTea
•    Disable SELinux in /etc/sysconfig/selinux
•    Install and configure the package tuned-profiles-sap-hana
•    Configure the profile for vmware
•    Set the parameters in /etc/sysctl.conf
•    Set the symbolic links
•    Add the kernel command line argument for crash huge page
•    Omit the application crash and core file handling of the operating system

 

 

 

 

Subscribe your system to Red Hat channels

 

In order to be able download patch, package and so on, the system must be register against Redhat by subscription, but in order to have SAP Hana specific package for RedHat you need to be register in “Partner center” and join as an existing partner company or apply for partnership

 

Once the registration fully completed and approved (it takes few days), run the subscription manager on your system

 

And list all the available production available for you, you must have “Red Hat Enterprise Linux for SAP Hana” listed

 

Attach the subscription to your pool ID (this information is system dependent)

 

Run the subscription release

 

Disable all existing repositories

 

And finally enable on “Hana’ repositories

 

 

Install base package group and xfs tools

 

 

Create /usr/sap storage for SAP Hana

 

From my ESXi host I did add another volume to my RedHat server in order to create “/usr/sap/” file system.
I check now by “lsblk –f” command of my new volume is there

 

Let’s create my physical volume by “pvcreate /dev/sdb” command

 

Now create the new volume group by “vgcreate new_volume /dev/sdb” and run the command “vgs” to check

 

The VG available with 50gb of space I’m creating now my logical volume with only 40gb of space in order to keep some room on my disk

 

And finally I create my physical file system and mount it

 

Result

 

 

Mount the file system for SAP HANA instance

 

The next phase will be to add the nfs mount point from my NAS server to RedHat for Hana by editing the fstab
Do not for forget to install nfs package by “ yum groupinstall "Network file system client"”

 

Once done “mount –a” and check

 

 

Install dependencies package for Hana

 

Like in SLES environment, RHEL needs to have specific package dependency in order to deploy Hana.

 

Install the SAP Java Virtual Machine or IcedTea

 

Disable SELinux in /etc/sysconfig/selinux

 

Install and configure the package tuned-profiles-sap-hana from the RHEL for SAP HANA channel to minimize latencies

 

For Hana running on VMware

 

Set the parameters in /etc/sysctl.conf

 

Set the symbolic link for compatibility reason

 

Add the kernel command line argument for crash huge page by editing /boot/grub/grub.conf file

 

Omit the application crash and core file handling of the operating system

 

This completed for the system preparation in order to install SAP Hana, I can proceed to the next section

 

 

 

SAP Hana installation

 

We are ready now to install SAP Hana and it’s like running it on SLES, so no surprise.
I’ll go by the hdblcmgui to run the install because a specific string is required as you can see in the red square below.

 

That’s it, Red Hat is very specific regarding package so do not missed any step.