Skip to Content
Technical Articles
Author's profile photo Denys van Kempen

SAP HANA 2.0 Server Installation – by the SAP HANA Academy

Update November 2020

For the latest information about SAP HANA 2.0 SPS 05, see

For just the highlights, see

For information about how to get to the latest release, see

Any good? Post a comment, share on social media, and/or give a like. Thanks!

/wp-content/uploads/2016/02/sapnwabline_885687.png

Introduction

Recently, we have updated a number of SAP HANA Academy tutorial videos for the playlist

In this blog, I will provide some references and background information for the server installation and update videos of the series.

This blog is part of a series:

 

SAP HANA Academy – SAP HANA Installation and Update (YouTube Playlist)

 

Tutorial Video

SAP HANA Academy – SAP HANA Server

 

SAP HANA Server Supported Platforms

The SAP HANA server is supported on two Linux platforms with enterprise support:

You can run these enterprise versions on both Intel 64-bit and the IBM Power Systems (LE) architectures.

For a complete list of supported hardware/software configurations, see the hardware directory.

To verify if your system runs a supported hardware configuration, you can use the check tool included with the SAP HANA platform distribution:

For the latest technical release information about supported platforms, always check the Product Availability Matrix (PAM) on the SAP Support Portal:

 

If you are new to PAM, see our introductory tutorial video about PAM.

SAP HANA Academy – Product Availability Matrix (PAM)

 

Please Note

SAP has published several Knowledge Bases Articles (KBA’s) on the SAP ONE Support portal. The list below provides a starting point and is not complete.

Additionally, there are dedicated support notes for each operating system version with recommended settings, e.g. for SLES 11 SP2, SP3, etc.

A configuration guide in PDF format is attached to the notes with guidelines. These guides are not available on the SAP Help Portal for the SAP HANA platform.

Configuration Guide

 

Software Download

You can download the SAP HANA 2.0 platform edition from the SAP ONE Support Portal. How this works and how to distinguish the main Support Package Stack (SPS) release from subsequent revisions is the topic of the download video.

SAP HANA Academy – Download SAP HANA 2.0 SPS 02 + latest revision 

 

Typically, the SAP HANA server will be a minimal install for security purposes (hardened) with no graphical environment and, most likely, with secured access for inbound access for administration purposes. Downloading software directly to the Linux server, for that reason, will be a very unlikely scenario.

Should you have downloaded the full SPS release to a Windows computer and struggle to get the zip files to the HANA server, you might find the next tutorial of interest. Here we show how you can upload the files using PuTTY Secure Copy (PSCP) from a Windows PC to the HANA Linux server.

SAP HANA Academy – Secure File Copy with PSCP

 

SAP HANA Server Installation

Once you have prepared the environment and transferred the download to the server, installing the SAP HANA server is very easy.

The tool to use is the SAP HANA Database Lifecycle Manager, ‘hdblcm’ on the command-line. A windows version is also available, ‘hdblcmgui’. However, as most HANA systems will not have a graphical environment, you will not be using the version very often. The web version,’hdblcmweb’, can be used for updates, not for an initial installation.

You might also have noticed ‘hdbinst’, ‘hdbuninst’, ‘hdbupd’ and ‘hdbsetup’. These are the tools that the lifecycle manager calls to perform the particular platform LCM action. When performing an SAP HANA server installation, you should use hdblcm and not any of the stand-alone tools. When installing the SAP HANA client, for example, on another system, using hdbinst or hdbsetup is perfectly fine. HDBLCM is only available for server installations.

For more information, see

 

Here we are running ‘hdblcm’ from the HDB_SERVER_LINUC_X86-64 directory directly, Alternatively, we could have used the included Lifecycle Manager from HDB_LCM_LINUX_X86_64.

hdblcm

 

On the first screen, the Lifecycle Management tool will display detected components. These are all the components which you can install together with the (database) server. Should the list be empty, you can use the call option –component_root=<path> or –component_medium=<path> to specify to the installer the location of the installation media (download).

