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

[Yves Mettier]

Hello,

I have already have similar failures (with another lib, but the 
resolution is similar).

  su - oracle
  ldd /usr/lib64/collectd/oracle.so

-> success

  su - root (the account collectd runs with)
  ldd /usr/lib64/collectd/oracle.so

-> some libs are missing

This may help you. Or not. Give a try...

Regards,
Yves

Le 2017-02-23 12:10, Sent, B.T.C. (Bob) a écrit :
> 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.
> ------------------------------------------------------------------------------------------------------
> 
> _______________________________________________
> collectd mailing list
> collectd at verplant.org
> https://mailman.verplant.org/listinfo/collectd