error while loading shared libraries: libSQLDBCHDB.so

While installing SAP HANA Database system I have received following error.

Do you want to create a customer incident? You can now:
Choose OK to create the support SAPCAR archive SUPPORT.SAR
Choose Stop to stop the task and continue later

We don't know what causing the issue and need to find the error from log file.

I found below error in log file "R3load.exe.log" under "/install/tmp/sapinst_instdir/BS2013SR2/ERP607SR2/HDB/INSTALL/DISTRIBUTED/ABAP/DB"
usr/sap/BWE/SYS/exe/uc/linuxx86_64/R3load: error while loading shared libraries: libSQLDBCHDB.so: cannot open shared object file: No such file or directory

By looking the error it looks like shared libraries libSQLDBCHDB is missing. This library is related to hana client and installation will use the client to connect to the database.

I want to make sure that library exists or not and ran find command. I was able to find the library

find . -name libSQLDBCHDB.so -print
./HANA/hdbclient/libSQLDBCHDB.so

That means library exists but not able to use this connect to HANA database. It looks like the issue is with Environment variable

When you come across this issue with HANA Client, make sure to check following
1. LD_LIBRARY_PATH is set properly
2. SAPSYSTEMNAME & DBMS_TYPE is set

In my case LD_LIBRARY_PATH library path does not have "hdbclcient" path, after updating correct path I was able to install successfully.

LD_LIBRARY_PATH=/usr/sap/HANA/SYS/exe/run:/usr/sap/HANA/SYS/exe/uc/linuxx86_64:/usr/sap/HANA/hdbclient

Note: You might receive this error during the maintenance also

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com