After upgrade to Nagios XI 2014R1.0 - problem Oracle

[cokj72]

After upgrade to Nagios XI 2014R1.0 my agent DB Oracle is ALL in error:

Code: Select all

Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.11.1: cannot open shared object file: No such file or dire

if I try "Test Check Command" from Nagios CCM I get this error:

Code: Select all

install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.11.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
 at (eval 18) line 3
Compilation failed in require at (eval 18) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at /usr/local/nagios/libexec/check_oracle_health line 4755

[cokj72]

is the same mistake that I had here:
http://support.nagios.com/forum/viewtop ... =6&t=21699

I've change the ORACLE_HOME and LD_LIBRARY_PATH on the command check_xi_oracleserverspace, bat the problem remains ...

I also tried to make these commands on the server nagios:

Code: Select all

[root@nagios ~]# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
[root@nagios ~]# export LD_LIBRARY_PATH=$ORACLE_HOME/lib
[root@nagios ~]# cpan -i DBD::Oracle
CPAN: Storable loaded ok (v2.20)
Going to read '/root/.cpan/Metadata'
  Database was generated on Thu, 17 Oct 2013 06:41:03 GMT
Going to read '/root/.cpan/sources/authors/01mailrc.txt.gz'
CPAN: Compress::Zlib loaded ok (v2.005)
Can't call method "value" on an undefined value at /usr/lib64/perl5/IO/Uncompress/RawInflate.pm line 64.

[sreinhardt]

Could you show us the command and service definition please? Feel free to sanitize as needed, but I have a feeling I know what the issue is, and would like to confirm.

[scottwilkerson]

This seems like you may have the wrong version of perl in your path the CPAN is using...

Where is Oracle.so ?

Code: Select all

locate "Oracle.so"

[cokj72]

What should I check ?

[root@nagios ~]# locate "Oracle.so"
-bash: locate: command not found

I urgency to solve the problem, I have 3 db Oracle production is not monitored

[cokj72]

Solved, bat 1 DB
I've change the Oracle_Home and LB_Oralce_path
from:
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client
to:
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64

now 1DB is OK, but other 2 DB have this erros:

Code: Select all

CRITICAL - cannot connect to 192.168.110.238:1521\/trgdb.fpf.local. ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)

[cokj72]

Solved.
the string of the service check i've one / ...

Code: Select all

check_xi_oracleserverspace!--connect "192.168.110.238:1521\/trgdb.fpf.local" --username system --password "Oracle11g" --mode flash-recovery-area-usage --warning 90 --critical 98!!!!!!!

OK is

Code: Select all

check_xi_oracleserverspace!--connect "192.168.110.238:1521/trgdb.fpf.local" --username system --password "Oracle11g" --mode flash-recovery-area-usage --warning 90 --critical 98!!!!!!!

[tmcdonald]

Sorry we didn't get to you sooner; our offices were not open when you posted last. Do you have any remaining issues relating to the Oracle problems after upgrade?

[cokj72]

Sorry we didn't get to you sooner; our offices were not open when you posted last. Do you have any remaining issues relating to the Oracle problems after upgrade?

This problem is OK.

Now I've upgrade Nagios to version XI 2014R1.1 and now I' ve the one problem with 1 service Oracle Tablespace.
This service:
Tablespace Can Allocate Next
reporting this error:
(Service check timed out after 60.01 seconds)

this error on 3 different DB

[slansing]

Does the listener that your oracle DBA gave you to use have access to view that specific metric? The listener service that your XI server's address connects to will need to have access on all of those fronts if you want to use those checks.