[collectd] collect 5.5.0 / centos 6.8: oracle plugin - Oracle plugin does not work

[Sent, B.T.C. (Bob)]

Hi All,

I have an issue with compiling the oracle plugin for Collectd, : lt_dlopen ("/usr/lib64/collectd/oracle.so") failed: file not found  while the file exists.

Collectd Version: 5.5.0

Symptom:
# sudo /opt/collectd/sbin/collectd
ERROR: lt_dlopen ("/usr/lib64/collectd/oracle.so") failed: file not found. The most common cause for this problem is missing dependencies. Use ldd(1) to check the dependencies of the plugin / shared object.

Environment:
OS: Centos 6.8
DB: Oracle Enterprise 11.2

Oracle environment settings:
export ORACLE_HOME=/oracle/product/11.2.0/db
export LD_LIBRARY_PATH=/oracle/product/11.2.0/db/lib:/usr/lib
export TNS_ADMIN=/oracle/admin/network/etc

# extract from config.log (whole log file could be sent)
configure:23255: gcc -c -g -O2  -I/oracle/product/11.2.0/db/rdbms/public conftest.c >&5
configure:23255: gcc -E  -I/oracle/product/11.2.0/db/rdbms/public conftest.c
configure:23277: gcc -o conftest -g -O2  -I/oracle/product/11.2.0/db/rdbms/public  conftest.c -ldl  -L/oracle/product/11.2.0/db/lib -lclntsh >&5
configure:39435: running /bin/sh ./configure --disable-option-checking '--prefix=/opt/collectd'  '--bindir=/usr/sbin' '--libdir=/usr/lib64' '--sysconfdir=/etc' '--enable-oracle' '--enable-ltdl-convenience' --cache-file=/dev/null --srcdir=.
BUILD_WITH_ORACLE_CFLAGS='-I/oracle/product/11.2.0/db/rdbms/public'
BUILD_WITH_ORACLE_LIBS='-L/oracle/product/11.2.0/db/lib -lclntsh'

However, looks like there are no missing dependencies
# ldd /usr/lib64/collectd/oracle.so
                linux-vdso.so.1 =>  (0x00007fff18bc9000)
                libclntsh.so.11.1 => /oracle/product/11.2.0/db/lib/libclntsh.so.11.1 (0x00007f62c8d61000)
                libdl.so.2 => /lib64/libdl.so.2 (0x00007f62c8b44000)
                libc.so.6 => /lib64/libc.so.6 (0x00007f62c87b0000)
                libnnz11.so => /oracle/product/11.2.0/db/lib/libnnz11.so (0x00007f62c83e8000)
                libm.so.6 => /lib64/libm.so.6 (0x00007f62c8163000)
                libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f62c7f46000)
                libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f62c7d2d000)
                libaio.so.1 => /lib64/libaio.so.1 (0x00007f62c7b2b000)
                /lib64/ld-linux-x86-64.so.2 (0x000000396b200000)

I really have no clue how to proceed.

regards,
Bob


----------------------------------------------------------------
ATTENTION:
The information in this e-mail is confidential and only meant for the intended recipient. If you are not the intended recipient, don't use or disclose it in any way. Please let the sender know and delete the message immediately.
------------------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.verplant.org/pipermail/collectd/attachments/20170223/a22f4f4a/attachment.html>