Skip to Content

Install SAP HANA 2.0, express edition on Red Hat Enterprise Linux (Server only)

Previous

Install SAP HANA 2.0, express edition on Red Hat Enterprise Linux (Server only)

By Abdel DADOUCHE

Learn how to prepare your Red Hat Enterprise Linux system to install and test SAP HANA, express edition

You will learn

In this tutorial, you will install the dependencies needed and configure your Red Hat Enterprise Linux system for the setup and execution of SAP HANA, express edition.

Then you will learn how to download the binary installer archives of SAP HANA 2.0, express edition, decompress and install it on your server, including some additional packages for your SAP HANA 2.0, express edition installation.

For troubleshooting information, see SAP HANA, express edition Troubleshooting.

Note:

This tutorial was build and tested using SAP HANA, express edition 2.0 SPS02 revision 21 and Red Hat Enterprise Linux 7.2 for x86-64 as VMware Virtual Machine.

 

Details

Step 1: Verify your Machine Requirements

Before you get started, you should check if your machine meet the recommended software and hardware to successfully install and run SAP HANA 2.0, express edition.

Note: Supported Platform Disclaimer

The operating systems officially supported by SAP HANA, express edition 1.0 SPS12 include:

  • SUSE Linux Enterprise for SAP Applications, 11.4, 12.0, 12.1
  • Red Hat Enterprise Linux 7.2

The operating systems officially supported by SAP HANA, express edition 2.0 include:

  • SUSE Linux Enterprise Server for SAP Applications, 12.1, 12.2
  • SUSE Linux Enterprise Server for SAP Applications, IBM Power Systems (ppc64le - “Little Endian”), 12.1, 12.2

SAP Community members have been successful in running HXE on newer or other Linux operating systems that are not formally supported by SAP, such as Ubuntu, openSUSE and Fedora.

However, SAP is not committing to resolving any issues that may arise from running SAP software on any unsupported platforms.

 

Your server will need the following:

Hardware Details
RAM 24 GB minimum (32 GB recommended)

Note: If you are installing on a system with 16 GB of RAM, increase the amount of swap space to at least 32 GB.
HDD 120 GB HDD recommended
Cores 2 cores (4 recommended)

Check the RAM


To check the amount of RAM memory available on your system you can execute the following from your server terminal console:

free -m

And the output will look like this:

        total   used   free   shared  buff/cache   available
Mem:     7808   7265    133       23         409         235
Swap:    8064   3627   4437

Check the HDD (Hard Drive Disk)


To check the amount of disk space available on your system, you can execute the following from your server terminal console:

df --block-size=1G

Here it is important to consider that the software will be installed in the /usr/sap directory.


Check the CPU


To check the number of CPU available on your system, you can execute the following from your server terminal console:

grep -c ^processor /proc/cpuinfo
Step 2: Prepare Your System

Red Hat Enterprise Linux for SAP HANA Subscription


In order to install and run SAP HANA, express edition on a Red Hat Enterprise Linux (RHEL) operating system, the following additional Red Hat software components must be installed via Red Hat Enterprise Linux for SAP HANA channel:

  • Scalable File System Add-On (XFS).
  • compat-sap-c++.so package which is the gcc-4.7 libstdc++ rebuilt for RHEL.
  • tuned profiles sap-hana and sap-hana-vmware

An overview of the Red Hat Enterprise Linux for SAP HANA Subscription is available here:

And the detailed options and instructions to subscribe your RHEL system to the RHEL for SAP HANA channel are available here:

Once your system is properly configured with the subscription, you should be able to run the following command from a terminal console on your server:

sudo yum repolist

In the output you should have an entry like RHEL EUS Server SAP HANA.

Now, you have to clean the yum cached data.

From your server terminal console, execute the following command:

sudo yum clean all

Environment package


In order to install and run SAP HANA, express edition on your RHEL system, you will need the Base environment group package, as the Core or the Minimal group package are not enough.

From your terminal console, execute the following command to get the available group packages:

sudo yum grouplist

The Base environment group package may not be marked as installed in the previous list which may require to run the following command:

sudo yum group mark convert

If not installed, then run the following command:

sudo yum -y groupinstall base

Required packages


You will also need to check that the following package version are installed before getting started:

  • kernel-3.10.0-514.28.1.el7 or newer
  • kexec-tools-2.0.7-50.el7_3.2 or newer
  • glibc-2.17-157.el7_3.5 or newer

To verify that the packages are available, you can execute the following command:

rpm -qa --queryformat '(%{installtime:date}) %{name} %{version}\n' kernel
rpm -qa --queryformat '(%{installtime:date}) %{name} %{version}\n' kexec-tools
rpm -qa --queryformat '(%{installtime:date}) %{name} %{version}\n' glibc

