Configuring SAP Solution Manager 7.2 to support SAP HANA DB instances

[former_member688309]

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.