Technical Articles

Roman Gorbenko

September 9, 2020 8 minute read

Installation of SAP HANA Database with Extended Application Service Advanced Model (XSA) in Yandex Cloud

Intro

This blog-post continues a series of publications about the Installation of different SAP Systems in Yandex Cloud

In previous parts:

SAP HANA EXPRESS EDITION in Yandex Cloud. Binary Installation. Step-by-step guide

https://blogs.sap.com/2019/11/29/sap-hana-express-edition-in-yandex-cloud.-binary-installation.-step-by-step-guide/

SAP NetWeaver AS ABAP Developer Edition 7.52 SP04 in Yandex Cloud. Binary Installation. Step-by-step guide

https://blogs.sap.com/2019/12/15/sap-netweaver-as-abap-developer-edition-7.52-sp04-in-yandex-cloud.-binary-installation.-step-by-step-guide/

SAP NetWeaver AS ABAP Developer Edition 7.52 SP04 in Yandex Cloud. Binary Installation. Extended version on the Russian language

https://cloud.yandex.ru/blog/posts/2020/01/sap

Resolution

Step 1. Media downloads

Go to the download page for SAP HANA, express edition

and if you do not have an account in SAP, you need to go through a simple registration.

Download and run SAP HANA Express Edition Download Manager (java app)

Download parameters:

Platform– Linux/x86 – 64

Image – Binary Installer

Package – Applications*

* – Applications means SAP HANA database, application server, and development environment SAP HANA Extended Application Services, Advanced Model (XSA)

Step 2. Create a virtual machine in Yandex Cloud

At this point we need a free soft:

PuTTY – SSH Client

PuTTYgen – Public/Private keys generator

WinSCP – SFTP client

or MobaXTerm as an alternative.

Let’s create a Public-Private key bunch using PuTTYgen.

