Page 1 of 1

check_oracle_health missing?

Posted: Tue Jul 10, 2018 5:56 am
by 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?

Re: check_oracle_health missing?

Posted: Tue Jul 10, 2018 9:39 am
by scottwilkerson

Re: check_oracle_health missing?

Posted: Tue Jul 10, 2018 10:00 am
by 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

Re: check_oracle_health missing?

Posted: Tue Jul 10, 2018 10:58 am
by 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

Re: check_oracle_health missing?

Posted: Tue Jul 10, 2018 11:18 am
by 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?

Re: check_oracle_health missing?

Posted: Tue Jul 10, 2018 2:16 pm
by 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

Re: check_oracle_health missing?

Posted: Wed Jul 11, 2018 5:06 am
by 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

Re: check_oracle_health missing?

Posted: Wed Jul 11, 2018 8:31 am
by scottwilkerson
jenstar13 wrote: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