Oracle plugin

[Dermot Duffy]

I brought the sqlplus binary across from the db server but I get the following error..

# ldd /usr/local/instantclient_10_2/sqlplus
/usr/local/instantclient_10_2/sqlplus: error while loading shared libraries: /usr/lib/libclntsh.so.10.1: ELF file data encoding not little-endian

Is there any way to load these shared libraries onto the nagios server?


From: Ismael Puerto [mailto:ismael.puerto at seres.es]
Sent: 17 November 2011 16:30
To: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] Oracle plugin

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<mailto: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<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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111117/80016272/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