Adding HANA in Solution Manager

[Former Member]

Hi everyone!

We are following guide for adding SAP HANA in Managed Systems on SAP Solution Manager 7.1 sps12. The guide is:

Managed System Setup of HANA in Solution Manager 7.1 - SAP Solution Manager Setup - SCN Wiki

We installed Diagnostics Agent and Host Agent, and created monitoring user in Hana database. Now we are in a step:

Setup HDB User Store for SAP Host Agent

We perfomed everything without errors, but when running command:

/usr/sap/hostctrl/exe/sapdbctrl status <SID> -t hdb

we get error ERROR: Failed to open trace file dev_sapdbctrl: Permission denied

when we run the command as root, we get error:

ERROR: Failed to load database control library 'libsapdbhdbctrl.so' for database type 'hdb'. Please check your installation.

What could be the issue here?

SAP Host Agent Version is 198, we used kernel 721 EXT UC Kernel for SWPM SP7 - Linux on X86_64 

for  DA installation.

I would appreciate any help.

Best Regards.

[srinivasan_vinayagam · Accepted solution]

Hi

http://wiki.scn.sap.com/wiki/display/SMSETUP/Managed+System+Setup+of+HANA+in+Solution+Manager+7.1

[francois_keen]

Hello Zelkjo

The SCN wiki mentions to run the sapdbctrl command as ROOT and to do so, you need to set add the SAP Host Agent exe directory to the LD_LIBRARY_PATH env variable

as root:

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/sap/hostctrl/exe

export LD_LIBRARY_PATH

/usr/sap/hostctrl/exe/sapdbctrl status <HANA_SID> -t hdb

Just something to mention that is not in the wiki, if you're on HANA SP09 on a scaleout, your SAP Host Agent need to be on patch  201+ as per note 2106505

Cheers

Francois

[srinivasan_vinayagam]

Hi Zeljko,

[srinivasan_vinayagam]

Hi Zeljiko,

This is Permission issue.

You can give permission to root user and run with root user.

or Better try with DAAADM or SAPADM or SIDADM.

give 755 permission to /usr/sap/hostctrl/exe/ for user daaadm, sapadm and sidadm

Regards,

V Srinivasan

[Former Member]

Permissions are fine, we checked it.

Now we also have problem starting HLM, when trying to register HANA in SLD.