Error when running Oracle Query

[Frédéric GRANAT]

Hi,
I created a query, by using the "Oracle query" configuration wizard.
When I try to "run check command" on the service, I've got :

Code: Select all

[[email protected] ~]$ source /usr/local/nagiosxi/etc/configwizards/oracle/oracle && /usr/local/nagios/libexec/check_oracle_health --connect 'xxxxxxxx:xxxxxx/xxxxxxx' --username 'system' --password 'xxxxxxx' --mode sql --name="select file_name as name,bytes/1024/1024 size_mo from dba_data_files where file_name like '%UNDO%'" --warning 1000 --critical 2000
CRITICAL - cannot connect to xxxxxxxx:xxxxxx/xxxxxxx. install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.12.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
 at (eval 19) line 3
Compilation failed in require at (eval 19) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at /usr/local/nagios/libexec/check_oracle_health line 6151

Could you please help me ?

[benjaminsmith]

Hello Frederic,

Did you just setup monitoring with the Oracle Wizard? It looks like there is a path error. Make sure you have the environment variables set correctly.

x86: /usr/lib/oracle/<YOUR ORACLE VERSION>/client
x86_64: /usr/lib64/oracle/<YOUR ORACLE VERSION>/client

What is the output of this command?

Code: Select all

cat /usr/local/nagiosxi/etc/configwizards/oracle/oracle 

Documentation
How To Install & Configure The Oracle Client & Plugins

[Frédéric GRANAT]

Hi,
Here it is :

[root@nagiosxi ~]# cat /usr/local/nagiosxi/etc/configwizards/oracle/oracle
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib
export ORACLE_HOME=/usr/lib/oracle/11.2/client
[root@nagiosxi ~]#

Do you think I have to install Oracle as described in the link you gave me ?

[benjaminsmith]

Hello,

Can you post the output of the following command to check the paths. Thanks.

Code: Select all

locate libclntsh.so.12.1
#OR
find / -name libclntsh.so.12.1

[Frédéric GRANAT]

Hi,
Here it is :
[root@nagiosxi /]# find / -name libclntsh.so.12.1
/usr/lib/oracle/12.2/client64/lib/libclntsh.so.12.1

[lmiltchev]

I would assume you followed our official documentation for installing the oracle client:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

I see a mismatch in the client version and architecture... In the "/usr/local/nagiosxi/etc/configwizards/oracle/oracle" file, you are using version 11.2 (32-bit), but it seems like, you have 12.2 (64-bit). You may try to reinstall the oracle client or just modify the "/usr/local/nagiosxi/etc/configwizards/oracle/oracle" file if you think the client was installed correctly.

[Frédéric GRANAT]

Hi,
I don't know if the client was installed correctly.
If it has been installed it was during the NagiosXI install : does the NagiosXI install package includes an Oracle client install ?

[lmiltchev]

If it has been installed it was during the NagiosXI install : does the NagiosXI install package includes an Oracle client install ?

No, we do not include Oracle client plugins with Nagios XI for legal reasons. They must have been installed by you or someone on your team on your system. See page 2 of our document:

Due to legal reasons, Nagios cannot provide direct download links to these RPMs so you will have to go to Oracle's website and download them.

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

I would recommend that you remove the old version of Oracle clients completely, install the new one (using the correct package as far as architecture goes, e.g. 64-bit vs 32-bit), and modify the "/usr/local/nagiosxi/etc/configwizards/oracle/oracle" file accordingly.

[Frédéric GRANAT]

Hi,

According to the document "Installing and configuring Oracle pluggins"...I followed the steps till page 2 and ran oracleinstall.sh.
According to that same document :
"At the very end, will dump out some variables that you will need to apply to your particular
case. In my case they look like this:
ORACLE_HOME=/usr/lib/oracle/12.1/client64
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib"

In my case I didn't see that at the end of the install (I attached the log of the execution)
I think the install failed but I don't know why.

Could you please help me ?

[lmiltchev]

Did you remove the old version of Oracle clients completely before trying to perform the new install?

I see this in the log:

Examining oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm: oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64
oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm: does not update installed package.
Examining oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm: oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64
oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm: does not update installed package.
Examining oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm: oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64
oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm: does not update installed package.
Nothing to do

which leads me to believe that your "old" oracle packages were not removed prior to running the script.