Today, I would like to show you how to make a SAP HANA SPS 7 installation within the AWS cloud.

You should be aware that currently, Amazon only provides SAP HANA Revision 68 as a ready to go installation image. This tutorial thoroughly explains how you can reinstall SAP HANA SPS 7 by yourself in order to replace your old version.

Launching an instance


First, we will install a SUSE Linux Enterprise Server 11 Service Pack 3 64-bit, sized m2.4xlarge with 68.4 GB storage space.


/wp-content/uploads/2014/04/aws1_427896.jpg


/wp-content/uploads/2014/04/aws2_427897.jpg


/wp-content/uploads/2014/04/aws3_427916.jpg


Choose your corresponding Availability Zone. Activating the checkbox Enable termination protection makes it impossible to accidentally delete

this instance.


/wp-content/uploads/2014/04/aws4_427917.jpg


Four volumes  (in my case with 68 GB storage space) must be added.


/wp-content/uploads/2014/04/aws5_428076.jpg


Choose the following sizes:


/wp-content/uploads/2014/04/storage_427934.jpg


Name your instance, e.g. “SAP HANA SPS7”.


/wp-content/uploads/2014/04/aws6_427926.jpg


If you formerly already had an AWS instance, you can use the same Security Group ID as before. Otherwise you can create a new one:


/wp-content/uploads/2014/04/aws7_427936.jpg


After reviewing your data one more time, you are ready to launch your instance.


/wp-content/uploads/2014/04/aws8_427943.jpg


For accessing the operating system via SSH, you can keep using your current key pairs. Should you not have one yet, then you must create one now.


/wp-content/uploads/2014/04/aws9_427944.jpg


/wp-content/uploads/2014/04/aws10_427945.jpg


Success! Your instance is now up and running!


/wp-content/uploads/2014/04/aws11_427949.jpg


Preparing an instance


Please log in as root user and create the following directories:

mkdir /hana

mkdir /hana/shared

mkdir /usr/sap

mkdir /hana/data

mkdir /hana/data/HDB

mkdir /hana/log

mkdir /hana/log/HDB


/wp-content/uploads/2014/04/con1_427954.jpg

With the following command, we will format our 4 volumes with the ext3 file system (proceed with “y”):

mkfs -t ext3/dev/sdb

Proceed this way to format the remaining volumes:

mkfs -t ext3/dev/sdc

mkfs -t ext3/dev/sdd

mkfs -t ext3/dev/sde


Next, we will edit the file  vi/etc/fstab and add the following values, so our volumes will be automatically mounted every time we restart our system. With this, we will achieve that they always will be available as soon as we log in.

/dev/sdb             /usr/sap             ext3       defaults              0 0

/dev/sdc             /hana/data           ext3       defaults              0 0

/dev/sdd             /hana/log            ext3       defaults              0 0

/dev/sde             /hana/shared         ext3       defaults              0 0


/wp-content/uploads/2014/04/con6_427960.jpg

With the command mount -a, all volumes displayed within fstab will automatically be mounted. Should you need to know and/or check, which volumes you have created and where they have been mounted to, you can use the df -h command for that:


/wp-content/uploads/2014/04/con7_427991.jpg


For the rest of the process, a Java package will be required. You can easily install it on your Linux machine using the following commands:

wget http://javadl.sun.com/webapps/download/AutoDL?BundleId=83375


mv “FILE_NAME” java-linux-x64.rpm


/wp-content/uploads/2014/04/con8_427992.jpg

Next, type in the following command in order to start unpacking your Java package:

rpm -ivh java-linux-x64.rpm


/wp-content/uploads/2014/04/con9_428003.jpg


It is up to you whether you would like to download and decompress the data on a Windows machine or a Linux machine. Keep in mind, though, that the decompressed data must be readily available on your Suse Linux machine.

Within the Marketplace, we download the 10 RAR files – for instance on a Windows machine – and decompress these. For this, you will need a decompression tool such as WinRAR or 7-Zip.


/wp-content/uploads/2014/04/rar1_428004.jpg


The decompressed files can now be transferred to our SUSE server e.g. via SFTP:


/wp-content/uploads/2014/04/rar2_428005.jpg


Switch to the directory *DATA_UNITS/HDB_SERVER_LINUX_X86_64 and make the data executable with the following commands:

find -name  hdbinst   -exec chmod 744 {} +
find -name  hdbsetup  -exec chmod 744 {} +

find -name  hdbuninst -exec chmod 744 {} +
find -name  sdbrun    -exec chmod 744 {} +


/wp-content/uploads/2014/04/lin1_428071.jpg


In order to prevent the installation from aborting due to a hardware check, we must deactivate this functionality. Please note that the code below can only be deployed if you have the scripting language Python on your machine. I will just “guess” that you already have Python on your machine:


export IDSPISPOPD=”1″

python

>>> import os

>>> ‘IDSPISPOPD’ in os.environ.keys()

True

>>> quit()

 

/wp-content/uploads/2014/04/lin2_428019.jpg


Please make the file hdblcm within the subdirectory /HDB_LCM_LINUX_X86_64 executable:

chmod 744 hdblcm


/wp-content/uploads/2014/04/lin3_428029.jpg

Begin installation. Type in:

./hdblcm


/wp-content/uploads/2014/04/lin4_428033.jpg

/wp-content/uploads/2014/04/lin5_428034.jpg

Please check the generated log file for warnings and errors.

Now, we shall rename our instance: for this, you will need to edit the hosts file:

vi /etc/hosts

Next, you will need to add the following line:

127.0.0.1 imdbhdb


/wp-content/uploads/2014/04/lin9_428042.jpg

To rename our file, we must switch back to the following directory:

cd /usr/sap/HDB/SYS/global/hdb/install/bin


Rename your file:

./hdbrename -hostmap ALTERNATE=imdbhdb


/wp-content/uploads/2014/04/lin10_428044.jpg


Congratulations! You now have SAP HANA up and running on your computer!
Should you have any further questions or comments, I would be happy to hear from you.

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Gregory Misiorek

    Hi Wolfgang,

    cal has ver72 available and scn has ver73, so not sure why trying ver68. good tutorial, though, if either source becomes unavailable for some reason.

    thx,

    greg

    (0) 
    1. Wolfgang Muehlhofer Post author

      Hi Greg, thank you for your comment. The article was originally created in January with Version 70 and it was my first article so it took me a while. I think with Version 73 is should be similar.

      (0) 
  2. Ritesh sharma

    Hi Wolfgang,

    I succesfully installed HANA on AWS but i am seeing 2 issues.

    1. In HANA studio, its shows yellow icon in system saying some services are not started.

    2. I am not able to start LCM from HANA studio, its gives error.

    Did you also see these errors after installation?how did you fix them

    Regards,

    RVS

    (0) 

Leave a Reply