Oracle plugin

[deek]

Hi team ,

We are trying to monitor Oracle database on our test Nagios core box . I have followed this document https://assets.nagios.com/downloads/nag ... ios-XI.pdf and installed the plugin . But im getting below error , im not sure what dependency needs to be installed .

[nagios@abc~]$ /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/21/client64/lib ORACLE_HOME=/usr/lib/oracle/21/client64 /usr/local/nagios/libexec/check_oracle_health --connect 'xyz:1521/XOEMQA' --username 'name' --password 'pwd' --mode tablespace-usage --name DBATOOLS --warning 85 --critical 90
CRITICAL - cannot connect to xyz:1521/XOEMQA. install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /usr/local/nagios/libexec /home/nagios/perl5/lib/perl5/5.26.3/x86_64-linux-thread-multi /home/nagios/perl5/lib/perl5/5.26.3 /home/nagios/perl5/lib/perl5/x86_64-linux-thread-multi /home/nagios/perl5/lib/perl5 /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at (eval 14) line 3.
Compilation failed in require at (eval 14) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed
at /usr/local/nagios/libexec/check_oracle_health line 6151.

I have tried executing below commands as well but still getting an error . Could you please guide us .
cd /tmp
wget http://www.cpan.org/modules/by-module/D ... .83.tar.gz
tar zxvf DBD-Oracle-1.83.tar.gz cd DBD-Oracle-1.74
perl Makefile.PL -l
make && make test
make install

[deek]

We have reinstalled again wit oracle client version 21.5 . Still we are getting below error .

[nagios@abc~]$ /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/21.5/client64/lib ORACLE_HOME=/usr/lib/oracle/21.5/client64 /usr/local/nagios/libexec/check_oracle_health --connect 'xyz:1521/XOEMQA' --username 'username' --password 'pwd' --mode tablespace-usage --name DBATOOLS --warning 85 --critical 90
CRITICAL - cannot connect to xyz:1521/XOEMQA. DBI object version 1.641 does not match bootstrap parameter 1.643 at /usr/lib64/perl5/DynaLoader.pm line 210.
BEGIN failed--compilation aborted at /usr/local/lib64/perl5/DBI.pm line 284.
Compilation failed in require at /usr/local/nagios/libexec/check_oracle_health line 6101.

[ssax]

You mention Nagios Core but it's posted in the XI section, is this related to a Nagios Core system or a Nagios XI system?

What OS/version is abc running?

Code: Select all

uname -a
cat /etc/*release

[deek]

We are testing in the Nagios core box . We do already have the plugin working in Nagios XI .

[nagios@abc~]$ uname -a
Linux abc 4.18.0-348.7.1.el8_5.x86_64 #1 SMP Wed Dec 8 21:51:17 EST 2021 x86_64 x86_64 x86_64 GNU/Linux

[nagios@abc~]$ cat /etc/*release
NAME="Red Hat Enterprise Linux"
VERSION="8.5 (Ootpa)"
ID="rhel"
ID_LIKE="fedora"
VERSION_ID="8.5"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Red Hat Enterprise Linux 8.5 (Ootpa)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:8::baseos"
HOME_URL="https://www.redhat.com/"
DOCUMENTATION_URL="https://access.redhat.com/documentation ... e_linux/8/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 8"
REDHAT_BUGZILLA_PRODUCT_VERSION=8.5
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="8.5"
Red Hat Enterprise Linux release 8.5 (Ootpa)
Red Hat Enterprise Linux release 8.5 (Ootpa)

[ssax]

I looked up your account and a Nagios Core support plan has not been registered with this username. If this is an error, please let me know and I’ll work with the sales department to get this resolved quickly.

Otherwise, if you’re interested in Nagios Core Support plan, please contact [email protected] or feel free to post your question on the Nagios Core general support forum.

Thank you!

[deek]

We were able to install it .
But i do have one query , Is there a way to monitor the ASM instance status using check_oracle_health

[ssax]

You can see the help option of the plugin to see the supported checks:

/usr/local/nagios/libexec/check_oracle_health -h

Code: Select all

[root@xi8 check_oracle_health-3.2.1.8]# /usr/local/nagios/libexec/check_oracle_health -h |grep asm
       asm-diskgroup-usage              (Used space in diskgroups)
       asm-diskgroup-free               (Free space in diskgroups)
       list-asm-diskgroups              (convenience function which lists all asm diskgroups)

If you need further help, all other Core System related questions (even for plugin support) should be submit to the Nagios Core general support forum.

Thank you! Locking and marking as resolved.