Skip to Content
Author's profile photo Shaun Wimpory

SAP HANA Installation in Oracle VirtualBox

A very interesting article was bought to my attention about two weeks ago regarding the installation of SAP HANA Platform Edition 1.0 SP05 on a VMware virtual machine (most likely VMware player).  Thus being a SAP HANA enthusiast I decided to undertake the same process using Oracle VirtualBox v4.2.12.  I had been a big fan of VMware player for a long time, but about 2 years ago I switched to VirtualBox (reasons that I won’t get into right now).

So, after finally getting my purchase order approved by my wife, I upgraded my PC to 32GB of RAM and installed SAP HANA PE1.0 SP05 into VirtualBox running SAP SUSE Linux Enterprise Server 11.2.

The installation is relatively straight forward with a couple of minor VirtualBox issues.  The full instructions can be found here thanks to W. Goslinga :

http://scn.sap.com/community/developer-center/hana/blog/2013/05/08/how-to-install-the-hana-server-software-on-a-virtual-machine

The key quirks with VirtualBox were:

  1. You need to enable the CMPXCHG16B instruction after you have created the guest in VirtualBox.  Without the CMPXCHG16B instruction enabled the HANA installation will fail.
  2. VirtualBox with SUSE 11.2 running on my Intel i7 reported the number of CPU sockets as 0.  Thus the HANA hardware check would fail with a divide by 0 error and terminate the installation regardless of the IDSPISPOPD environment variable.  I manually updated the HanaHwCheck.py shell script and forced the number of sockets to 1.
  3. One last issue, I had the HANA media sitting on a different VM and had NFS mounted the filesystem to my HANA host.  I had a number of packages that failed to “untar” during the installation until I mounted the NFS share as a “rw,hard,intr” mount.  Obviously the NFS soft mount wasn’t playing nice over my internal network.

Technical bits:

1.  cd <virtualbox install dir>; VBoxManage setextradata [vmname]|global VBoxInternal/CPUM/CMPXCHG16B 1

2.  vi <path to HANA media>/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server/HanaHwCheck.py

  • comment out the line > self.HWInfo[‘CPU Sockets’]=len(lines)-1
  • insert line > self.HWInfo[‘CPU Sockets’]=1               (or set the value to the actual number of sockets you have)

3.  If using an NFS mount ensure its set to a “hard” mount eg: vi /etc/fstab

<nfshost>:/software /software nfs rw,hard,intr 0 0

Below is a screen shot of SAP HANA Studio directly after I finished the installation of HANA.

Studio-Admin.GIF

I plan to post a YouTube video of the installation process shortly.  The session will cover the full life cycle from VirtualBox guest creation including network config, through to the completion of the HANA installation.  We’ll also install SAP HANA Studio on the physical PC and connect to the HANA backend.  Stay tuned.

Youtube videos now available!

Part 1 – SUSE installation – http://lnkd.in/bw7_yxB

Part 2 – HANA installation –http://lnkd.in/bWfhTax

Part 3 – NW 7.4 on HANA installation – coming soon!

Assigned tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Shaun,

      very interesting and useful blog, thank you.

      The youtube video of the whole process will be very cool.

      All the best,

      Andy.

      Author's profile photo Former Member
      Former Member

      Hi Shaun,

      Nice work.

      Have you tried HANA on a bare metal PC and if so what were the results?

      Regards,

      Ramesh

      Author's profile photo Shaun Wimpory
      Shaun Wimpory
      Blog Post Author

      Hi Ramesh,

      A bare metal PC should be no different ... thats just HANA PE 😉

      You will need to ensure your PC is Intel however and not AMD.

      The reason for investigating HANA in a VM is primarily for consultant portability for PoC/development purposes.

      Regards

      Shaun

      Author's profile photo Former Member
      Former Member

      OK thanks and yes indeed the PC must have Intel Xeon chipset.

      Regards,

      Ramesh

      Author's profile photo Shaun Wimpory
      Shaun Wimpory
      Blog Post Author

      Hi Ramesh ... the PC does not need a Xeon chipset ... the IDSPISPOPD environment variable allows you to bypass this check.

      Author's profile photo Shaun Wimpory
      Shaun Wimpory
      Blog Post Author

      Youtube clips now available ... see the above post for the links! 🙂

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj

      Hi Shaun,

      Nice stuff and thanks for posting Youtube Videos

      Regards,

      Vivek

      Author's profile photo Matthias Nott
      Matthias Nott

      Good instructions. One issue over here: %sy goes up to crazy levels like 70%, and never go down. Makes the system quite unusable.

      Author's profile photo Stephanie Lewellen
      Stephanie Lewellen

      Great information! I also test in a VM, but not on VirtualBox (although, I am also a VirtualBox enthusiast).

      Have you tried installing SPS 07 with hdblcm(gui)? I would be interested in your experience!

      Author's profile photo Shaun Wimpory
      Shaun Wimpory
      Blog Post Author

      Hi Stephanie, no I haven't attempted this yet.  Will add it to my to-do list and let you know how I get on (might make another YouTube clip of it).

      Author's profile photo Former Member
      Former Member

      Great information!

      Have you tried installing SPS 07 with hdblcm(gui)? I would be interested in your experience!