Page 1 of 1
After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Tue May 27, 2014 8:04 am
by 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
Re: After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Tue May 27, 2014 10:22 am
by 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.
Re: After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Tue May 27, 2014 1:56 pm
by 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.
Re: After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Tue May 27, 2014 1:57 pm
by scottwilkerson
This seems like you may have the wrong version of perl in your path the CPAN is using...
Where is Oracle.so ?
Re: After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Wed May 28, 2014 2:10 am
by 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
Re: After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Wed May 28, 2014 3:05 am
by 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)
Re: After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Wed May 28, 2014 3:41 am
by 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!!!!!!!
Re: After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Wed May 28, 2014 9:16 am
by 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?
After upgrade to Nagios XI 2014R1.1 - problem Oracle Tablesp
Posted: Thu Jun 05, 2014 7:10 am
by cokj72
tmcdonald wrote: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
Re: After upgrade to Nagios XI 2014R1.0 - problem Oracle
Posted: Thu Jun 05, 2014 1:17 pm
by 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.