Additional packages dependencies


You will need to install the following additional packages:

xulrunner sudo libssh2 expect
graphviz iptraf-ng krb5-workstation libpng12
nfs-utils lm_sensors openssl PackageKit-gtk3-module
libcanberra-gtk2 xorg-x11-xauth numactl bind-utils

From your terminal console, execute the following command:

sudo yum -y install xulrunner \
	sudo \
	libssh2 \
	expect \
	graphviz \
	iptraf-ng \
	krb5-workstation \
	libpng12 \
	nfs-utils \
	lm_sensors \
	openssl \
	PackageKit-gtk3-module \
	libcanberra-gtk2 \
	xorg-x11-xauth \
	numactl \
	bind-utils

The command uses the -y which will assume that all question like using more space will be answered as yes.

As the output may be long and not easy visualize, you can run the command again, you should be able to spot easily packages that can’t install as properly installed ones won’t get reinstalled.


RHEL SAP HANA Compatibility Library


The gcc-4.7 libstdc++ library is required to install and run SAP HANA in general whatever the Linux distribution.

A compatibility library was built for RHEL by Red Hat to enable the SAP HANA installation & execution, and this requirement is applicable to any SAP HANA, express edition installations on RHEL.

The compatibility library is available via the Red Hat Enterprise Linux for SAP HANA Subscription, which was configured during the first step.

To verify if the package was previously installed, you can execute the following:

rpm -qa --queryformat '(%{installtime:date}) %{name}\n' compat-sap-c++-6

The output should include an entry with version 6.3.1 or higher.

To install the package if it is missing or with an older version, execute the following command:

sudo yum -y install compat-sap-c++-6

Activate the RHEL SAP HANA Specific Tuned Profiles


The tuned tuning service for Linux can adapt the operating system to perform better under certain workloads by setting a tuning profile.

Red Hat has developed specific tuned profiles to optimize the performance of SAP HANA on RHEL.

From your terminal console, execute the following command:

sudo yum -y install tuned-profiles-sap-hana

Now you need to start and enable the tuning service by executing the following using sudo:

sudo systemctl start tuned
sudo systemctl enable tuned

You can check the service status using the following command:

sudo systemctl status tuned

Once started, you can run execute the profile by executing the following commands:

tuned-adm profile sap-hana

Note: when executing RHEL on VMware the tuned profile is named sap-hana-vmware

 


Disable SELinux


RHEL 7.2 is delivered with SELinux enabled by default. Since there is no supported SELinux policy for SAP HANA, SELinux must be disabled to be able to run SAP HANA on RHEL7.

From your terminal console, execute the following commands:

sudo setenforce 0
sudo sed -i 's/\(SELINUX=enforcing\|SELINUX=permissive\)/SELINUX=disabled/g' /etc/selinux/config

For the change to permanently take effect you will need to restart your system, but you will do that at the end of the configuration.

You can check the service status using the following command:

sestatus

It should return the following:

SELinux status:                 disabled

You can check the service status using the following command:

getenforce

It should return the following:

Disabled

Disable Automatic NUMA Balancing


SAP HANA is aware of NUMA (non-uniform memory access), and it does not rely on the Linux kernel features to optimize NUMA usage automatically.

Therefore, the automatic NUMA balancing features of the Linux Kernel should be disabled.

To disable this feature, from your terminal console, execute the following commands:

sudo cp /etc/sysctl.d/sap_hana.conf /etc/sysctl.d/sap_hana.conf.bkp
sudo echo "kernel.numa_balancing = 0" > /etc/sysctl.d/sap_hana.conf
sudo sysctl -p /etc/sysctl.d/sap_hana.conf

RHEL7 also provides the numad user space daemon that can be used to control NUMA balancing of applications. This needs to be disabled as well using the executing the following commands:

sudo systemctl stop numad
sudo systemctl disable numad

Symbolic Links


Since SAP HANA is built on a different Linux Distribution some of the library names used during the built process do not match with the library names used on RHEL7.

Check if the following symbolic exists by execute the following command:

ls -la /usr/lib64/libssl.so.1.0.1 /usr/lib64/libcrypto.so.1.0.1

Make sure they point to respectively:

lrwxrwxrwx. 1 root root XX yyy zz aa:bb /usr/lib64/libcrypto.so.1.0.1 -> /usr/lib64/libcrypto.so.1.0.1e
lrwxrwxrwx. 1 root root XX yyy zz aa:bb /usr/lib64/libssl.so.1.0.1 -> /usr/lib64/libssl.so.1.0.1e

If they are not present you can add them by executing the following commands:

