HDBDAEMON error when trying to start - libhdbbasement.so no such file?

[Former Member]

Hi All!

I'm having an issue on our DR HANA server (SITE B).  System Replication was failing due to timeouts and when it wasn't failing it was always stuck as syncing around 25%.  So I disabled replication and planned to recreate it from scratch.  Upon doing so I could not start the DB on SITE B.  Turns out HDBDAEMON is not running.

          hdbdaemon, HDB Daemon, GRAY, Stopped, , , 53072

When I attempt to start HDBDAEMON I get the following message:

     ./hdbdaemon: error while loading shared libraries: libhdbbasement.so: cannot open shared object file: No such file or directory

This file does exist and I've given everyone full rwx to it.  I'm stumped and nothing on SCN or elsewhere has given me an idea of what to try next.

Any suggestions?

Thanks,

Jeff.

[greg_niecka]

Hi,

for issue:

error while loading shared libraries: libhdbbasement.so: cannot open shared object file: No such file or directory

run this "exports" logged as ndbadm (database user) to Linux:

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/sap/NDB/HDB00/exe

export PATH=/usr/sap/NDB/HDB00/exe:$PATH

export DIR_EXECUTABLE=/usr/sap/NDB/HDB00/exe

export SAP_RETRIEVAL_PATH=/usr/sap/NDB/HDB00/name_of_your_linux

Cheers!

[Former Member]

Thanks for your reply Greg!

The issue was resolved. The lib*.so files were missing from the LD_LIBRARY_PATH. I did a copy paste of lib*.so files from exe folder to the path mentioned under LD_LIBRARY_PATH. And it started.

Best Regards,

Sona Kumari

[Former Member]

Hi Jeff,

We're facing the same problem. Could you please let us know how did you resolve the issue?

Thanks in advance

Sona

[Former Member]

Hey Jeff,

Assumption - You are working as and executing commands as <sid>adm.

1. execute "which libhdbbasement.so" (post output here)

The file should exist as /usr/sap/<SID>/HDBnn/exe/libhdbbasement.so

2. execute "echo $PATH" (post output here)

3. In the directory /usr/sap/<SID>/home verify the existence of at least the following files.

.profile

.sapenv.sh

.sapenv.csh

.cshrc

.bashrc

If as I suspect one or some of these files is missing, then please proceed as per the solution I provided in another thread:

Good Luck.

Kindest Regards,

Amerjit

[Former Member]

Thanks Amerjit.

1. execute "which libhdbbasement.so" (post output here)

which: no libhdbbasement.so in (/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib64/jvm/jre/bin:/opt/ibutils/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/opt/ibm/saphana/bin:/usr/lpp/mmfs/bin:/opt/MegaRAID/storcli:/opt/ibm/toolscenter/asu)

The file should exist as /usr/sap/<SID>/HDBnn/exe/libhdbbasement.so

2. execute "echo $PATH" (post output here)

/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib64/jvm/jre/bin:/opt/ibutils/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/opt/ibm/saphana/bin:/usr/lpp/mmfs/bin:/opt/MegaRAID/storcli:/opt/ibm/toolscenter/asu

3. In the directory /usr/sap/<SID>/home verify the existence of at least the following files.

.profile (yes, the file exists)

.sapenv.sh (yes, the file exists)

.sapenv.csh (yes, the file exists)

.cshrc (yes, the file exists)

.bashrc (yes, the file exists)

[Former Member]

Hey Jeff,

I can see from the output of "echo $PATH" that you are missing the path to the HDB binaries in your environment.

The normal order of execution post logon is as follows.

.profile => .bashrc => .sapenv.sh

.profile

# SAP environment

if [ -f $HOME/.bashrc ]; then

     . $HOME/.bashrc

fi # SAP environment

.bashrc

# set the env variable USER for sapgenpse

USER=`id | awk -F\( '{print $2}' | awk -F\) '{print $1}'`

export USER

# SAP environment

if [ -f $HOME/.sapenv.sh ]; then

     . $HOME/.sapenv.sh

fi # SAP environment

# User specific environment

if [ -f $HOME/.customer.sh ]; then

     . $HOME/.customer.sh

fi # User specific environment

source ~/.sapenv.sh

.sapenv.sh

Too much to post here.

As <sid>adm run the following command in your /usr/sap/<SID>/home directory:

source ~/.sapenv.sh

After the above command, run any HDB command (eg: HDB info) and then run the "which" command from my first reply again. If all is well you should get output showing you where the command is being found.

You get the gist of it. Either run the "." files one by one in the order I listed further up or just cut to the chase and run the .sapenv.sh

Good luck.

Cheers,

Amerjit