Oracle plugin

Ismael Puerto ismael.puerto at seres.es
Thu Nov 17 17:29:56 CET 2011


For your info:

This is the library necessary for execute sqlplus

[root at openbravo ~]# ldd /usr/oracle/product/11.2.0/bin/sqlplus
        linux-vdso.so.1 =>  (0x00007fffe74b3000)
        libsqlplus.so => /usr/oracle/product/11.2.0/lib/libsqlplus.so
(0x00002b93dc626000)
        libclntsh.so.11.1 =>
/usr/oracle/product/11.2.0/lib/libclntsh.so.11.1 (0x00002b93dc80d000)
        libnnz11.so => /usr/oracle/product/11.2.0/lib/libnnz11.so
(0x00002b93df148000)
        libdl.so.2 => /lib64/libdl.so.2 (0x000000312f200000)
        libm.so.6 => /lib64/libm.so.6 (0x000000312f600000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x000000312fa00000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x0000003132a00000)
        libc.so.6 => /lib64/libc.so.6 (0x000000312ee00000)
        libaio.so.1 => /usr/lib64/libaio.so.1 (0x00002b93df521000)
        /lib64/ld-linux-x86-64.so.2 (0x000000312ea00000)


On 11/17/2011 05:05 PM, Dermot Duffy wrote:
>
> No, oracle is not installed on this box.  Am trying to connect from
> the nagios server to the oracle db server via sqlplus.
>
>  
>
> *From:*Ismael Puerto [mailto:ismael.puerto at seres.es]
> *Sent:* 17 November 2011 15:57
> *To:* nagios-users at lists.sourceforge.net
> *Subject:* Re: [Nagios-users] Oracle plugin
>
>  
>
> Do yo have ORACLE_LIB?
>
> #echo $ORACLE_LIB
>
> On 11/17/2011 04:20 PM, Dermot Duffy wrote:
>
> Hi,
>
>  
>
> Thanks for the feedback but it unfortunately makes no difference.....
>
>  
>
> # ln -s /usr/local/instantclient_10_2/libsqlplus.so /usr/lib/libsqlplus.so
>
> #
>
> # sqlplus username/passowrd at ip_address:port/SSID
>
> sqlplus: error while loading shared libraries: libclntsh.so.11.1:
> cannot open shared object file: No such file or directory
>
> You have new mail in /var/spool/mail/root
>
>  
>
>  
>
> *From:*Ismael Puerto [mailto:ismael.puerto at seres.es]
> *Sent:* 17 November 2011 14:56
> *To:* nagios-users at lists.sourceforge.net
> <mailto:nagios-users at lists.sourceforge.net>
> *Subject:* Re: [Nagios-users] Oracle plugin
>
>  
>
> ln -s/usr/local/instantclient_10_2/libsqlplus.so /usr/lib/libsqlplus.so
>
> On 11/17/2011 03:16 PM, Dermot Duffy wrote:
>
> Hi,
>
>  
>
> I have installed the "check_oracle_instance" plugin but I am having
> some issues with sqlplus.
>
>  
>
> http://exchange.nagios.org/directory/Plugins/Databases/Oracle/Check-Oracle-status-%26-health-without-install-Oracle-client/details
>
>  
>
> The nagios compiles correctly so the config is good however when I
> attempt to connect to the db via my nagios server I get the following:
>
>  
>
> # which sqlplus
>
> /usr/bin/sqlplus
>
>  
>
> # sqlplus username/passowrd at ip_address:port/SSID                  
> #substituted with my own credentials
>
> sqlplus: error while loading shared libraries: libsqlplus.so: cannot
> open shared object file: No such file or directory
>
> You have new mail in /var/spool/mail/root
>
>  
>
> The lib is available:
>
> # find / -name libsqlplus.so
>
> /usr/local/instantclient_10_2/libsqlplus.so
>
>  
>
> # ll /usr/local/instantclient_10_2/libsqlplus.so
>
> -rwxrwxrwx 1 root root 865995 Nov 17 12:05
> /usr/local/instantclient_10_2/libsqlplus.so
>
>  
>
> Any ideas how I can resolve this?
>
>  
>
> R,
>
> D.
>
>  
>
>  
>
>
>
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure 
> contains a definitive record of customers, application performance, 
> security threats, fraudulent activity, and more. Splunk takes this 
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
>
>
>
>
>
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net <mailto:Nagios-users at lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null
>
>
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure 
> contains a definitive record of customers, application performance, 
> security threats, fraudulent activity, and more. Splunk takes this 
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
>
>
>
>
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net <mailto:Nagios-users at lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure 
> contains a definitive record of customers, application performance, 
> security threats, fraudulent activity, and more. Splunk takes this 
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
>
>
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111117/7d86dc10/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null


More information about the Users mailing list