sudo ln -s /usr/lib64/libssl.so.1.0.1e /usr/lib64/libssl.so.1.0.1
sudo ln -s /usr/lib64/libcrypto.so.1.0.1e /usr/lib64/libcrypto.so.1.0.1

Configure your Firewall


To protect your servers from unauthorized access, it is usual to configure the built-in firewall of the OS to only allow its access via a specified series of ports and communication protocol.

To configure the firewall, you can use the firewall-config tool. In this case, you will need an X11 System to display the GUI version or you can use the command line tool firewall-config-cmd.

To avoid problems with the firewall during installation, it can be beneficial to disable it completely during the installation process with the following commands:

sudo systemctl stop firewalld
sudo systemctl disable firewall

You can check the best practice section about firewall configuration once you complete the installation to properly configure your system.


Java Version


One the requirement to install SAP HANA, express edition is a 64-bit Java Runtime Environment (JRE) 8 or Higher, especially if you are planning to use the SAP HANA 2.0, express edition Download Manager.

To check if Java is installed, you can run the following command from your terminal console:

java -version

which should return:

java version "1.8.0_xx"
Java(TM) SE Runtime Environment (build 1.8.0_xx-yyy)

If you don’t have it yet installed, you can check the following link for download link and installation instructions : https://tools.hana.ondemand.com/#cloud

Using the RPM option is most likely the easiest, as you will have to simply run the following command from your terminal console (where needs to be adjusted based on the downloaded version):

sudo rpm -ivh <rpm directory>/sapjvm-<version>-linux-x64.rpm

Then you will need to update the “alternatives” and enable your flavor of java using the following commands:

sudo update-alternatives --install "/usr/bin/java" "java" "/usr/java/sapjvm_8_latest/bin/java" 1
sudo update-alternatives --set java /usr/java/sapjvm_8_latest/bin/java
Step 3: Reboot your system

Some of the changes applied requires a restart of the system to fully take effect, you must reboot your system before proceeding with the installation.

Step 4: Register for SAP HANA, express edition

Go to the registration page at http://sap.com/sap-hana-express published on the SAP site.

Alternately, you can go to the SAP HANA, express edition launch page at http://www.sap.com/developer/topics/sap-hana-express.html published on SAP site and click the Register and download SAP HANA, express edition download manager link.

Complete the registration form and click the Register button. The Registration Success page displays. You will also receive an email indicating successful registration.

Note:
If you have an SAP login, click the Login icon at the top of the page to populate the registration form automatically.

 

Registration Page

The Registration Success page displays. (You will also receive an email indicating successful registration.)

Registration Success page

On the Registration Success page, under 1A. ON-PREMISE INSTALLATION, you will get the different download manager options listed:

  • Linux (HXEDownloadManager_linux.bin)

    This standard Linux executable allows you to run the download manager directly from your Linux server machine, using either the GUI Mode (assuming you have a X11 properly configured) or the Console Mode

  • Windows (HXEDownloadManager_win.exe)

This standard Windows executable allows you to run the download manager directly from your Window machine, using only the GUI Mode. Then you will need to transfer the downloaded archives to you target server.

  • Platform-independent (HXEDownloadManager.jar)

Allows you to run the download manager directly from any platform (as it is a Java based program), using either the GUI Mode or the Console Mode.

To run the Platform-independent download manager, you will need to execute the following:

java -jar <download manager path>/HXEDownloadManager.jar

Note: If you have a Mac, or another type of machine, click “Platform-independent” for a platform-independent download manager.

 

You will find next the instructions for both the GUI Mode and the Console Mode. It is however, recommended that you use the Console Mode directly from the RHEL server.

Save the Platform-independent Download Manager file directly on your RHEL system.

Note: If your RHEL system is not connected to the internet, then you have no choice but to save the Download Manager locally, download the packages locally then transfer them to your RHEL system.

 

Step 5: Download Your Packages

As stated in the previous section you can download the installation packages either using a GUI Mode or a Console Mode.

You will find below the instructions for both. It is however, recommended that you use the Console Mode directly from the RHEL server.

Note: Again, if your RHEL system is not connected to the internet, then you have no choice but to save the Download Manager locally, download the packages locally (using either the GUI Mode or a Console Mode) then transfer them to your RHEL system.

 


Using the Console Mode


Note: Before, run running the Download Manager in console, make sure to close any open GUI Mode running instances.

 

Open a command prompt or a terminal console at the location where you saved the Platform-independent download manager file.

You can display the command help using the -h argument like this:

java -jar <download manager path>/HXEDownloadManager.jar -h

The command syntax is:

HXEDownloadManager [( [-h|-X] | [-d <save_directory>] [--ph <proxy_host>] [--pp <proxy_port>] <platform> <image> <file>... )]