hdblcm: Choose an action

 

The next screen, you are prompted to provide a comma-separated list of the components you want to install. The full SPS 02 release includes the SAP HANA client, SAP HANA studio, Smart Data Access (SDA) for data virtualization, SAP HANA XS Advanced (XS Classic is included by default), SAP HANA AFL (Application Function Library) and EML (External Machine Language Libary) and, to enable access for SAP Analytics Cloud, Lumira and other EPM tools, the EPM-MDS plugin.

hdblcm: Select component

 

Next, you will be prompted to provide the installation path with the default mount point ‘/hana/shared‘ provided. For this, see the topic

SAP HANA is designed to scale and it is incredibly easy to create a distributed system (what other vendors might call a cluster) because the file layout is exactly the same. The program files (binaries), data files and (redo) log files are all stored in a location, a mount point, that is intended to be shared across multiple instances. Only files that are relevant to the local installation like server trace and log files, server-specific configuration files, etc. are stored on the local file system which defaults to ‘/usr/sap‘.

 

After entering the installation path and, typically, accepting the value for the local hostname, you will also be prompted if you want to add more hosts. This is where you add the hana2 and hana3 below and this is the only difference between installing SAP HANA on a single server or installing on 3, 5 or 20 servers. Amazing!

Next, you are prompted to enter the SAP System ID (SID) and instance number. The SID must be three alphanumeric characters with uppercase letters and start with a letter with some restrictions: SAP or SID are off-limits. The SID must be unique throughout your organization. Choose with care, as the SID will be included in several configuration items and changing the SID will require downtime.

The instance number must be a two-digit number between 00 and 97. In a distributed system, both SID and instance number will be the same.

  • sid – SAP HANA Server Installation and Update Guide

Next, you are prompted to provide the worker group of the server (localhost). The default value is ‘default’ which will also be the most common value used here for this parameter. Alternative values are, for example, ‘standby’, ‘extended_storage_worker’ (for Dynamic Tiering), ‘xs_worker’ (for XS Advanced), etc.

Next, you are prompted to select the ‘system usage’ with ‘custom’ default value. Only when selecting ‘Production’, this parameter has an effect on the behavior of certain client tools. For example, the system will automatically be added to the Production group of SAP HANA cockpit, and, when executing SQL, a warning will be triggered. The value will be stored in a system parameter and can easily be modified after the installation: global.ini > [system_information] > usage

hdblcm: continued

Data and log volumes default to the same shared mount point location with the SID appended.

For non-productive usage, you can install multiple HANA systems on a single host (assuming enough memory is available to support such a configuration). In this case, you might want to restrict the maximum memory allocation. Another reason might be that you have licensed SAP HANA for x GB whereas the server has y GB of RAM. Again, this is governed by a system parameter: global.ini > [memorymanager] > global_allocation_limit

Next, you will be prompted for the certificate hostname for the server. This is where you specify how the HANA server will be known on the internet (or intranet), the public name. This way, when you connect with SAP Web IDE for SAP HANA to http://mydevelopdb.myorgname.com you will not get any invalid hostname certificate warning when the actual hostname is AXY5676.dummydomain.

Certificates: There is a problem

 

Next, you will be prompted to enter the password for the operating system administration account, <sid>adm. This is a local Linux account. You can change the password at any time using the Linux ‘passwd’ command. The Linux password policy defines what are valid entries and what not.

The system administrator home directory, login shell, and user ID default values are perfectly fine for 99% of the installation scenarios. The Linux user ID needs to be the same on all hosts of a distributed system and starts at 1000 for the next available ID. Assuming all hosts of a distributed system are the same, this will not be an issue but should, on one of the systems, additional users have been created, you might want to start at a higher number, e.g. 7000.

You will also be prompted to enter the password for the database superuser SYSTEM. This will be the password for both the system database and the default <SID> tenant database. Here the SAP HANA password policy applies, default: [Aa1], 1 uppercase and 1 lowercase letter and one digit.