Register/Logon to Yandex Cloud (https://cloud.yandex.ru/). Go to the Compute Cloud section and start creating a virtual machine.

Virtual machine name: saphana2

Let’s set the parameters of the VM. In the installation guide for SAP HANA Express Edition (Server + Application), we see the following recommended parameters:

Parameters of the VM:

vCPU – 2,

RAM – 32GB,

15 GB + 150 GB, where

15 GB (boot – SSD)

150 GB (data – * HDD)

* – since SAP HANA all operations in RAM as a carrier for a snapshot of data, we can choose a slower HDD

As the operating system, we will choose the latest stable OpenSUSE OS, at the time of this blog-post writing, this is the OpenSUSE version 42.3

Specify the Login and Public SSH key generated using PuTTYgen

Step 3. Prepare virtual machine for SAP HANA XSA

Find your Public IPv4 address in the Overview-Network section.

Create an SSH connection in the Putty client with your Public IPv4 address and add a private key in the Auth section.

Let’s prepare the file structure for installation.

lsblk

vda – boot, vdb – data.

SAP recommends the following file structure

/usr/sap + /usr/sap/distr – 35 GB

/hana/shared/data – 60 GB

/hana/shared/log – 10 GB

/hana/shared –40 GB

Let’s implement such a structure using the fdisk utility:

fdisk /dev/vdb

Let’s check the structure again and create an ext4 filesystem on all the created partitions:

lsblk

and

mkfs.ext4 /dev/vdb1

mkfs.ext4 /dev/vdb2

mkfs.ext4 /dev/vdb3

mkfs.ext4 /dev/vdb4

Let’s create directories for distributions and an SAP HANA database, and also mount the sections created in the previous step to them. We will also update the /etc/fstab file so that the mount is restored on reboot.

mkdir /usr/sap

mkdir /hana

mkdir /hana/shared

mkdir /hana/shared/data

mkdir /hana/shared/log

mount /dev/vdb1 /usr/sap

mount /dev/vdb2 /hana/shared/data

mount /dev/vdb3 /hana/shared/log

mount /dev/vdb4 /hana/shared

mkdir /usr/sap/distr

vi /etc/fstab

Set the permission for the folder with the SAP installation files:

chmod -R 777 /usr/sap/distr

Let’s import the settings from Putty into WinSCP. Connect to the VM and load the archives of SAP HANA Server (hxe.tgz), SAP HANA Extended Application Services –XSA (hxeesa.tgz), and shine.tgz (Training content) to /usr/sap/distr

Unpack the archives:

cd /usr/sap/distr

tar -xvzf hxe.tgz

tar -xvzf hxexsa.tgz

tar -xvzf shine.tgz

Add repository:

sudo zypper ar -c https://download.opensuse.org/tumbleweed/repo/oss/ openSUSE-Tumbleweed-Oss-HTTPS

Install required Linux libraries libstdc++, libnuma1, libatomic and libgcc_s1:

zypper install libstdc++6

zypper install libatomic1

zypper install libgcc_s1

zypper install libnuma1

Step 4. Install SAP HANA XSA

Execute the installation script from root user:

cd /usr/sap/distr

./setup_hxe.sh

Confirm that:

– Media files located in: /distr/HANA_EXPRESS_20

– SID: HXE

– Instance number: 90

– Component to install: all

all –

Application Function Library (AFL) with Analysis Library (PAL), Business Function Library (BFL), Optimization Function Library (OFL), plug-in SAP HANA EPM–MDS

Master password – password from <sid>adm user (hxeadm in our case) on OS-level and SYSTEM on DB-level

Installation processes…

SAP HANA Express Edition installed

During XSA installation you must provide master-password from XSA_ADMIN, XSA_DEV, TEL_ADMIN on XSA level

Step 5. Сheckup

Check that HANA DB up and running:

su – hxeadm

HDB info

Output example:

Check that HANA XSA is up and running.

Authorization:

xs-admin-login

User: XSA_ADMIN

Password: (Master password installed during installation)

Check the version for SAP HANA Extended Application Services, Advanced Model:

xs -v

Output example:

Check available buildpacks:

xs buildpacks

Output example (Python, Java, and Node.js buildpacks are available):

Check available runtimes:

xs runtimes

Output example (SAP JVM, Apache Tomcat, Node.js) runtimes are available

Step 6. Post-installation activity

Web development and administration tools of SAP HANA XSA requires editing hosts file

1. Open the Notepad from the name of the Administrator

2. Open the file C:\Windows\System32\drivers\etc\hosts in Notepad

3. Add line

Step 7. Beginning of work with XSA

There are several ways to administer and develop for SAP HANA XSA

Administer: SAP HANA Cockpit or Eclipse/HANA Studio (SAP HANA Administration Console Perspective)

Develop: SAP WebIDE or Eclipse/HANA Studio (SAP HANA Development Perspective)

Since HANA Cockpit and Web IDE were installed during the installation process, we will consider them as management and administration tools.

Get url for XSA-applications:

xs app xsa-cockpit –urls

xs app webide –urls

xs app cockpit-web-app –urls

Output example:

Let’s open these URL’s in the web browser…

XSA Cockpit:

XSA Cockpit is a browser-based application server management system SAP HANA Extended Application Services, Advanced Model.

XSA Cockpit lets you manage users and roles, organizations, and spaces.

In the User Management section, you can check and, if necessary, assign the roles DEVX_ADMINISTRATOR, DEVX_DEVELOPER for the XSA_DEV user.

In the Tenant Databases section, you can extend the XSA capabilities to a new tenant, in our case, HXE, and link the development space to it.

Hana Cockpit:

HANA Cockpit is an SAP HANA database management system.

The cockpit can be used to manage users and roles at the database level, to create backups, monitor performance, diagnose performance issues at the database level, and many other administrative tasks.

The script for registering database resources in HANA Cockpit is executed during installation, if the script for some reason has not been executed, it must be run manually before the first use by Cockpit.