You can set TSN_ADMIN =<path_where_tnsnames.ora> is located. I how this can help you.
2014-07-02 21:18 GMT+02:00 Giovanni Torres <giovtor...@hotmail.com>: > I successfully compiled the oracle plugin for collectd but I can't get it > to work. > > I installed oracle-instantclient12.1-devel-12.1.0.1.0-1.x86_64 and > oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64. I set $ORACLE_HOME in > /etc/profile.d and I set the LD_LIBRARY_PATH in /etc/ld.so.conf.d. > > Here is my oracle config in /etc/collectd.d/ > > LoadPlugin oracle > > <Plugin oracle> > > <Query "io_per_tablespace"> > Statement "SELECT sum(vf.PHYBLKRD)*8192 AS PHY_BLK_R, \ > sum(vf.PHYBLKWRT)*8192 AS PHY_BLK_W, \ > 'tablespace' AS i_prefix, \ > dt.tablespace_name \ > FROM ((dba_data_files dd JOIN v$filestat vf ON > dd.file_id = vf.file# ) \ > JOIN dba_tablespaces dt ON dd.tablespace_name = > dt.tablespace_name) \ > GROUP BY dt.tablespace_name" > <Result> > Type "io_octets" > InstancesFrom "i_prefix" "TABLESPACE_NAME" > ValuesFrom "PHY_BLK_R" "PHY_BLK_W" > </Result> > </Query> > > <Database "DB1"> > ConnectID "DEV" > Username "collectd" > Password "secret" > Query "io_per_tablespace" > </Database> > > </Plugin> > > > This is the log entry from the oracle plugin: > > [2014-07-02 15:12:24] oracle plugin: o_read_database (db = DB1, query = > (none)): OCILogon("DEV") failed: ORA-12154: TNS:could not resolve the > connect identifier specified > > > I have a tnsnames.ora in $ORACLE_HOME/network/admin but the daemon doesn't > seem to be looking for it: > > strace -e access,open /usr/sbin/collectd -C /etc/collectd.conf -f > > open("/etc/collectd.d/oracle.conf", O_RDONLY) = 3 > open("/usr/lib64/collectd/oracle.so", O_RDONLY) = 6 > open("/usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1", O_RDONLY) = 6 > open("/usr/lib/oracle/12.1/client64/lib/libnnz12.so", O_RDONLY) = 6 > open("/usr/lib/oracle/12.1/client64/lib/libons.so", O_RDONLY) = 6 > open("/usr/lib/oracle/12.1/client64/lib/libclntshcore.so.12.1", O_RDONLY) > = 6 > open("/usr/lib/oracle/12.1/client64/lib/libociei.so", O_RDONLY) = 5 > open("/usr/lib/oracle/12.1/client64/network/admin/oraaccess.xml", > O_RDONLY) = -1 ENOENT (No such file or directory) > access("/usr/lib/oracle/12.1/client64/network/admin/oraaccess.xml", F_OK) > = -1 ENOENT (No such file or directory) > access("/usr/lib/oracle/12.1/client64/network/admin/oraaccess.xml", F_OK) > = -1 ENOENT (No such file or directory) > open("/usr/lib/oracle/12.1/client64/network/admin/oraaccess.xml", > O_RDONLY) = -1 ENOENT (No such file or directory) > access("/usr/lib/oracle/12.1/client64/network/admin/sqlnet.ora", F_OK) = 0 > open("/usr/lib/oracle/12.1/client64/network/admin/sqlnet.ora", O_RDONLY) = > 5 > access("/root/.sqlnet.ora", F_OK) = -1 ENOENT (No such file or > directory) > open("/etc/orabasetab", O_RDONLY) = -1 ENOENT (No such file or > directory) > open("/usr/lib/oracle/12.1/client64/install/orabasetab", O_RDONLY) = -1 > ENOENT (No such file or directory) > access("/usr/lib/oracle/12.1/client64/network/admin/sqlnet.ora", F_OK) = 0 > open("/usr/lib/oracle/12.1/client64/network/admin/sqlnet.ora", O_RDONLY) = > 6 > access("/usr/lib/oracle/12.1/client64/network/admin/intchg.ora", F_OK) = > -1 ENOENT (No such file or directory) > access("/etc/intchg.ora", F_OK) = -1 ENOENT (No such file or > directory) > access("/usr/lib/oracle/12.1/client64/network/admin/intchg.ora", F_OK) = > -1 ENOENT (No such file or directory) > access("/usr/lib/oracle/12.1/client64/network/admin/tnsnav.ora", F_OK) = > -1 ENOENT (No such file or directory) > access("/etc/tnsnav.ora", F_OK) = -1 ENOENT (No such file or > directory) > access("/usr/lib/oracle/12.1/client64/network/admin/tnsnav.ora", F_OK) = > -1 ENOENT (No such file or directory) > > > It doesn't appear to be looking for tnsnames.ora. My $ORACLE_HOME is > /usr/lib/oracle/12.1/client64. This is the same ORACLE_HOME that was used > when compiling the plugin, if that matters. > > > Can someone point out what I may be doing wrong or what I have missed to > get this to work? > > > Thanks, > Giovanni > > _______________________________________________ > collectd mailing list > collectd@verplant.org > http://mailman.verplant.org/listinfo/collectd > -- Att Toni Moreno 699706656 *Si no quieres perderte en el olvido tan pronto como estés muerto y corrompido, * *escribe cosas dignas de leerse, o haz cosas dignas de escribirse.* *Benjamin Franklin*
_______________________________________________ collectd mailing list collectd@verplant.org http://mailman.verplant.org/listinfo/collectd