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

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
• Red Hat Enterprise Linux for SAP Applications 7.2, 7.3
• Red Hat Enterprise Linux for SAP Applications for Power 7.3 (SAP HANA 2.0, express edition SPS 02 Rev 21 or higher required)

Please refer to the version of the binary installation guide for the latest updates.

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:

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

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:

• compat-sap-c++.so package which is the gcc-4.7 libstdc++ rebuilt for RHEL.
• tuned profiles sap-hana (or sap-hana-vmwarewhen used in a VMware environment)

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

• https://access.redhat.com/articles/1187363

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

• https://access.redhat.com/solutions/2334521

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.

If the repositories are not listed or enabled, you can run the following command:

sudo subscription-manager repos --enable="rhel-sap-hana-for-rhel-7-server-rpms" --enable="rhel-7-server-rpms"

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:

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 questions will be answered as yes.

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

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.service
sudo systemctl disable firewalld.service

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

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.

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

Alternately, you can go to the SAP HANA, express edition launch page at https://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.

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

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.

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
• Applications
• Client for Linux X86/64
• SAP HANA Interactive Education (SHINE)
• 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 -R a+rwx /opt/hxe

cd <download manager path>

java -jar HXEDownloadManager.jar linuxx86_64 installer \
  -d /opt/hxe \
  --ph proxy \
  --pp 8080 \
  hxe.tgz \
  hxexsa.tgz \
  clients_linux_x86_64.tgz \
  shine.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.

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
• Applications
• Client for Linux X86/64
• SAP HANA Interactive Education (SHINE)
• 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 -R a+rwx /opt/hxe

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

Install the Server + Applications 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
tar -xvzf /opt/hxe/hxexsa.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:

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

  ##################################
  # Summary after execution        #
  ##################################
  Server Installation...(OK)
  XSC Installation...(OK)
  XSA 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 SAP HANA Interactive Education (SHINE)

SAP HANA Interactive Education (SHINE) makes it easy to learn how to build applications on SAP HANA Extended Application Services Advanced Model.

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/shine.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_shine.sh

exit

You will be prompted to enter the SYSTEM and the XSA_ADMIN credentials (you should enter the master password).

You will also be prompted to enter new credentials for the XSA_SHINE user that will be created during the process (for the purpose of this tutorial, it is recommended to use the same master password provided earlier).

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

Software component XSAC_SHINE (sap.com) 'SAP Hana Demo Model for XS Advanced 1.0' successfully registered.
Process [install] finished successfully.
Performance /opt/hxe/installer/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACSHINE04_2.ZIP: UploadFiles 9.99 s (9985 ms), Installation 9 m 49 s (589148 ms).
Installation of archive file '[/opt/hxe/installer/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/XSACSHINE04_2.ZIP]' finished successfully.
To see installation logs execute 'xs display-installation-logs 3001 -scv'.

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

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 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    71518  71235  1.9 1880592 279788      \_ hdbwebdispatcher

The following services must be running:

• hdbnameserver
• hdbcompileserver
• hdbindexserver
• 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:

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.

XSA Engine

As you have installed the Server + Applications binary (hxe.tgz + hxexsa.tgz), you can test your XSA installation with the following instructions.

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

https://<hostname>:39030

A success page displays with a list of important application URLs :

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 39030 | grep LISTEN

And the expected result should be:

tcp   0   0 0.0.0.0:39090    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.

XSA Admin Cockpit

You need now to execute the following commands:

sudo su -l hxeadm

xs login -u xsa_admin -p "<master-password>"

Then execute the following command to view the list of XSA applications and their statuses:

xs apps

Note: When you run the xs apps command for the first time, it may take 1-2 minutes for the system to return the list of XSA applications.

Note: This command may fail due to a missing SSL certificate.

To fix this problem, you will need to set up the certificate for your client.
The above example show the local path, therefore if you want to run the following from a different machine you will have to transfer the available on the SAP HANA, express edition server machine to the client machine first and adjust the command path.

xs api https://<hostname>:39030 -cacert /hana/shared/HXE/xs/controller_data/controller/ssl-pub/router/default.root.crt.pem

Check that the application cockpit-admin-web-app is shown as STARTED with 1/1 instances in the list of XSA applications using the following command:

xs apps | grep cockpit-admin-web-app

Note: Normally it takes a few minutes for XSA services to start. However. depending on your machine, it can take over 30 minutes for XSA services to begin. If the service doesn’t show STARTED and doesn’t show 1/1 instances, keep waiting until the service is enabled.

Open in your browser the URL for the cockpit-admin-web-app application (here as an example: https://my.hostname:51043 from the screenshot).

Note: the host name and port will be different from the screenshot.

Note: If you receive a Forbidden message while accessing the URL, this means that you currently have a pending session with a different user name. Opening a new browser window or using the incognito mode usually help solve this issue.

Warning: If you are using a browser from outside your the server itself, your network host name resolution may not allow you to use the host name displayed in the list.

Therefore you may need to either:
- make sure your server is properly registered in your DNS
- replace the host name by the host IP address
- configure your host file

Then, you can login using XSA_ADMIN as the username and the master password provided during the installation.

When you connect for the first time, you will receive a message regarding missing COCKPIT_ADMIN role collection. Accept the COCKPIT_ADMIN role collection to be added to the XSA_ADMIN user.

Login again using XSA_ADMIN as the username and the master password.

Make sure to logout before moving to the next step.

SAP Web IDE for SAP HANA

SAP Web IDE for SAP HANA is a browser-based integrated development environment for the development of applications comprised of extensive SAP HANA data models, business logic, and web-based UIs.

Before installing the Web IDE, you must have installed the Applications* package.

You need now to execute the following commands:

sudo su -l hxeadm

xs login -u xsa_admin -p "<master-password>"

Where <master-password> is the XSA_ADMIN password which should be the master password:

Check that the application webide shows STARTED in the list of XSA applications, and has 1/1 instances using the following command:

xs apps | grep webide

If the list shows 0/1 in the instance column, this means that the application is not started, as the startup process can take a few minutes to complete.

Get application URL using the following command:

xs app webide -urls

Open the returned URL in your browser.

Note: If you receive a Forbidden message while accessing the URL, this means that you currently have a pending session with a different user name. Opening a new browser window or using the incognito mode usually help solve this issue.

Warning: If you are using a browser from outside your the server itself, your network host name resolution may not allow you to use the host name displayed in the list.

Therefore you may need to either:
- make sure your server is properly registered in your DNS
- replace the host name by the host IP address
- configure your host file

This should give you access to the SAP Web IDE for SAP HANA login screen.

Use the XSA_DEV user and credentials that was created during the installation process to login.

You should then reach the following screen:

SAP HANA Interactive Education (SHINE)

SAP HANA Interactive Education (SHINE) makes it easy to learn how to build applications on SAP HANA Extended Application Services Advanced Model.

You need now to execute the following commands:

sudo su -l hxeadm

xs login -u xsa_admin -p "<master-password>"
xs app shine-web -urls

Where <master-password> is the XSA_ADMIN password which should be the master password:

You will get the SHINE application URL. Open the returned URL in your browser.

This should give you access to the SAP HANA Interactive Education login screen.

Use the XSA_SHINE user credentials to login (provided during the installation).

You should then reach the following screen:

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;"

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.

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.

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 memory usage before and after the process are displayed.

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;"

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):

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

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.

Using the Console Mode

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

And the complete list of values for the linuxx86_64 platform: