HANA Secondary Database Connection Issues on ECC Oracle system #ATR

[AJAYTR_ATR66]

#ATR

Informative Note - Created this blog to provide information on issues faced while setting up secondary database connection via DBCO/SLT Setup.

Prerequisites: Knowledge on SLT Configuration, DBCO Connection, Unzipping SAR file, SAP Software download center.

I have tried to create secondary database connection to HANA system from ECC Oracle in DBCO as well as during SLT Setup. While testing the connection, I could see connection failed with "Could not load database library" Error.

To connect any HANA database from other Non HANA source system, HANA DB library files (hdbclient) required for communicating with HANA database.

Once hana client installed, we need to set hdbclient location in the environment library path since oracle system won't able to fetch executable path of hdbclient automatically. Setting library path will detect and use hana client library files automatically when creating a DBCO - HANA Database connection.

HDBClient Installation :

https://me.sap.com/notes/1597627 - 1597627 - SAP HANA connection (You can find few information from this note)

Note: It is not recommended to use hdblcm since we are going to install hana client only.

Download SAP HANA CLIENT software from SAP Software Download center.

Command to install: ./hdbinst -a client -p /usr/sap/SID/hdbclient -s SID

SET LIBRARY path:

Once hana client installed, Edit the LD_LIBRARY PATH environment variable and add our HDBCLIENT path as well. All the SIDADM environment variables will be stored inside /home/sidadm - sh script files. Files will always be in hidden state. Use find command in Putty/Mobaxterm/Winscp to locate and edit.

find . -type f -exec grep -l "LD_LIBRARY_PATH" {} /dev/null \;

Added below two entries in ./.dbenv_hostname.csh ./.dbenv.csh.   [Take backup before editing file]

Note : Don't add env path outside for loop/globally. It will create "Modifier error/ Path not specified" and system won't start. Add within for loop.

Restart SAP system and it's service. Check whether environment variable reflects fine with hdbclient path.

We have installed hana client as well as done environment variable setup for oracle system to pickup hdbclient path automatically.

Connection to HANA system from Oracle system works fine now.

Test done using "ADBC_TEST_CONNECTION" - SE38 program execution.

      Usual Scenario - HANA Client can be installed during Hana database installation - Globally/Separately in defined path. It will also setup executable path for hana client automatically.

Our Scenario - Since we need to setup HANA database connection from Oracle system, Hana client needs to be installed manually with permanent executable path for hdbclient execution. If multiple application server resides in landscape and SLT needs to be configured to use multiple app servers, you can install hdbclient on common mount point (/sapmnt/SID/exe/uc/) accordingly. Hana Client path needs to be added in variable path manually in all application servers.

 

Thanks for Visiting !