How can we monitor Database (SQL/oracle) from Nagios

This board serves as an open discussion and support collaboration point for Nagios XI. NOTE: Nagios XI customers should use the Customer Support forum to obtain expedited support.

How can we monitor Database (SQL/oracle) from Nagios

Postby nagedre » Thu Oct 31, 2019 10:11 am

How can we monitor Database (SQL/oracle) from Nagios
nagedre
 
Posts: 20
Joined: Thu Sep 26, 2019 11:45 am

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby mcapra » Thu Oct 31, 2019 11:52 am

Here's the official documentation for monitoring:

I *think* there's also Configuration Wizards within the Nagios XI interface for all of the above.
Former Nagios employee
http://www.mcapra.com/
User avatar
mcapra
 
Posts: 3584
Joined: Thu May 05, 2016 3:54 pm

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby mbellerue » Thu Oct 31, 2019 1:50 pm

Thanks for jumping in, Matt! There are indeed wizards for each of those products.

nagedre, do those docs answer your question?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
mbellerue
 
Posts: 766
Joined: Fri Jul 12, 2019 11:10 am

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby benjaminsmith » Thu Oct 31, 2019 1:51 pm

Thanks @mcapra! Always helpful.

That's right, there are several configuration wizards in Nagios XI dedicated to Oracle monitoring. However, you'll need to follow the documentation to install the required dependencies before running.

Let us know if you need any assistance.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
benjaminsmith
 
Posts: 1836
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby nagedre » Mon Nov 04, 2019 7:59 am

Let me go through the Docs mbellerue.
Thanks for sharing
nagedre
 
Posts: 20
Joined: Thu Sep 26, 2019 11:45 am

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby benjaminsmith » Mon Nov 04, 2019 5:04 pm

Let me go through the Docs mbellerue.
Thanks for sharing

Sounds good. Just let us know if you need anything.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
benjaminsmith
 
Posts: 1836
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby nagedre » Tue Nov 05, 2019 5:51 am

Hi Benjamin,

I tried to Install & Configure The Oracle Client & Plugins but here Iam struck with the command ./oracleinstall.sh , could you please verify this and updat eme what to do next on this.

root@hpsatvld5302:~ # cd /tmp
root@hpsatvld5302:/tmp # chmod +x oracleinstall.sh
root@hpsatvld5302:/tmp # ./oracleinstall.sh
#######################################
# #
# This is the installer script #
# for installing Oracle monitoring #
# libraries. #
# #
# Before you continue, be sure that #
# the oracle-basic, sqlplus and devel #
# are in the same directory as this #
# installer script. #
# #
#######################################
Loaded plugins: langpacks
UENG.2019.3.0.RHEL | 3.7 kB 00:00:00


One of the configured repositories failed (Unknown),
and yum doesn't have enough cached data to continue. At this point the only
safe thing yum can do is fail. There are a few ways to work "fix" this:

1. Contact the upstream for the repository and get them to fix the problem.

2. Reconfigure the baseurl/etc. for the repository, to point to a working
upstream. This is most often useful if you are using a newer
distribution release than is supported by the repository (and the
packages for the previous distribution release still work).

3. Run the command with the repository temporarily disabled
yum --disablerepo=<repoid> ...

4. Disable the repository permanently, so yum won't use it by default. Yum
will then just ignore the repository until you permanently enable it
again or use --enablerepo for temporary usage:

yum-config-manager --disable <repoid>
or
subscription-manager repos --disable=<repoid>

5. Configure the failing repository to be skipped, if it is unavailable.
Note that yum will try to contact the repo. when it runs most commands,
so will have to try and fail each time (and thus. yum will be be much
slower). If it is a very temporary problem though, this is often a nice
compromise:

yum-config-manager --save --setopt=<repoid>.skip_if_unavailable=true

Cannot retrieve metalink for repository: epel/x86_64. Please verify its path and try again
root@hpsatvld5302:/tmp #
nagedre
 
Posts: 20
Joined: Thu Sep 26, 2019 11:45 am

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby benjaminsmith » Tue Nov 05, 2019 11:26 am

Hello @nagedre,
Cannot retrieve metalink for repository: epel/x86_64. Please verify its path and try again
root@hpsatvld5302:/tmp #

It looks like the server does not have access to the epel repository. Which operating system are you using? You can check which repositories are installed by running the following command in RHEL/CentOS systems. Please post the output for us to review. Thanks.

Code: Select all
yum repolist -v
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
benjaminsmith
 
Posts: 1836
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby nagedre » Wed Nov 06, 2019 4:17 am

root@hpsatvld5302:~ # yum repolist -v
Not loading "rhnplugin" plugin, as it is disabled
Loading "langpacks" plugin
Adding en_US.UTF-8 to language list
Config time: 0.008
Yum version: 3.4.3
UENG.2019.3.0.RHEL | 3.7 kB 00:00:00


One of the configured repositories failed (Unknown),
and yum doesn't have enough cached data to continue. At this point the only
safe thing yum can do is fail. There are a few ways to work "fix" this:

1. Contact the upstream for the repository and get them to fix the problem.

2. Reconfigure the baseurl/etc. for the repository, to point to a working
upstream. This is most often useful if you are using a newer
distribution release than is supported by the repository (and the
packages for the previous distribution release still work).

3. Run the command with the repository temporarily disabled
yum --disablerepo=<repoid> ...

4. Disable the repository permanently, so yum won't use it by default. Yum
will then just ignore the repository until you permanently enable it
again or use --enablerepo for temporary usage:

yum-config-manager --disable <repoid>
or
subscription-manager repos --disable=<repoid>

5. Configure the failing repository to be skipped, if it is unavailable.
Note that yum will try to contact the repo. when it runs most commands,
so will have to try and fail each time (and thus. yum will be be much
slower). If it is a very temporary problem though, this is often a nice
compromise:

yum-config-manager --save --setopt=<repoid>.skip_if_unavailable=true

Cannot retrieve metalink for repository: epel/x86_64. Please verify its path and try again
You have new mail in /var/spool/mail/root
root@hpsatvld5302:~ # date
Wed Nov 6 03:17:11 CST 2019
root@hpsatvld5302:~ #
nagedre
 
Posts: 20
Joined: Thu Sep 26, 2019 11:45 am

Re: How can we monitor Database (SQL/oracle) from Nagios

Postby tgriep » Wed Nov 06, 2019 10:58 am

The output messages suggest that either the server cannot connect to the internet to download other packages needed for the plugin or that the Redhat subscription is not enabled on the server which is causing the packages from downloading.

This message hints to that.
Not loading "rhnplugin" plugin, as it is disabled

You can run this to see if the server's subscription is enabled with Redhat.
Code: Select all
subscription-manager list --available


Subscribe to Redhat as it is needed.

Then clear out the yum cache by running this
Code: Select all
yum clean all


Try the oracleinstall.sh script again.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
tgriep
Madmin
 
Posts: 8340
Joined: Thu Oct 30, 2014 9:02 am

Next

Return to Nagios XI

Who is online

Users browsing this forum: No registered users and 15 guests