You will learn
In this tutorial, you will install the dependencies needed and configure your SUSE Linux Enterprise system for the setup and execution of SAP HANA, express edition.
Install SAP HANA 2.0, express edition on SUSE Linux Enterprise (Server + Applications)
Previous
Next
Install SAP HANA 2.0, express edition on SUSE Linux Enterprise (Server + Applications)
Learn how to prepare your SUSE Linux Enterprise system to install and test SAP HANA, express edition
Details
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 22 and SUSE Linux Enterprise Server for SAP Applications, 12.2 for
x86-64on an Intel NUC.
Step 1: Verify your Machine Requirements
Step 2: Prepare Your System
Step 3: Reboot your system
Step 4: Register for SAP HANA, express edition
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 SLES server.
Save the Platform-independent Download Manager file directly on your SLES system.
Note: If your SLES 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 SLES 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 SLES server.
Note: Again, if your SLES 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 SLES 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 SLES 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 SLES 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.
Step 6: Install SAP HANA, express edition
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 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:
hdbnameserverhdbcompileserverhdbindexserverhdbwebdispatcher
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 appscommand 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:
Best Practice: Deactivate the SYSTEM user
Best Practice: Backups
Best Practice: Set the Global Memory Allocation Limit
Best Practice: Run the Memory Management Script
Best Practice: Text Analysis As Embedded Preprocessor
Best Practice: Firewall Configuration
Appendix: Download Manager