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

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
nagedre
Posts: 29
Joined: Thu Sep 26, 2019 11:45 am

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

Post by nagedre »

Hi Tgriep,
Still Iam facing same issue.

root@hpsatvld5302:/tmp # subscription-manager list --available
-bash: subscription-manager: command not found
root@hpsatvld5302:/tmp #
root@hpsatvld5302:/tmp # yum clean all
Loaded plugins: langpacks
Cleaning repos: UENG.2019.3.0.RHEL epel nagios-base nagiosxi-deps
Other repos take up 2.0 M of disk space (use --verbose for details)
You have new mail in /var/spool/mail/root
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 #
User avatar
tgriep
Madmin
Posts: 9177
Joined: Thu Oct 30, 2014 9:02 am

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

Post by tgriep »

I need to get some information from the server so can you run the following commands as root and post the output?

Code: Select all

uname -a
cat /etc/*release*
ip addr
ping -c 5 download.fedoraproject.org
ping -c 5 mirrors.fedoraproject.org
Be sure to check out our Knowledgebase for helpful articles and solutions!
nagedre
Posts: 29
Joined: Thu Sep 26, 2019 11:45 am

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

Post by nagedre »

root@hpsatvld5302:~ # uname -a
Linux hpsatvld5302 3.10.0-957.27.2.el7.x86_64 #1 SMP Tue Jul 9 16:53:14 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
root@hpsatvld5302:~ #
root@hpsatvld5302:~ # cat /etc/*release*
NAME="Red Hat Enterprise Linux Server"
VERSION="7.6 (Maipo)"
ID="rhel"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.6"
PRETTY_NAME="Red Hat Enterprise Linux Server 7.6 (Maipo)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:7.6:GA:server"
HOME_URL="https://www.redhat.com/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7"
REDHAT_BUGZILLA_PRODUCT_VERSION=7.6
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="7.6"
Red Hat Enterprise Linux Server release 7.6 (Maipo)
Red Hat Enterprise Linux Server release 7.6 (Maipo)
cpe:/o:redhat:enterprise_linux:7.6:ga:server
PATCHBUNDLE="2019.3.0"
PATCHBUNDLE="2019.2.0"
PATCHBUNDLE="2019.2.0"
PATCHBUNDLE="2019.3.0"
root@hpsatvld5302:~ #
root@hpsatvld5302:~ #
root@hpsatvld5302:~ # ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
link/ether 00:50:56:b5:25:27 brd ff:ff:ff:ff:ff:ff
inet 10.198.4.220/22 brd 10.198.7.255 scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::250:56ff:feb5:2527/64 scope link
valid_lft forever preferred_lft forever
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
link/ether 00:50:56:b5:dd:f9 brd ff:ff:ff:ff:ff:ff
inet 10.228.174.98/23 brd 10.228.175.255 scope global eth1
valid_lft forever preferred_lft forever
inet6 fe80::250:56ff:feb5:ddf9/64 scope link
valid_lft forever preferred_lft forever
root@hpsatvld5302:~ #
root@hpsatvld5302:~ # ping -c 5 download.fedoraproject.org
ping: download.fedoraproject.org: Name or service not known
root@hpsatvld5302:~ #
root@hpsatvld5302:~ #
root@hpsatvld5302:~ #
root@hpsatvld5302:~ # ping -c 5 mirrors.fedoraproject.org
ping: mirrors.fedoraproject.org: Name or service not known
root@hpsatvld5302:~ #
root@hpsatvld5302:~ #
User avatar
tgriep
Madmin
Posts: 9177
Joined: Thu Oct 30, 2014 9:02 am

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

Post by tgriep »

First, your server is not setup to use DNS servers to resolve hosts and that has to be fixed.

See this link I found.
https://www.cyberciti.biz/faq/change-dn ... hat-linux/

The 2 ping commands have to function so yum can download the packages from that server.

Second, you will have to register your server with Redhat do download the optional packages.

Try this to do that.

Code: Select all

yum install -y yum-utils
yum-config-manager --enable rhel-7-server-optional-rpms
If it fails, you will have to contact Redhat for support.

Third, the server needs to be able to access the internet to download packages it needs for the plugins.

All of the above needs to be resolved.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked