check_oracle_health missing?

[jenstar13]

Hi,
I went to use the oracle server wizard to monitor a database, and the system doesn't have the plugin check_oracle_health
I did an updatedb and searched with no luck
# locate check_oracle_health
/usr/local/nagios/share/pnp/templates.dist/check_oracle_health_connection-time.php
/usr/local/nagios/share/pnp/templates.dist/check_oracle_health_pga-in-memory-sort-ratio.php
/usr/local/nagios/share/pnp/templates.dist/check_oracle_health_redo-io-traffic.php
/usr/local/nagios/share/pnp/templates.dist/check_oracle_health_switch-interval.php
/usr/local/nagios/share/pnp/templates.dist/check_oracle_health_tablespace-usage.php

So i searched this forum, and found you sent people to
https://labs.consol.de/nagios/check_ora ... index.html

I got the tar.gz file, but we are a total RPM shop and there's no spec file in the folder for me to even use rpmbuild
do you have a rpm for this check, or a place where i can get the plugin already compiled to add to XI?

[scottwilkerson]

Here is the document you need
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[jenstar13]

I have oracle already installed
the problem is when invoking the plugin check oracle health, I found it did not exist, and I was looking for an rpm install or a spec file for the plugin. I'm not sure why you have a wizard without the plugin on the machine
if you lost me, this is the wizard

oraclewizard.png

and that uses this command

oracle_command.png

and that check_oracle_health is not on the machine

[scottwilkerson]

When you ran the install script from page 3 of that document did you get any errors?

Code: Select all

chmod +x oracleinstall.sh
./oracleinstall.sh

This script downloads and installs the plugin

[jenstar13]

oh great, our System engineers and DBA's install all the oracle and perl programs needed on their own.
I opened the ticket from the point of view of someone who already had oracle installed from Oracle already

sorry
is there a way to download the plugin directly?

[scottwilkerson]

These command should do it

Code: Select all

cpan -i DBD::Oracle
wget "http://assets.nagios.com/downloads/nagiosxi/packages/check_oracle_health-1.7.3.tar.gz"
tar xvf check_oracle_health-1.7.3.tar.gz

(
	cd check_oracle_health-1.7.3
	./configure
	make && make install
)
mkdir /var/tmp/check_oracle_health
chown -R nagios /var/tmp/check_oracle_health

[jenstar13]

do you have a Spec file for that tar file so I can make a rpm.
as I said above we avoid installing anything outside of a RPM for easier control

[scottwilkerson]

do you have a Spec file for that tar file so I can make a rpm.
as I said above we avoid installing anything outside of a RPM for easier control

No we do not, it must be compiled