SAP HANA Hands on tests ( part 1 ) : HANA DB installation

Hello,

This is a blog series about some hands on training I’m performing in-house on SAP HANA.

In this 1st part I’m just sharing some information about the installation of the HANA DB in a VMware 5.5 ESXi virtual machine.

As a starting point I followed the requirements found in the these 2 blog posts :

SAP HANA Installation in Oracle VirtualBox

How to install the HANA server software on a virtual machine

And also followed these SAP notes :

http://service.sap.com/sap/support/notes/1944799

http://service.sap.com/sap/support/notes/2001528

http://service.sap.com/sap/support/notes/2000003 ( this one gives a lot of information on different topics regarding SAP HANA )

My configuration is as follows :

“Hardware” : Using a VMware 5.5 esxi VM with

     – 64 Gb of RAM

     – 232Gb for disks ( 32Gb for the OS / 200Gb for the HANA filesystem ).

Note :

if you plan to use the HANA DB standalone, it appears, in my configuration that 28Gb of RAM is o.k .

24Gb appears to be the strict minimum.

As I also installed an ECC6 EHP7 server on the same box, I got into some lack of memory troubles and had to upgrade to 64Gb not to have any issue.

OS : Suse linux SLES 11 SP3.

HANA DB version : 1.00.82.00.394270

Of course, this hardware setup is not certified by SAP and should not be used in production ( or whatsoever customer related anyway 🙂 … ) but will do the trick for “lab” testing purposes.

I won’t go into much details here about the installation process as the 2 blogs metionned above give really good details about it, even if they were performed on previous SAP HANA version.

The main steps are as follows :

1- build up your VM on your VMware ESXi infrastructure.

     Here is the set up I used :

disk 1 :

disk 2 :

2- Start it up and make it boot on the SLES 11 SP3 ISO in order to perform the OS installation.

Follow the SLES installation wizard.

3 – Configure your VM ( OS additionnal requirements / network / File systems )

For the FS layout i followed the one  showed in How to install the HANA server software on a virtual machine .

4 – Install the HANA database

The thing that differs here is that I could use the hdblcm tool.

I used the hana installation DVD : 51048744 .

I used the basic installation parameters as follows :

Note :

For some reasons, the sdbrun and install.sh scripts in the installation material extract were not “executable”.

I had to set the X right on these. Everything ran fine after that.

These are the components that can be installed :

Selected all the components but the hana studio. Depending on the deployment you wish to perform you can choose not to install everything.

Summary screen :

Installation follow up screen :

The end :

Then you have an HANA db ready for test usage !