Note: You must include an argument with each command. If you call the Download Manager without an argument, it opens in GUI mode.

 

You will need to download the following packages:

  • Server Only Installer
  • Client for Linux X86/64
  • SAP HANA External Machine Learning AFL
  • Text analysis files for additional languages

Execute the following commands to create the directory where you download the installer packages, set the permissions to allow all required access, and finally run the download manager (***make sure to update the download manger path***):

sudo mkdir /opt/hxe
sudo chmod a+rwx /opt/hxe

cd <download manager path>

java -jar HXEDownloadManager.jar linuxx86_64 installer \
  -d /opt/hxe \
  --ph proxy \
  --pp 8080 \
  hxe.tgz \
  clients_linux_x86_64.tgz \
  eml.tgz \
  additional_lang.tgz

The archive packages will be downloaded in the /opt/hxe.

For more information about the other downloadable package, please refer to the Appendix section.


Using the GUI Mode


Note: To run the download manager suing the GUI Mode, it assumes that your RHEL system is configured with a Desktop environment like GNOME or KDE.

 

Start the download manager.

Download Manager

In the Platform pull-down, select Linux/x86-64 (unless your target system is Linux/Power (little endian).)

In the Image pull-down, select Binary Installer.

Click Browse and select where you want your downloads to be saved.

Then select the following packages:

  • Server Only Installer
  • Client for Linux X86/64
  • SAP HANA External Machine Learning AFL
  • Text analysis files for additional languages

Click the Download button to being your download.

Your download is complete when a pop-up message appears confirming successful download. Make sure you wait for this message before accessing the downloaded files.

Now that the file are downloaded, you can transfer them to the /opt/hxe directory on your target RHEL system.

Make sure you update the read/write/execute permission on the /opt/hxe directory using the following command:

sudo chmod a+rwx /opt/hxe

For more information about the other downloadable package, please refer to the Appendix step.

Step 6: Install SAP HANA, express edition

Install the Server package


You need to extract the contents of the downloaded archive packages using the following command:

mkdir /opt/hxe/installer
tar -xvzf /opt/hxe/hxe.tgz -C /opt/hxe/installer

Note: the hxe.tgz package must be downloaded and extracted first whatever the installation you are planning as it include the core data units to be installed.

 

Then, you will need to navigate to the directory where the archives were extracted and run the setup.:

From your server terminal console, execute the following commands:

cd /opt/hxe/installer
sudo ./setup_hxe.sh

Accept the prompts default values (unless no value is provided) to configure your installation:

Installer root directory /opt/hxe/installer/HANA_EXPRESS_20
SAP HANA system ID HXE
HANA instance number 90
local host name should display your local host name
HDB master password you will need to conform to the Master password policy as described bellow

Once the installation is completed, you should get the following elements in your console:

  ##################################
  # Summary after execution        #
  ##################################
  Server Installation...(OK)
  XSC Installation...(OK)
  HXE Optimization...(OK)

After the installation is completed, it is recommended to run the Memory Management Script as described in the Best Practice to release all unused resources and free up some memory.

sudo su -l hxeadm

cd /usr/sap/HXE/home/bin
./hxe_gc.sh

exit

Note: Master password policy
The master password you will specify is used for the <sid>adm and sapadm OS users, the telemetry technical user, and the HANA SYSTEM user.

