Skip to Content
Technical Articles
Author's profile photo Mihail Sevdiev

Configuring SAP Solution Manager 7.2 to support SAP HANA DB instances

Solution Manager 7.2 support for SAP HANA DB

In this short blog post, we will configure the Solution Manager 7.2 system to be able to manage SAP HANA instances. By default SAP Solution Manager 7.2 does not have all of the prerequisites to work with HANA systems (depending on the kernel version: as of kernel release 720 patch 400 and above all DB libraries are included in each SAPEXEDB), also the client is missing. To be able to add a HANA system we need to install the SAP HANA DB client to the Solution Manager’s ABAP host. The process is described in SAP NOTE 1597627, but there are some specifics, so the procedure is the following:

1. Check that the KERNEL has the default libraries for HANA:

Look at /usr/sap/<SID>/SYS/exe/run for the file “dbhdbslib.so”:

If it is missing, please upgrade the KERNEL. If the file it is present, continue to the next step

2. Download the HDB Client from SAP marketplace according to the OS of the ABAP server

Download the latest version and extract the contents of the SAR archive:

 

3. Install the client.

If you follow the note mentioned before, the installation of the client should be in this directory: /usr/sap/<SID>/hdbclient, but if you do so, you will have problems with the path later. It is better to install it in:

/usr/sap/hdbclient Also you can share the directory and use it for other nodes if you have a different scenario for the Solution Manager landscape. This will save you time, when you have to upgrade the version.

Go the the location of the extracted files and run the following command with root user:

./hdbinst -a client -p /usr/sap/hdbclient -s <SID>

As a result, the file libSQLDBCHDB.so should be present in the newly installed client. You can check it:

After this, we should add the following path variables to the <SID>adm user and restart the machine:

echo 'export PATH=$PATH:/usr/sap/hdbclient'  >> ~/.sapenv.sh

echo 'export HDB_CLIENT_HOME=/usr/sap/hdbclient'  >> ~/.sapenv.sh

echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/sap/hdbclient'  >> ~/.sapenv.sh

and

echo 'set path = ($path /usr/sap/hdbclient)'  >> ~/.sapenv.csh
echo 'setenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}:"/usr/sap/hdbclient"'  >> ~/.sapenv.csh
echo 'setenv HDB_CLIENT_HOME /usr/sap/hdbclient'  >> ~/.sapenv.csh

Keep in mind, that it is possible to have the file sapenv in format sapenv_<HOSTNAME>. The script will look for this file if present and will load it, so you should add the environmental variables to it also, otherwise they will not be loaded.

After the restart you can login with the <SID>adm user and check if the environmental variables are loaded properly:

vsol:soladm 56> env | grep hdbclient

PATH=/sapdb/clients/SOL/bin:/sapdb/programs/bin:/home/soladm/bin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/sap/SOL/SYS/exe/uc/linuxx86_64:/usr/sap/SOL/SYS/exe/run:/home/soladm:.:/usr/sap/hdbclient

PWD=/usr/sap/hdbclient

LD_LIBRARY_PATH=/usr/sap/SOL/SYS/exe/run:/usr/sap/SOL/SYS/exe/uc/linuxx86_64:/usr/sap/hdbclient:/sapdb/clients/SOL/lib

HDB_CLIENT_HOME=/usr/sap/hdbclient

Now you can start the instance again and it will load successfully the hdbclient and all the needed libraries.

This solves the issue with the missing libraries and hdbclient for HANA on Solution Manager. To add a new HANA system, please check my blog post on the topic: Adding HANA system to Solution Manager 7.2 – step by step guide.

More info for shared directory for updates, please check note 1943235. If you have any questions or you want to share something on the topic, you can always write a comment here or just send me a message. I will be more than happy to answer you.

* the screenshots in this blog post are made by me (Mihail Sevdiev) and are from systems, part of a test environment.

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Suheb Ahmed
      Suheb Ahmed

      Perfect explanation, Thanks a  lot  Sevdies for the blog.

      Author's profile photo Mihail Sevdiev
      Mihail Sevdiev
      Blog Post Author

      Hello Suheb, thank you for your feedback. If you need help or more information, you can always send me a message, will be happy to answer.

      Author's profile photo Philip Seman
      Philip Seman

      Does the HDB Client need to be installed where the HANA server resides or just on the solution manager system?

      I was able to install on the solution manager system, but get an error on step 5 of managed system for the database extractor setup to Check if HANA Client Software is installed.

      Author's profile photo Mihail Sevdiev
      Mihail Sevdiev
      Blog Post Author

      Hello Philip Seman

      The HDB Client should be installed on the Solution Manager’s application server and it should be set in the environmental variables for the <SID>adm user.

      Can you please check what following command, executed with “<SID>adm” is returning:

      env | grep hdbclient

      Thanks!