Technical Articles
SAP HANA EXPRESS EDITION in Yandex Cloud. Binary Installation. Step-by-step guide
About Cloud Trends.
Cloud computing is a new technology trend. A lot of guidelines about SAP in SAP Cloud Platform, Amazon AWS, Google GCP, and Microsoft Azure
But Cloud platforms there is much more. In this step-by-step guideline, you know about newbie among Cloud Providers – about Yandex Cloud. Competition among cloud services is a good thing for customers! Prices are down – Quality is up.
About Yandex and Yandex Cloud.
Yandex (“Russian Google”) is a multinational corporation specializing in Internet-related products and services, including transportation, search and information services, eCommerce, navigation, mobile applications, and online advertising. Yandex provides over 70 services in total. Yandex.Cloud (service was started in Q3 2019) is a suite of cloud services that makes it fast and safe to get as much computing power as you need on a pay-as-you-go model. You access this computing power over the internet. Yandex. Cloud offers different categories of cloud resources, such as virtual machines, block storage, databases, etc. You can manage resources in each category using the web-based console.
Prerequisites.
Do you want to install Hana Express Edition (binary installation) in Yandex Cloud but this small reference may be useful and for other Cloud Providers
Used Tools:
PuTTY – SSH Client
mRemoteNG – Next-generation SSH client
PuTTYgen – Public/Private keys generator
WinSCP – SFTP client
Eclipse with SAP Development Tools – IDE
Resolution.
Go to https://www.sap.com/cmp/td/sap-hana-express-edition.html (Registration Required)
Register, and in the new screen, download the Download manager for your operation system.
Run the Download manager and in the screen, select the image Binary Installer from the dropdown box and set the location where you want to download the archive files.

Regiter / Log-in in Yandex Cloud – https://cloud.yandex.com/
After registration your received credit in 2000 RUB (approx. $35). This is enough to try the service without any charges from your credit card.

Get started with web console.
Select a Compute Cloud and creating a Linux VM.

Provide Name, Description and select one of the available Public images. This guidelines about Linux openSUSE 42.3

N.B. Some facts about Machine Requirements for SAP HANA EXPRESS EDITION here – https://developers.sap.com/tutorials/hxe-ua-getting-started-binary.html
Implement machine requirements in configuration for our a Linux VM:
vCPU – 2
RAM – 16 GB
SSD – 120-GB
Price for this configuration will be approx. $20/month.

At this point you need also the Puttygen for a public and a private keys generation.

Provide username and your a public key

Create and start your a Linux VM.

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

Create SSH connection in the Putty client and add your a private key in the Auth section

Create SSH connection in the mRemoteNG and create bindings between mRemoteNG and Putty in the Config section.

Connect to your a Linux VM in the Yandex Cloud via the mRemoteNG
Login with authenticating by user/public key and increase privileges to a root-user via sudo – i command
Create a directory /distr for the Hana Express installation media
Run the WinSCP client and Import sites from the Putty client

Connect to your instance in the Yandex.Cloud and upload archive to the /distr folder
Unpack Archive
cd /distrtar -xvzf hxe.tgz

Set 0777 permissions to the /distr folder:
chmod -R 0777 /distr
Install missing libraries:
zypper install libtoolzypper install libatomic1zypper install libnuma1
See More information about this libraries in Note #2593824-
2593824 – Linux: Running SAP applications compiled with GCC 7.x
At this point we already can run an installation process:
/distr/HANA_EXPRESS_20/DATA_UNITS/HDB_SERVER_LINUX_X86_64/hdblcm

N.B.SAP HANA AFL — Functions for a particular topic are grouped into an application function library (AFL), such as the Predictive Analysis Library (PAL) and the Business Function Library (BFL).SAP HANA EPM–MDS.The EPM plug–in enables you to analyze the data of the different OLAP data sources.
SELECT 1 (all) ALL components
An Installation parameters.

SAP HANA Express Edition installed

Troubleshooting during an installation proccess
Problem:
An Intsallation process failed with a error:
“/usr/sap/HXE/SYS/global/security/rsecssfs/data/SSFS_HXE.DAT” does not exist (this is not an error per se: a non-existing data file is a valid situation and treated equally as one without entries) <– SSFS-1440: File “/usr/sap/HXE/SYS/global/security/rsecssfs/data/SSFS_HXE.DAT” cannot be opened in mode “rb”: No such file or directory (errno = 2)
Problem resolution:
sidadm user was created during installation:
su hxeadm
SYSTEM PKI/PSE keys generation:
rsecssfx changekey ‘rsecssfx generatekey -getPlainValueToConsole’
Define global environments:
export RSEC_SSFS_DATAPATH=/usr/sap/HXE/SYS/global/security/rsecssfs/data/export RSEC_SSFS_KEYPATH=/usr/sap/HXE/SYS/global/security/rsecssfs/key/
More about SSFS Master Keys changes here – https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.03/en-US/581593c48739431caaccc3d2ef55c23f.html
The problem is solved and installation is go on.
After installation was completed you can check SAP HANA DB version
/usr/sap/HXE/HDB90/HDB info/usr/sap/HXE/HDB90/HDB status

Check SAP HANA connection in the Eclipse IDE
Install / Run Eclipse (for example NEON version)
Install SAP Development Tools – https://tools.hana.ondemand.com/neon/
In the Eclipse IDE select Window -> Perspective -> Open Perspective -> SAP HANA Administration Console
Specify Host Name, Instance Number and your master password for SYSTEM (SAP HANA initial super user)


Open SQL console and determine the information about HANA DB from system view M_DATABASES.
select * from “SYS”.”M_DATABASES

In the next part of this blog series
-
SAP HANA COCKPIT 2.0 Installation in the Yandex.Cloud
-
SAP HANA XS Installation + first app in the Yandex.Cloud
- SAP NetWeaver AS ABAP Developer Edition 7.52 SP04 in Yandex Cloud. Binary Installation. Step-by-step guide
Well prepared guide with every details on latest HXE version. I thought of writing a guide on latest edition but it's binary installation on PC and it's not required as we already have this. You know I found this while searching for Note 2593824 which describes dependencies. You could mention the version 2.0 SPS 04 in Title or somewhere so anyone (anyone with no access to SAP Notes/KBA) can easily find this because most guides that exists are not updated or explain dependencies.
In a guide, Resolution comes after pre-requisites? :p
PS: I installed on openSuSE Leap 15.1 and fixed the dependencies (just two - insserv-compat, libatomic1) myself before finding the Notes. : )