SAP HANA, express edition requires a very strong password that complies with these rules:

  • At least 8 characters
  • At least 1 uppercase letter
  • At least 1 lowercase letter
  • At least 1 number
  • Can contain special characters, but not ` (backtick), $ (dollar sign), \ (backslash), ' (single quote), or " (double quotes)
  • Cannot contain dictionary words
  • Cannot contain simplistic or systematic values, like strings in ascending or descending numerical or alphabetical order

 


Install the SAP HANA HDB Client for Linux


The downloaded archive for the client package contains both the SAP HANA HDB Client and the SAP HANA XS CLI.

Here you will only install the SAP HANA HDB Client.

The SAP HANA HDB Client software package includes the following connectivity/drivers:

  • SQLDBC
  • ODBC
  • JDBC
  • Python (PyDBAPI)
  • Node.js
  • Ruby

Then, you need to extract the contents of clients_linux_x86_64.tgz into the /opt/hxe directory using the following command:

tar -xvzf /opt/hxe/clients_linux_x86_64.tgz -C /opt/hxe

The following files will be extracted:

  • hdb_client_linux_x86_64.tgz : the SAP HANA HDB Client software package
  • xs.onpremise.runtime.client_linuxx86_64.zip : the SAP HANA XS CLI software package

You need now to decompress the SAP HANA HDB Client package executing the following command:

tar -xvzf /opt/hxe/hdb_client_linux_x86_64.tgz -C /opt/hxe/installer

And now you can run the installer program executing the following commands:

sudo su -l hxeadm

cd /opt/hxe/installer/HDB_CLIENT_LINUX_X86_64
./hdbinst

exit

Accept the prompts default values to configure your installation:

  • Installation Path : /usr/sap/hdbclient

Once the installation is completed, you should get the following elements in your console:

Installation done

Install SAP HANA External Machine Learning AFL


You need to extract the contents of the downloaded archive packages using the following command:

From your server terminal console, execute the following command:

tar -xvzf /opt/hxe/eml.tgz -C /opt/hxe/installer

You need now to execute the following commands:

sudo su -l hxeadm

cd /opt/hxe/installer/HANA_EXPRESS_20
./install_eml.sh

exit

Once the installation is completed, you should get the following elements in your console:

Installation done

After the installation is completed, it is recommended to run the Memory Management Script as described in the Best Practice to release all unused resources and free up some memory.

sudo su -l hxeadm

cd /usr/sap/HXE/home/bin
./hxe_gc.sh

exit

Install the additional Text Analysis files


If you want to use the SAP HANA, express edition Text Analysis feature in a language other than English or German, you will need to install the Text analysis files for additional languages package.

You should be prompted for the master password provided during the installation process.

Then, extract the contents of additional_lang.tgz to the lexicon directory using the following command:

sudo tar -xvzf /opt/hxe/additional_lang.tgz -C /hana/shared/HXE/global/hdb/custom/config/lexicon
Step 7: Test Your Installation

Running processes


By default, when the server installation is completed, all required process should be started.

Here are the steps to verify that all the required processes are up and running.

You need now to execute the following commands:

sudo su -l hxeadm

HDB info | grep -e hdbnameserver -e hdbcompileserver -e hdbindexserver -e hdbdiserver -e hdbwebdispatcher

The output should look like this:

hxeadm    71252  71235 55.2 7982280 5377200      \_ hdbnameserver
hxeadm    71347  71235  2.1 1580412 257312      \_ hdbcompileserver
hxeadm    71374  71235 12.8 5321396 2845732      \_ hdbindexserver -port 39003
hxeadm    71516  71235  1.6 1588012 260768      \_ hdbdiserver
hxeadm    71518  71235  1.9 1880592 279788      \_ hdbwebdispatcher

The following services must be running:

  • hdbnameserver
  • hdbcompileserver
  • hdbindexserver
  • hdbdiserver
  • hdbwebdispatcher

If any of the above services is not listed, you must start your instance executing the following command:

HDB start

When the prompt returns, the system is started.


SAP HANA Client


You can check the following links to verify some of the connectivity options available for the SAP HANA HDB Client:

  • JDBC
  • Python
  • ODBC (content coming soon!)
  • SQLDBC (content coming soon!)
  • Node.js (content coming soon!)
  • Ruby (content coming soon!)

SAP HANA External Machine Learning Library (EML)


The SAP HANA External Machine Learning Library is an application function library (AFL) supporting the integration of Google TensorFlow, as an external machine learning framework, with SAP HANA, express edition.

Now, you can test that the installation was successful using a hdbsql command.

You need now to execute the following commands with the default installation values::

sudo su -l hxeadm

cd /usr/sap/HXE/HDB90/exe

./hdbsql \
	-i 90 \
	-d SystemDB \
	-u SYSTEM \
	-p "<master-password>" \
	"SELECT * FROM SYS.AFL_AREAS WHERE AREA_NAME = 'EML';"

You will need to replace <master-password> by the master password as provided during the installation.

You should receive a result similar to this:

AREA_OID,SCHEMA_NAME,AREA_NAME,CREATE_TIMESTAMP
159136,"_SYS_AFL","EML","<installation date>"

XS Engine


You can check that the XSEngine is up and running using a browser using the following URL pattern with the default installation values, you can use:

http://<hostname>:8090

or

https://<hostname>:4390

A success page displays:

Success Page

If you can’t connect to the page you can verify that the port is in LISTEN mode using the following command:

netstat -ano | grep -e 8090 -e 4390 | grep LISTEN

And the expected result should be:

tcp   0   0 0.0.0.0:8090    0.0.0.0:*     LISTEN   off (0.00/0/0)
tcp   0   0 0.0.0.0:4390    0.0.0.0:*     LISTEN   off (0.00/0/0)

If the result is empty, then one of the required services is not up and running else your firewall is blocking the communication.

Best Practice: Deactivate the SYSTEM user

The SYSTEM user is the database “super-user” and is not intended for day-to-day activities in production systems.

For better security, you can create other database users with only the privileges that they require for their tasks (for example, user administration), then deactivate the SYSTEM user.

You need now to execute the following commands to create a new admin user with the USER ADMIN system privilege:

sudo su -l hxeadm

cd /usr/sap/HXE/HDB90/exe

./hdbsql \
	-i 90 \
	-d SystemDB \
	-u SYSTEM \
	-p "<master-password>" \
	"CREATE USER <admin-username> PASSWORD <admin-password> NO FORCE_FIRST_PASSWORD_CHANGE;"

./hdbsql \
	-i <instance-number> \
	-d SystemDB \
	-u SYSTEM \
	-p "<master-password>" \
	"GRANT USER ADMIN TO <admin-username> WITH ADMIN OPTION;"

You will need to replace <master-password> by the master password as provided during the installation.

Warning: do not run the next command until you have successfully created an alternate admin user.

 

Now that the new admin user is created, you can deactivate the existing SYSTEM user using:

./hdbsql \
  -i <instance-number> \
  -d SystemDB \
  -u SYSTEM \
  -p "<master-password>" \
	"ALTER USER SYSTEM DEACTIVATE USER NOW;"
Best Practice: Backups

It a good practice to make regular data backups and save your work.

For information on data backup, recovery, and log file growth, see the SAP HANA 2.0 Administration Guide.

Best Practice: Set the Global Memory Allocation Limit

You can set how much memory SAP HANA, express edition utilizes by modifying the global_allocation_limit parameter in the global.ini file.

The measure unit for the global_allocation_limit parameter is MB.

The default value is 0, which sets the maximum memory to the minimum of your machine limit and license limit.

If the machine size is less than 16 GB, the maximum memory is set to 16 GB.

If you set global_allocation_limit to a non-zero value, the server instance will use that value as maximum memory.

Here an example command to alter the global_allocation_limit value to 16 GB (to be executed as hxeadm user):

cd /usr/sap/HXE/HDB90/exe
./hdbsql \
	-i 90 \
	-d SystemDB \
	-u SYSTEM \
	-p "<master_password>" \
  "alter system alter configuration ('global.ini','SYSTEM') set ('memorymanager', 'global_allocation_limit') = '16384' with reconfigure;"

Note: Do not set global_allocation_limit to a value above the limit of your license. This may cause the database to lock down.

 

Best Practice: Run the Memory Management Script

On a regular basis, it is recommended to use the memory management / Garbage collector script to free up available memory using the following commands:

sudo su -l hxeadm

cd /usr/sap/HXE/home/bin
./hxe_gc.sh

When prompted for System database user (SYSTEM) password, enter the master password you specified during SAP HANA, express edition installation.

The command prompt returns when the cleanup process is finished, and the expected logs should be displayed in the console:

tcp   0   0 0.0.0.0:8090    0.0.0.0:*     LISTEN   off (0.00/0/0)
Best Practice: Text Analysis As Embedded Preprocessor

If your tables do not use a full text index, or if your tables use a full text index but contain very little data, you can save about 120 MB of memory if you turn off the standalone text analysis preprocessor, and activate the embedded text analysis preprocessor.

Stop the standalone preprocessor:

cd /usr/sap/HXE/HDB90/exe
./hdbsql \
	-i 90 \
	-d SystemDB \
	-u SYSTEM \
	-p "<master_password>" \
  "alter system alter configuration ('daemon.ini','SYSTEM') set ('preprocessor','instances') = '0' with reconfigure;"

Start the embedded preprocessor:

cd /usr/sap/HXE/HDB90/exe
./hdbsql \
	-i 90 \
	-d SystemDB \
	-u SYSTEM \
	-p "<master_password>" \
  "alter system alter configuration ('preprocessor.ini','SYSTEM') set ('general','embedded') = 'true' with reconfigure;"
Best Practice: Firewall Configuration

SAP HANA, express edition, just like SAP HANA, will use a series of port based on the current instance id (the default value is 90 starting version 2.0).

Here a description of the port used (Source https://help.sap.com/viewer/ports):

Name Default Range Rule Comments (Explanation of Table Headings)
Host Agent 1128 1128 1128 SAP Host Agent with SOAP/HTTP
Host Agent 1129 1129 1129 SAP Host Agent with SOAP/HTTPS
HTTPS 4300 4300 – 4399 43<NN> SAP Web Dispatcher
HTTP 8000 8000 – 8099 80<NN> SAP Web Dispatcher
indexserver 30013 30013 – 39913 3<NN>13 SQL/MDX access port for standard access to the system database of a multitenant system.
indexserver 30015 30015 – 39915 3<NN>15 SQL/MDX access port for standard access to the tenant database of a multitenant system (automatically created).
statisticsserver 30017 30017 – 39917 3<NN>17 Applicable when run as a separate service (default is embedded).
HTTP(S) 30030 30030 – 39930 3<NN>30 In an XSA runtime environment and port routing used, allow data access connection to the xscontroller-managed Web Dispatcher
HTTP(S) 30032 30032 – 39932 3<NN>32 In an XSA runtime environment and port routing used, allow data access connection to the xscontroller-managed Web Dispatcher
HTTP(S) 30033 30033 – 39933 3<NN>33 Single port for all SAP HANA XSA application and services when routing is done by host names instead of ports. For more information see SAP Note 2245631.
indexserver None 30041– 39998 3<NN>41 – 3<NN>98 SQL/MDX access port for standard access to the tenant databases of a multitenant system. Port assigned automatically from available port at creation time.
SOAP/HTTP 50013 50013 – 59913 5<NN>13 Instance Agent
SOAP/HTTPS 50014 50014 – 59914 5<NN>14 ‌Instance Agent
HTTP(S) None 51000 – 51500 51000 – 51500 In an XSA runtime environment and port routing used, port range used for the connection from the xscontroller-managed Web Dispatcher to the xscontroller for application instances access

Note: <NN> represent the instance id of your SAP HANA, expression edition. The default value is 90.

 

Therefore, if your instance number is 90, here is an example for the firewall configuration.

You can execute the following commands:

sudo echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>" > /etc/firewalld/services/hana.xml
sudo echo "<service>" >> /etc/firewalld/services/hana.xml
sudo echo "	<short>SAP HANA</short>" >> /etc/firewalld/services/hana.xml
sudo echo "	<description>Firewall rules for SAP HANA</description>" >> /etc/firewalld/services/hana.xml
sudo echo "	<port port=\"1128\" protocol=\"tcp\"/>" >> /etc/firewalld/services/hana.xml
sudo echo "	<port port=\"1129\" protocol=\"tcp\"/>" >> /etc/firewalld/services/hana.xml
sudo echo "	<port port=\"4390\" protocol=\"tcp\"/>" >> /etc/firewalld/services/hana.xml
sudo echo "	<port port=\"8090\" protocol=\"tcp\"/>" >> /etc/firewalld/services/hana.xml
sudo echo "	<port port=\"30000-39999\" protocol=\"tcp\"/>" >> /etc/firewalld/services/hana.xml
sudo echo "	<port port=\"50000-59999\" protocol=\"tcp\"/>" >> /etc/firewalld/services/hana.xml
sudo echo "</service>" >> /etc/firewalld/services/hana.xml

sudo chmod 0640 /etc/firewalld/services/hana.xml

sudo systemctl start firewalld
sudo systemctl enable firewalld

sudo firewall-cmd --zone=public --add-service=hana --permanent
sudo firewall-cmd --reload

You can check the service status using the following command where hana should be listed:

sudo firewall-cmd --list-services
Appendix: Download Manager

Using the GUI Mode


When using the GUI Mode, you will be able to download the following packages.

The table below provide more details around each package.

Package Details
Getting Started Guide User manual in PDF format
Server only installer (Required) Downloads hxe.tgz; the SAP HANA 2.0, express edition server with Application Function Library.
This file is necessary for installing SAP HANA 2.0, express edition.
Applications Downloads the optional package hxexsa.tgz; XSA and SAP HANA cockpit.
The "Server only" package is required to install this package.
Text analysis files for additional languages For languages other than English and German, these files are required for the HANA Text Analysis function.
The text analysis files for English and German are already included in the Server only and Applications packages.
The "Server only" package is required to install this package.
SAP Enterprise Architect Designer Downloads eadesigner.tgz
SAP HANA streaming analytics Downloads hsa.tgz, which contains SAP HANA streaming analytics.
The "Applications" package is required to install this package.
SAP HANA streaming analytics studio plug-in Downloads hsa_plugin.zip, which contains an Eclipse plugin for creating and deploying streaming analytics projects.
SAP HANA Interactive Education (SHINE) Downloads shine.tgz.
The "Applications" package is required to install this package.
SAP HANA External Machine Learning AFL Downloads eml.tgz, which contains the SAP HANA External Machine Learning Library.
The SAP HANA External Machine Learning Library is an application function library (AFL) supporting the integration of Google TensorFlow, as an external machine learning framework, with SAP HANA, express edition.
The "Server only" package is required to install this package.
Clients:
  • Linux X86/64
  • Linux PPC/Little Endian
  • Windows
  • Mac
Downloads:
  • clients_linux_x86_64.tgz
  • clients_linux_ppc64le.tgz
  • clients_windows.zip
  • clients_mac.tgz
Each clients package downloads an archive containing client-tools bundles for the listed platform. Use the client packages to access developed SAP HANA 2.0, express edition applications from a client PC.
The client machine does not require a SAP HANA installation to install and run the clients.
The package includes:
  • hdb_client_xxxx.tgz - Reduced HANA client for the selected operating system. Contains the HANA client package, drivers, and required licenses.
  • xs.onpremise.runtime.client_xxxxx.zip Command-line tools for the selected operating system that enable access to (and control of) the SAP HANA XS advanced run-time environment.
Tip
After you develop an application using SAP HANA 2.0, express edition, install Download Manager to a client machine and download the Clients package to that client machine. You can then use the clients to connect to -- and test -- your HANA applications, emulating a customer.
SAP HANA smart data integration Downloads sdi.tgz.
SAP HANA smart data integration provides functionality to access source data, and to provision, replicate, and transform that data in SAP HANA on premise, or in the cloud.
The "Server only" package is required to install this package.
SAP HANA smart data integration - Data Provisioning Agent Downloads dpagent_linux_x86_64.tgz.
The Data Provisioning Agent provides secure connectivity between the SAP HANA database and your adapter-based sources.
Download this and "Server only" package to install this additional component.
This package is only available for Linux X86/64 environments
SAP Web IDE for SAP HANA Downloads webide.tgz.
SAP Web IDE for SAP HANA is a browser-based integrated development environment for the development of SAP HANA-based applications comprised of extensive SAP HANA data models, business logic, and web-based UIs. The "Applications" package is required to install this package.

Using the Console Mode


Here is the complete list of command arguments with the Console Mode:

Argument Description
-h Print this help.
-x Print extended help.
-d <save_directory> Directory where to save the download file. Default is %USERPROFILE%\Downloads on Windows; ~/Downloads on Linux.
--ph <proxy_host> Proxy host name or IP address.
--pp <proxy_port> Proxy host name or IP address.
<platform> HANA platform. Valid values are linuxx86_64, linuxppc64le.
<image> Type of image to download. Valid values for linuxx86_64 platform are: vm, installer. Valid values for linuxppc64le platform are: installer.
<file> File(s) to download.

And the complete list of values for the linuxx86_64 platform:

Values Description
Getting_Started_HANAexpress_Binary_Installer.pdf User manual in PDF format
hxe.tgz Downloads hxe.tgz; the server only binary installer
hxexsa.tgz Downloads hxexsa.tgz; the application binary installer, which requires the hxe.tgz binary installer to run
additional_lang.tgz Downloads additional_lang.tgz. For languages other than English and German, this package is required for the HANA Text Analysis function. (The text analysis files for English and German are already included in the hxe.tgz and hxexsa.tgz packages.)
eadesigner.tgz Valid only with hxexsa.tgz. SAP EA Designer lets you capture, analyze, and present your organization’s landscapes, strategies, requirements, processes, data, and other artifacts in a shared environment
hsa.tgz Downloads SAP HANA streaming analytics.
hsa_plugin.zip Downloads the Eclipse plugin for creating and deploying streaming analytics projects.
shine.tgz Valid only with hxexsa.tgz. SAP HANA Interactive Education (SHINE) makes it easy to learn how to build applications on SAP HANA Extended Application Services Advanced Model (XSA).
eml.tgz Downloads HANA Extended Machine Learning AFL.
clients_linux_x86_64.tgz Client download package for Linux machines (x86/64 architectures). Use the client packages to access developed SAP HANA, express edition applications from a client PC.
clients_linux_ppc64le.tgz Client download package for Linux machines (little endian on Power architectures). Use the client packages to access developed SAP HANA, express edition applications from a client PC.
clients_windows.zip Client download package for Windows machines. Use the client packages to access developed SAP HANA, express edition applications from a client PC.
clients_mac.tgz Client download package for Mac. Use the client packages to access developed SAP HANA, express edition applications from a client PC.
sdi.tgz SAP HANA smart data integration download package. SAP HANA smart data integration provides functionality to access source data, and to provision, replicate, and transform that data in SAP HANA on premise, or in the cloud.
dpagent_linux_x86_64.tgz SAP HANA smart data integration - Data Provisioning Agent (Linux X86/64) download package. The Data Provisioning Agent provides secure connectivity between the SAP HANA database and your adapter-based sources.
webide.tgz SAP Web IDE for SAP HANA is a browser-based integrated development environment for the development of SAP HANA based applications comprised of extensive SAP HANA data models, business logic, and web-based UI’s.

Updated 11/10/2017

Time to Complete

90 Min

Intermediate

Tags

Next
Back to top

Call me now