For productive environments, SAP recommends to deactivate the SYSTEM user and to create lesser privileged users for particular purposes:

 

hdblcm: continued

 

Finally, you will be prompted if you want the SAP HANA database to start when the operating system starts (the actual question is ‘Restart system after machine reboot’ but also covers system startup). This defaults to no, which means that you will have to start the SAP HANA database yourself after Linux has started.

Configuring this behavior afterward is not as straightforward as you might expect. You will need to edit the autostart parameter in the profile. There is no graphical user interface for this.
<sapmnt>/<SID>/profile/<SID>_HDB<instance_number>_<hostname>
When all parameters have been provided, the ominous sounding “Summary before execution” is displayed asking you if you want to proceed or not.

hdblcm: Do you want to continue (y/n)

 

On Your Mark, Get Set, Go!

The actual installation of SAP HANA server is a quick process. The files are extracted (preparing package …), copied to the installation directory (installing package …), after which the system is created and the processes started.

hdblcm: Starting processes

 

For a list of the different SAP HANA services and the role they perform, see

When all processes have started, default content is imported. This concerns web applications for SAP HANA XS, classic method. Some delivery units are only available for downward compatibility reasons and do not contain any content (HANA_ADMIN for SAP HANA cockpit 1.0, for example).

For a complete list of the delivery units, see

Also, note that XS classic (and the hdbxsengine) have been deprecated with the SPS 02 release:

 

hdblcm: Importing Delivery Unit

 

Finally, a resident version of the SAP HANA Database Lifecycle Manager tool is installed. This tool can be used for any subsequent platform lifecycle management tasks like adding hosts or renaming the SID.

We can also see that SAP HANA host agent configurations are deployed. Each SAP HANA server installation includes the SAP HANA host agent.

There is a feedback form to share your experiences and a log file, should any issue have occurred.

 

hdblcm: Log file written to …

 

What’s Up?

With the ‘HDB info’ command you can check the status of the different SAP HANA server processes. The ‘sapstartsrv’ process will have started the hdbdaemon process which, in turn, will have started the system database (hdbnameserver), the tenant database (hdbindexserver) and different supporting processes.

If you want to know how this works exactly, see

 

HDB info

References

For more information see:

SAP HANA Academy Playlists

SAP Downloads

SAP Documentation

SAP Blogs

Notes

Partner

/wp-content/uploads/2016/02/sapnwabline_885687.png

Share and Connect

Questions? Please post as comment.

Useful? Give us a like and share on social media.

Thanks!

If you would like to receive updates, connect with me on

Over the years, for the SAP HANA Academy, SAP’s Partner Innovation Lab, and à titre personnel, I have written a little over 300 posts here for the SAP Community. Some articles only reached a few readers. Others attracted quite a few more.For your reading pleasure and convenience, here is a curated list of posts which somehow managed to pass the 10k-view mile stone and, as sign of current interest, still tickle the counters each month.

