--- parser: v2 author_name: John Currie author_profile: https://github.com/JCurrie27 primary_tag: software-product>sap-hana\,-express-edition tags: [ tutorial>beginner,software-product>sap-hana\,-express-edition ] time: 10 slug: hxe-ua-install-using-docker canonical_url: https://developers.sap.com/tutorials/hxe-ua-install-using-docker --- # Installing SAP HANA, express edition with Docker Install SAP HANA, express edition with Docker. ## You will learn - How to install SAP HANA, express edition on your preferred Docker setup ## Intro This tutorial will show you how to install a **server-only** installation of SAP HANA, express edition on your Docker installation. This version of SAP HANA, express edition does not contain XSC. If you wish to install SAP HANA, express edition on a different virtual machine, or you want a custom setup on your Linux machine, see the [Virtual Machine](hxe-ua-installing-vm-image) or [Binary Method](hxe-ua-installing-binary) installation guides. Before you begin, ensure your proxy settings have been properly set up. See [**HTTP/HTTPS proxy**](https://docs.docker.com/engine/admin/systemd/#httphttps-proxy) in the Docker documentation. --- SAP HANA, express edition is a streamlined version of the SAP HANA platform which enables developers to jump-start application development in the cloud or personal computer to build and deploy modern applications that use up to 32GB memory. SAP HANA, express edition includes the in-memory data engine with advanced analytical data processing engines for business, text, spatial, and graph data - supporting multiple data models on a single copy of the data. SAP HANA, express edition for Docker has been tested on the following Linux operating system versions: | Linux OS | OS Version | Docker Editions | --- | --- | --- | | `SLES` | `12.2, 12.3, 12.4` | [Community](https://docs.docker.com/engine/install/sles/) | **This installation does not support Docker for Windows or Docker for Mac.** ### Install Docker Download and install the appropriate Docker Edition for your system. Visit the [Docker Community Edition](https://store.docker.com/search?offering=community&type=edition) or [Docker Enterprise Edition](https://store.docker.com/search?offering=enterprise&type=edition) lists for more information and to download Docker for your machine. > **Note:** Ensure your proxy settings have been properly set up. See [**HTTP/HTTPS proxy**](https://docs.docker.com/engine/admin/systemd/#httphttps-proxy) in the Docker documentation. ### Log Into Docker To log into your Docker account, run: ```bash sudo docker login ``` Follow the prompts and provide your Docker ID and password. ### (Optional) Test Your Docker Installation Test your Docker installation by running the "Hello World" container application. Run the following command from your Docker-enabled command prompt: ```bash sudo docker run --name helloWorld alpine echo hello ``` If successful, the following should display: ``` Unable to find image 'alpine:latest' locally latest: Pulling from library/alpine 88286f41530e: Pull complete Digest: sha256: Status: Downloaded newer image for alpine:latest hello ``` If `hello` is printed, you have successfully pulled the container image **alpine** (a demo Linux distribution), and ran the instance of the container `helloWorld`, and ran the command `echo` with an input parameter of `hello`. If you **did not** get this output, the Docker installation has not been completed or the Docker daemon can not connect to the internet. Review the process and check the [Docker Documentation](https://docs.docker.com/get-started/) for more information in troubleshooting your Docker installation. Remove the alpine image with the following command: ```bash sudo docker image rm alpine -f ``` ### Download the SAP HANA, express edition Image from the Docker Library Go to [https://hub.docker.com/u/saplabs](https://hub.docker.com/u/saplabs). Select hanaexpress. Copy the Docker pull address. Here's an example: ```bash sudo docker pull saplabs/hanaexpress ``` Open your Docker-enabled command line and use the Docker pull address to download the image. This loads the SAP HANA, express edition image. To ensure that the image was loaded successfully, run: ```bash sudo docker images ``` The SAP HANA, express edition image will be listed as `hanaexpress`. > Note: > You may have to log into your Docker account to pull the image. From your Docker-enabled command line, run `docker login` and follow the prompts to enter your Docker ID and password. Once you have logged in, try the pull command again. ### Edit the host sysctl.conf file Before you can start the container, ensure that the following parameters are set in your host's `/etc/sysctl.conf` file. The host can be a virtual machine, physical machine, or a cloud instance. ```bash fs.file-max=20000000 fs.aio-max-nr=262144 vm.memory_failure_early_kill=1 vm.max_map_count=135217728 net.ipv4.ip_local_port_range=40000 60999 ``` To edit the `sysctl.conf` file, use the `vi` command to open the file and press `i` to switch to interactive mode. Edit the file as necessary, hit the `esc` key, and type and enter `:wq!` to write and save the changes. ### Set Up Password for SAP HANA, express edition To make your system more secure, you specify your own password before you create your container. This is done by creating a `json` file as opposed to having a default password. The file can be stored locally or on another system accessible by URL. If the file is to be stored locally, store it in */data/*. Create the `json` file: ```bash vi .json ``` Press `i` to start editing and use one of the following formats to create the file: ```bash { "master_password" : "" } ``` or: ```bash { "system_user_password" : "", "default_tenant_system_user_password" : "" } ``` Here is an example: ``` { "master_password" : "HXEHana1" } ``` Press `esc` and then enter `wq!` to write and save the file. This file serves as the master password for your SAP HANA, express edition users. The password must comply 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 quotation marks). * Cannot contain dictionary words * Cannot contain simplistic or systemic values, like strings in ascending or descending numerical or alphabetical order You must then add permissions for this file to be readable by the `hxeadm` user in the container. Change permissions with: ```bash sudo chmod 600 /data//.json sudo chown 12000:79 /data//.json ``` Be sure to do this with each `json` file you use for your Docker containers. Make a note of the path to the `json` file. You will need this to load the SAP HANA, express edition container. ### Start SAP HANA, express edition Container Use the SAP HANA, express edition image to create a container. ```bash sudo docker run -p 49013:49013 -p 49015:49015 -p 49041-49045:49041-49045 -p 1138-1139:1128-1129 -p 59023-59024:59013-59014 -p 49030-49033:49030-49033 -p 51000-51060:51000-51060 -p 53075:53075 -h hxehost -v /data/hxe:/hana/mounts --ulimit nofile=1048576:1048576 --sysctl kernel.shmmax=1073741824 --sysctl net.ipv4.ip_local_port_range='60000 65535' --sysctl kernel.shmmni=524288 --sysctl kernel.shmall=8388608 --name --agree-to-sap-license --passwords-url --proxy-host proxy.wdf.sap.corp --proxy-port 8080 --no-proxy localhost,127.0.0.1,hxehost,hxehost.localdomain ``` For information on the TCP/IP port ranges, see [TCP/IP Ports of All SAP Products](https://help.sap.com/viewer/ports). Filter the list by "SAP Cloud Platform". Example: ``` sudo docker run -p 39013:39013 -p 39017:39017 -p 39041-39045:39041-39045 -p 1128-1129:1128-1129 -p 59013-59014:59013-59014 -v /data/express_edition:/hana/mounts \ sudo docker run -p 49013:49013 -p 49015:49015 -p 49041-49045:49041-49045 -p 1138-1139:1128-1129 -p 59023-59024:59013-59014 -p 49030-49033:49030-49033 -p 51000-51060:51000-51060 -p 53075:53075 -h hxehost -v /data/hxe:/hana/mounts --ulimit nofile=1048576:1048576 --sysctl kernel.shmmax=1073741824 --sysctl net.ipv4.ip_local_port_range='60000 65535' --sysctl kernel.shmmni=524288 --sysctl kernel.shmall=8388608 --name hxexsa1 hanaexpressxsa:latest --agree-to-sap-license --passwords-url file:///hana/mounts/password.json --proxy-host proxy.wdf.sap.corp --proxy-port 8080 --no-proxy localhost,127.0.0.1,hxehost,hxehost.localdomain ``` This example creates the SAP HANA, express edition container with the name `express_edition`. This process will take several minutes. The prompt will read `Startup finished` once the container has been successfully running. This container starts in detached mode so you will need to open another command prompt to continue. > **Note:** > If you placed the password file in `/data//.json`, substitute `file://` with `file:///hana/mounts/.json`. > > Check if the password file `/hana/mounts/.json` was deleted after the SAP HANA, express edition container starts. If not, you can manually delete it. If the `JSON` file you are using is an *http* or *https* URL, you can leave out the `-v` option. > >Still having problems? Check that the string containing the mount is an absolute path. > **Note:** > For Linux kernel versions earlier than 4, omit the `net.ipv4.ip_local_port_range` option. > **Note:** > If the Docker container fails to create an SAP HANA instance, you will need to remove the Docker container to try again. Run `docker rm ` to remove the container. Additionally, you will need to delete the files created in the `/data/directory_name/` directory. ### Log into SAP HANA, express edition Container To start your SAP HANA, express edition container, run the following command: ```bash sudo docker exec -it bash ``` Example: ``` sudo docker exec -it express_edition bash ``` ### (Optional) Test the Container When you are logged into the SAP HANA, express edition container, you can test your installation by entering the following: ```bash whoami ``` You should be logged in as `hxeadm`, the default SAP HANA, express edition user. You can also enter the following: ```bash HDB info ``` And you should see the following services running: * `hdbnameserver` * `hdbcompileserver` * `hdbdiserver` * `hdbwebdispatcher` ### (Optional) Log Into System or Tenant Database You can log into the system database with the following command: ```bash hdbsql -i 90 -d -u SYSTEM -p ``` You can log into your tenant database with the following command: ```bash hdbsql -i 90 -d -u SYSTEM -p ``` __JDBC__ --- To log into your system database via JDBC, use the following command: ```bash jdbc:sap://:39017/?databaseName= ``` To log into your tenant database via JDBC, use the following command: ```bash jdbc:sap://:39041/?databaseName= ``` For detailed information on the connection properties you can specify when connecting using JDBC, see [JDBC Connection Properties](https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/latest/en-US/109397c2206a4ab2a5386d494f4cf75e.html) in the *SAP HANA Client Interface Programming Reference*. >**Note**: Are you trying to connect to SAP HANA, express edition on Docker from an application or command line on the host OS? You will need to make the IP of the container on the internal container network visible to the host. > >**Example: Docker Machine on Windows** - In this example, 192.168.99.100 is the external `docker-machine` `vm` and `hxehost` is the container host name: > >```bash >ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'system') SET ('public_hostname_resolution', 'use_default_route') = 'name' WITH RECONFIGURE; >ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'system') SET ('public_hostname_resolution', 'map_hxehost') = '192.168.99.100' WITH RECONFIGURE; >``` >**Example: Docker Machine on Mac** - In this example, `localhost` is the Docker daemon running on the Mac, and `hxehost` is the container host name: > >```bash >ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'system') SET ('public_hostname_resolution', 'use_default_route') = 'name' WITH RECONFIGURE; >ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'system') SET ('public_hostname_resolution', 'map_hxehost') = 'localhost' WITH RECONFIGURE; >``` ### (Optional) Create Additional SAP HANA, express edition Containers You will need to repeat the previous steps of creating a directory and `JSON` password for each additional SAP HANA, express edition container you wish to create. ```bash sudo docker run -p 10013:39013 -p 10017:39017 -p 10041-10045:39041-39045 -p 10028-10029:1128-1129 -p 19013-19014:59013-59014 -v /data/:/hana/mounts \ --ulimit nofile=1048576:1048576 \ --sysctl kernel.shmmax=1073741824 \ --sysctl net.ipv4.ip_local_port_range='40000 60999' \ --sysctl kernel.shmmni=524288 \ --sysctl kernel.shmall=8388608 \ --name \ store/saplabs/hanaexpress:2.00.054.00.20210603.1 \ --passwords-url OR http/https://> --agree-to-sap-license ``` This process will take several minutes. The prompt will read `Startup finished` once the container has been successfully running. This container starts in detached mode so you will need to open another command prompt to continue. ### (Optional) Update Your Docker Image Set the root password and login. ```bash docker exec -it -u root bash ``` ```bash passswd ``` Check the update utility. It can be found in the `adm/bin` directory. Use `HXECheckUpdate_linux.bin`. Run this to check for, and download, the latest files. Follow the prompts to download the new files. By default, they will be downloaded to `/usr/sap//home/Downloads`. The downloaded file will be `hxe.tgz`. Extract the contents of the packages. Example: ```bash tar -zxf /hxe.tgz tar -zxf /hxexsa.tgz ``` Navigate to the directory where you extracted the packages: ```bash cd /HANA_EXPRESS_20/ ``` > Note: > If the update you are applying includes the Applications package, increase your allocated memory by 3GB and run `./hxe_gc.sh`. Follow the prompts and then continue with the procedure. As the root user, run the upgrade script to update the server: ```bash sudo ./hxe_upgrade.sh ``` Follow the prompts to complete the server update. ### -Help Command The following is a list of options available for the `sudo docker run store/saplabs/hanaexpress` command. ``` sudo docker run store/saplabs/hanaexpress:2.00.XXX.XX.XXXXXXXX.X -h usage: [options] --dont-check-consistency Skip consistency check between mount points --dont-check-mount-points Skip check for allowed mount points --dont-check-version Skip compatibility check of current and last HANA version --dont-check-system Skip check for incompatible /proc/sys values --dont-exit-on-error Halt script on error to allow root cause analysis (MUST NOT be used in production) --license-url URL for a license file (json) Format: {"landscape-id":"<8-4-4-4-12 GUID>", "license":""} --passwords-url URL for a password file (json) Format: {"master_password":""} or {"system_user_password":"","default_tenant_system_user_password":""} --print Print and exit, options are: README hdb_version --agree-to-sap-license Indicates you agree to the SAP Developer Center Software Developer License Agreement. ``` ### Additional Information - [TCP/IP Ports of All SAP Products](https://help.sap.com/viewer/ports)