/wp-content/uploads/2016/02/sapnwabline_885687.png

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Well studied blog is presented here; it carries explained information that helps the readers with every detail about the subject.

      Author's profile photo Ravikiran Chikati
      Ravikiran Chikati

       

      Denys,

       

      Can you please confirm if we need to first download / install a “base” 2.0 version before applying the lastest SPS02 revision?  Or can you do “fresh installs” from a maintenance release like 2.00.024?

       

      SAP HANA Platform Edition 2.0 SPS02 rev20

       

      IMDB_SERVER20_024_0-80002046.SAR Revision 2.00.024.00 (SPS02) for HANA DB 2.0

       

      Thanks

      Ravi

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Ravi,

      Each SAP HANA server installation (or any other component) is a full installation. There is no notion of a delta update (like Microsoft Windows Service Packs, for example) for SAP HANA.
      Does this answer your question?
      Thanks,
      Denys / SAP HANA Academy

       

      Author's profile photo Ravikiran Chikati
      Ravikiran Chikati

      Denys,

      Thank you

      I am installing HANA cockpit SAP HANA Cockpit 2.0.5.5.0 on server where I am having another HANA system which is version 2.00.021.00.

      During the installation process I have observed it is installing SAP HANA Database Install version 2.00.023.00.1513691289. I am not sure why it is trying to install HANA version as well ?

      Thanks

      Ravi

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Ravi,

      SAP HANA Cockpit 2.0 is a collection of XSA applications and services running on a dedicated SAP HANA (express) system. That's why.

      You might find my blog (with videos) interesting as here this is explained in some detail.

      Best,

      Denys / SAP HANA Academy

      Author's profile photo Ravikiran Chikati
      Ravikiran Chikati

       

      Denys,

      Can we restore HANA 1.0 SPS12 single container database ( 4 nodes) to HANA 2.0 SPS02 (3 nodes)? Tried to find SAP notes not able to get correct one.

      Thanks

      Ravi

       

       

       

      Author's profile photo Ravikiran Chikati
      Ravikiran Chikati

       

      Denys,

       

      We are in the process of installing HANA 2.0 SPS02 system( scale out 3 +1 nodes) along with Dynamic Teiring host.

       

      Customer has a HANA 1.0 SPS12 system with 4 +1 nodes without DT node.

       

      After the installation we are planning to restore HANA 1.0 SPS12 with 4 nodes to target HANA system 2.0 SPS02 with (3+1) nodes with Dynamic Teiring host.

       

      I found below note for creation of additional services etc. My question is what about esservice which exist on target tenant DB ? One of the prerequisite is “Check if the number of active services on the target system match with that of the source system”.

       

       

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

       

      2093572 - SAP HANA Migration from Multi-Node to Single-Node

       

      Thanks

      Ravi

       

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Ravi,

      From the response to your question posted on SAPJam on the HANA High Availability Community, I understand that this should be possible if you take into consideration

      and follow the description from

       

      Author's profile photo Ravikiran Chikati
      Ravikiran Chikati

      Denys,

       

      I was able to restore successfully to HANA SPS 03.

      Thanks

      Ravi

      Author's profile photo Rebaz Salih
      Rebaz Salih

      Dear Denys van Kempen,

      Can we install SAP HANA on Windows Server? or its a must to be installed on Linux?

       

      Thank you

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Rebaz,

      You can find this information in the SAP HANA platform SAP HANA Server Installation and Update Guide, section SAP HANA Hardware and Software Requirements

      ==

      Supported Operating Systems for SAP HANA

      For information about supported operating systems for SAP HANA, see SAP Note 2235581 - SAP HANA: Supported Operating Systems

      ==

      The note mentions

      ==

      Supported Operating Systems for SAP HANA

      One of the following Enterprise Linux distribution products, in the below-mentioned version, is required for running SAP HANA:

      • Red Hat Enterprise Linux for SAP Solutions
      • Red Hat Enterprise Linux for SAP HANA
      • SUSE Linux Enterprise Server for SAP Applications
      • SUSE Linux Enterprise Server

      SAP strongly recommends to use "RHEL for SAP Solutions" or "SLES for SAP Applications" due to their features and extended support cycles. For detailed information about the Linux product flavors, their feature set and benefits, please contact your respective Linux sales representative.

      ==

      You can install the SAP HANA client on Windows and, if you insist, for development purposes, run SAP HANA, express edition inside a Docker container (running Linux) on Windows.

      Answers your question?

       

      Author's profile photo Rebaz Salih
      Rebaz Salih

      thats a great answer, thank you very much

      Author's profile photo Rebaz Salih
      Rebaz Salih

      Actually I want to install the demo (SAP Business One 10 For Hana) and I was searching to find if possible and practical to have everything on Windows Server without going to separate operating system for database, but as per your answer and info I read it seems having a Linux server is far better than.