Page 1 of 1

Oracle Agent Issue

Posted: Mon Feb 06, 2017 6:17 pm
by raamardhani7
Hi Team,

I have recently upgraded nagios xi to the recent release. https://support.nagios.com/forum/viewto ... 16&t=41959

Post upgradation, we are seeing the issue with Oracle configurations, they are not working for us.

I followed the document to setup Oracle agent on the server RHEL.

Code: Select all

uname -i
x86_64

Code: Select all

uname
Linux
Tried installing 12 on the server, it failed stating the error.

Code: Select all

[root@lussvpnagiosxi00 tmp]# chmod +x oracleinstall.sh
[root@lussvpnagiosxi00 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: changelog, package_upload, product-id, rhnplugin, security, subscription-manager
This system is not registered with RHN Classic or RHN Satellite.
You can use rhn_register to register.
RHN Satellite or RHN Classic support will be disabled.
Setting up Install Process
epel/metalink                                                                                                                                 |  15 kB     00:00
nagios-base                                                                                                                                   | 1.5 kB     00:00
nagiosxi-deps                                                                                                                                 | 1.5 kB     00:00
rhel-6-server-extras-rpms                                                                                                                     | 1.8 kB     00:00
rhel-6-server-optional-rpms                                                                                                                   | 2.0 kB     00:00
rhel-6-server-rh-common-rpms                                                                                                                  | 2.1 kB     00:00
rhel-6-server-rpms                                                                                                                            | 2.0 kB     00:00
rhel-6-server-satellite-tools-6.2-rpms                                                                                                        | 2.1 kB     00:00
rhel-6-server-supplementary-rpms                                                                                                              | 2.0 kB     00:00
Package perl-YAML-0.70-4.el6.noarch already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package glibc.x86_64 0:2.12-1.166.el6_7.3 will be updated
---> Package glibc.x86_64 0:2.12-1.192.el6 will be an update
---> Package glibc-common.x86_64 0:2.12-1.166.el6_7.3 will be updated
---> Package glibc-common.x86_64 0:2.12-1.192.el6 will be an update
--> Processing Dependency: tzdata >= 2015g-4 for package: glibc-common-2.12-1.192.el6.x86_64
---> Package glibc-devel.x86_64 0:2.12-1.166.el6_7.3 will be updated
---> Package glibc-devel.x86_64 0:2.12-1.192.el6 will be an update
---> Package glibc-headers.x86_64 0:2.12-1.166.el6_7.3 will be updated
---> Package glibc-headers.x86_64 0:2.12-1.192.el6 will be an update
---> Package glibc-static.x86_64 0:2.12-1.192.el6 will be installed
---> Package glibc-utils.x86_64 0:2.12-1.166.el6_7.3 will be updated
---> Package glibc-utils.x86_64 0:2.12-1.192.el6 will be an update
--> Running transaction check
---> Package tzdata.noarch 0:2015g-2.el6 will be updated
---> Package tzdata.noarch 0:2016j-1.el6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================
 Package                              Arch                          Version                                 Repository                                          Size
=====================================================================================================================================================================
Installing:
 glibc-static                         x86_64                        2.12-1.192.el6                          rhel-6-server-optional-rpms                        1.4 M
Updating:
 glibc                                x86_64                        2.12-1.192.el6                          rhel-6-server-rpms                                 3.8 M
 glibc-common                         x86_64                        2.12-1.192.el6                          rhel-6-server-rpms                                  14 M
 glibc-devel                          x86_64                        2.12-1.192.el6                          rhel-6-server-rpms                                 989 k
 glibc-headers                        x86_64                        2.12-1.192.el6                          rhel-6-server-rpms                                 617 k
 glibc-utils                          x86_64                        2.12-1.192.el6                          rhel-6-server-rpms                                 172 k
Updating for dependencies:
 tzdata                               noarch                        2016j-1.el6                             rhel-6-server-rpms                                 454 k

Transaction Summary
=====================================================================================================================================================================
Install       1 Package(s)
Upgrade       6 Package(s)

Total download size: 22 M
Downloading Packages:
(1/7): glibc-2.12-1.192.el6.x86_64.rpm                                                                                                        | 3.8 MB     00:00
(2/7): glibc-common-2.12-1.192.el6.x86_64.rpm                                                                                                 |  14 MB     00:00
(3/7): glibc-devel-2.12-1.192.el6.x86_64.rpm                                                                                                  | 989 kB     00:00
(4/7): glibc-headers-2.12-1.192.el6.x86_64.rpm                                                                                                | 617 kB     00:00
(5/7): glibc-static-2.12-1.192.el6.x86_64.rpm                                                                                                 | 1.4 MB     00:00
(6/7): glibc-utils-2.12-1.192.el6.x86_64.rpm                                                                                                  | 172 kB     00:00
(7/7): tzdata-2016j-1.el6.noarch.rpm                                                                                                          | 454 kB     00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                 11 MB/s |  22 MB     00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : tzdata-2016j-1.el6.noarch                                                                                                                        1/13
  Updating   : glibc-common-2.12-1.192.el6.x86_64                                                                                                               2/13
  Updating   : glibc-2.12-1.192.el6.x86_64                                                                                                                      3/13
  Updating   : glibc-headers-2.12-1.192.el6.x86_64                                                                                                              4/13
  Updating   : glibc-devel-2.12-1.192.el6.x86_64                                                                                                                5/13
  Installing : glibc-static-2.12-1.192.el6.x86_64                                                                                                               6/13
  Updating   : glibc-utils-2.12-1.192.el6.x86_64                                                                                                                7/13
  Cleanup    : glibc-devel-2.12-1.166.el6_7.3.x86_64                                                                                                            8/13
  Cleanup    : glibc-headers-2.12-1.166.el6_7.3.x86_64                                                                                                          9/13
  Cleanup    : glibc-utils-2.12-1.166.el6_7.3.x86_64                                                                                                           10/13
  Cleanup    : glibc-common-2.12-1.166.el6_7.3.x86_64                                                                                                          11/13
  Cleanup    : glibc-2.12-1.166.el6_7.3.x86_64                                                                                                                 12/13
  Cleanup    : tzdata-2015g-2.el6.noarch                                                                                                                       13/13
Uploading Package Profile
  Verifying  : glibc-devel-2.12-1.192.el6.x86_64                                                                                                                1/13
  Verifying  : glibc-headers-2.12-1.192.el6.x86_64                                                                                                              2/13
  Verifying  : glibc-2.12-1.192.el6.x86_64                                                                                                                      3/13
  Verifying  : tzdata-2016j-1.el6.noarch                                                                                                                        4/13
  Verifying  : glibc-static-2.12-1.192.el6.x86_64                                                                                                               5/13
  Verifying  : glibc-common-2.12-1.192.el6.x86_64                                                                                                               6/13
  Verifying  : glibc-utils-2.12-1.192.el6.x86_64                                                                                                                7/13
  Verifying  : glibc-devel-2.12-1.166.el6_7.3.x86_64                                                                                                            8/13
  Verifying  : glibc-headers-2.12-1.166.el6_7.3.x86_64                                                                                                          9/13
  Verifying  : glibc-2.12-1.166.el6_7.3.x86_64                                                                                                                 10/13
  Verifying  : tzdata-2015g-2.el6.noarch                                                                                                                       11/13
  Verifying  : glibc-common-2.12-1.166.el6_7.3.x86_64                                                                                                          12/13
  Verifying  : glibc-utils-2.12-1.166.el6_7.3.x86_64                                                                                                           13/13

Installed:
  glibc-static.x86_64 0:2.12-1.192.el6

Updated:
  glibc.x86_64 0:2.12-1.192.el6           glibc-common.x86_64 0:2.12-1.192.el6     glibc-devel.x86_64 0:2.12-1.192.el6     glibc-headers.x86_64 0:2.12-1.192.el6
  glibc-utils.x86_64 0:2.12-1.192.el6

Dependency Updated:
  tzdata.noarch 0:2016j-1.el6

Complete!
Loaded plugins: changelog, package_upload, product-id, rhnplugin, security, subscription-manager
This system is not registered with RHN Classic or RHN Satellite.
You can use rhn_register to register.
RHN Satellite or RHN Classic support will be disabled.
Setting up Local Package Process
Examining oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm: oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64
Marking oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm to be installed
rhel-6-server-extras-rpms                                                                                                                     | 1.8 kB     00:00
rhel-6-server-optional-rpms                                                                                                                   | 2.0 kB     00:00
rhel-6-server-rh-common-rpms                                                                                                                  | 2.1 kB     00:00
rhel-6-server-rpms                                                                                                                            | 2.0 kB     00:00
rhel-6-server-satellite-tools-6.2-rpms                                                                                                        | 2.1 kB     00:00
rhel-6-server-supplementary-rpms                                                                                                              | 2.0 kB     00:00
Examining oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm: oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64
Marking oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm to be installed
Examining oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm: oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64
Marking oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-instantclient12.1-basic.x86_64 0:12.1.0.2.0-1 will be installed
---> Package oracle-instantclient12.1-devel.x86_64 0:12.1.0.2.0-1 will be installed
---> Package oracle-instantclient12.1-sqlplus.x86_64 0:12.1.0.2.0-1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================
 Package                                      Arch               Version                     Repository                                                         Size
=====================================================================================================================================================================
Installing:
 oracle-instantclient12.1-basic               x86_64             12.1.0.2.0-1                /oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64               185 M
 oracle-instantclient12.1-devel               x86_64             12.1.0.2.0-1                /oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64               1.9 M
 oracle-instantclient12.1-sqlplus             x86_64             12.1.0.2.0-1                /oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64             3.0 M

Transaction Summary
=====================================================================================================================================================================
Install       3 Package(s)

Total size: 190 M
Installed size: 190 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test


Transaction Check Error:
  file /usr/bin/sqlplus64 from install of oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64 conflicts with file from package oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64

Error Summary
-------------
So I've installed 11 on the server, it did installed without issues.

Code: Select all

[root@lussvpnagiosxi00 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: changelog, package_upload, product-id, rhnplugin, security, subscription-manager
This system is not registered with RHN Classic or RHN Satellite.
You can use rhn_register to register.
RHN Satellite or RHN Classic support will be disabled.
Setting up Install Process
rhel-6-server-extras-rpms                                                                                                                     | 1.8 kB     00:00
rhel-6-server-optional-rpms                                                                                                                   | 2.0 kB     00:00
rhel-6-server-rh-common-rpms                                                                                                                  | 2.1 kB     00:00
rhel-6-server-rpms                                                                                                                            | 2.0 kB     00:00
rhel-6-server-satellite-tools-6.2-rpms                                                                                                        | 2.1 kB     00:00
rhel-6-server-supplementary-rpms                                                                                                              | 2.0 kB     00:00
Package glibc-devel-2.12-1.192.el6.x86_64 already installed and latest version
Package glibc-utils-2.12-1.192.el6.x86_64 already installed and latest version
Package glibc-2.12-1.192.el6.x86_64 already installed and latest version
Package glibc-headers-2.12-1.192.el6.x86_64 already installed and latest version
Package glibc-static-2.12-1.192.el6.x86_64 already installed and latest version
Package glibc-common-2.12-1.192.el6.x86_64 already installed and latest version
Package perl-YAML-0.70-4.el6.noarch already installed and latest version
Nothing to do
Loaded plugins: changelog, package_upload, product-id, rhnplugin, security, subscription-manager
This system is not registered with RHN Classic or RHN Satellite.
You can use rhn_register to register.
RHN Satellite or RHN Classic support will be disabled.
Setting up Local Package Process
Examining oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm: oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm: does not update installed package.
Examining oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm: oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm: does not update installed package.
Examining oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm: oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm: does not update installed package.
Nothing to do
RPM installation was successful!
CPAN may ask you questions. Choose 'No' if it asks if you want to
do a manual install, unless you have special internet settings.
CPAN: Storable loaded ok (v2.51)
Going to read '/root/.cpan/Metadata'
  Database was generated on Mon, 06 Feb 2017 22:17:02 GMT
DBI is up to date (1.636).
CPAN: Storable loaded ok (v2.51)
Going to read '/root/.cpan/Metadata'
  Database was generated on Mon, 06 Feb 2017 22:17:02 GMT
DBD::Oracle is up to date (1.74).
Beginning source install...
--2017-02-06 17:03:05--  http://assets.nagios.com/downloads/nagiosxi/packages/check_oracle_health-1.7.3.tar.gz
Resolving assets.nagios.com... 72.14.181.71, 2600:3c00::f03c:91ff:fedf:b821
Connecting to assets.nagios.com|72.14.181.71|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://assets.nagios.com/downloads/nagiosxi/packages/check_oracle_health-1.7.3.tar.gz [following]
--2017-02-06 17:03:05--  https://assets.nagios.com/downloads/nagiosxi/packages/check_oracle_health-1.7.3.tar.gz
Connecting to assets.nagios.com|72.14.181.71|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 142251 (139K) [application/x-gzip]
Saving to: “check_oracle_health-1.7.3.tar.gz.2”

100%[===========================================================================================================================>] 142,251     --.-K/s   in 0.02s

2017-02-06 17:03:05 (7.05 MB/s) - “check_oracle_health-1.7.3.tar.gz.2” saved [142251/142251]

check_oracle_health-1.7.3/
check_oracle_health-1.7.3/NEWS
check_oracle_health-1.7.3/Makefile.am
check_oracle_health-1.7.3/aclocal.m4
check_oracle_health-1.7.3/COPYING
check_oracle_health-1.7.3/INSTALL
check_oracle_health-1.7.3/README
check_oracle_health-1.7.3/configure
check_oracle_health-1.7.3/config.guess
check_oracle_health-1.7.3/TODO
check_oracle_health-1.7.3/Makefile.in
check_oracle_health-1.7.3/AUTHORS
check_oracle_health-1.7.3/missing
check_oracle_health-1.7.3/contrib/
check_oracle_health-1.7.3/contrib/check_oracle_health.php
check_oracle_health-1.7.3/contrib/README.my-extensions
check_oracle_health-1.7.3/contrib/CheckOracleHealthExt1.pm
check_oracle_health-1.7.3/install-sh
check_oracle_health-1.7.3/acinclude.m4
check_oracle_health-1.7.3/plugins-scripts/
check_oracle_health-1.7.3/plugins-scripts/check_oracle_health.pl
check_oracle_health-1.7.3/plugins-scripts/Makefile.am
check_oracle_health-1.7.3/plugins-scripts/Makefile.in
check_oracle_health-1.7.3/plugins-scripts/subst.in
check_oracle_health-1.7.3/plugins-scripts/Nagios/
check_oracle_health-1.7.3/plugins-scripts/Nagios/Extraopts.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Database.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/Sysstat.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/SharedPool.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/Latch.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/DataBuffer.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/SharedPool/
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/SharedPool/LibraryCache.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/SharedPool/DictionaryCache.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/RedoLogBuffer.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA/RollbackSegments.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/PGA.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/Enqueue.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/Event.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Instance/SGA.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Database/
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Database/Tablespace/
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Database/Tablespace/Datafile.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Database/Tablespace/Segment.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Database/Tablespace.pm
check_oracle_health-1.7.3/plugins-scripts/Nagios/DBD/Oracle/Server/Database/FlashRecoveryArea.pm
check_oracle_health-1.7.3/t/
check_oracle_health-1.7.3/t/Makefile.am
check_oracle_health-1.7.3/t/Makefile.in
check_oracle_health-1.7.3/t/check_oracle_health.t
check_oracle_health-1.7.3/config.sub
check_oracle_health-1.7.3/configure.in
check_oracle_health-1.7.3/ChangeLog
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking how to create a pax tar archive... gnutar
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether make sets $(MAKE)... (cached) yes
variable with_statefiles_dir is /var/tmp/check_oracle_health
variable with_mymodules_dir is /usr/local/nagios/libexec
variable with_mymodules_dyn_dir is /usr/local/nagios/libexec
checking for sh... /bin/sh
checking for perl... /usr/bin/perl
checking for gzip... /bin/gzip
checking for gawk... /bin/gawk
checking for grep... /bin/grep
checking for echo... /bin/echo
checking for sed... /bin/sed
checking for cat... /bin/cat
configure: creating ./config.status
config.status: creating Makefile
config.status: creating plugins-scripts/Makefile
config.status: creating plugins-scripts/subst
config.status: creating t/Makefile
                       --with-perl: /usr/bin/perl
             --with-statefiles-dir: /var/tmp/check_oracle_health
                --with-nagios-user: nagios
               --with-nagios-group: nagios
              --with-mymodules-dir: /usr/local/nagios/libexec
          --with-mymodules-dyn-dir: /usr/local/nagios/libexec
cd . && /bin/sh /tmp/check_oracle_health-1.7.3/missing --run aclocal-1.9
/tmp/check_oracle_health-1.7.3/missing: line 52: aclocal-1.9: command not found
WARNING: `aclocal-1.9' is missing on your system.  You should only need it if
         you modified `acinclude.m4' or `configure.in'.  You might want
         to install the `Automake' and `Perl' packages.  Grab them from
         any GNU archive site.
 cd . && /bin/sh /tmp/check_oracle_health-1.7.3/missing --run automake-1.9 --gnu
/tmp/check_oracle_health-1.7.3/missing: line 52: automake-1.9: command not found
WARNING: `automake-1.9' is missing on your system.  You should only need it if
         you modified `Makefile.am', `acinclude.m4' or `configure.in'.
         You might want to install the `Automake' and `Perl' packages.
         Grab them from any GNU archive site.
cd . && /bin/sh /tmp/check_oracle_health-1.7.3/missing --run autoconf
/bin/sh ./config.status --recheck
running /bin/sh ./configure   --no-create --no-recursion
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking how to create a pax tar archive... gnutar
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether make sets $(MAKE)... (cached) yes
variable with_statefiles_dir is /var/tmp/check_oracle_health
variable with_mymodules_dir is /usr/local/nagios/libexec
variable with_mymodules_dyn_dir is /usr/local/nagios/libexec
checking for sh... /bin/sh
checking for perl... /usr/bin/perl
checking for gzip... /bin/gzip
checking for gawk... /bin/gawk
checking for grep... /bin/grep
checking for echo... /bin/echo
checking for sed... /bin/sed
checking for cat... /bin/cat
configure: creating ./config.status
                       --with-perl: /usr/bin/perl
             --with-statefiles-dir: /var/tmp/check_oracle_health
                --with-nagios-user: nagios
               --with-nagios-group: nagios
              --with-mymodules-dir: /usr/local/nagios/libexec
          --with-mymodules-dyn-dir: /usr/local/nagios/libexec
 /bin/sh ./config.status
config.status: creating Makefile
config.status: WARNING:  'Makefile.in' seems to ignore the --datarootdir setting
config.status: creating plugins-scripts/Makefile
config.status: WARNING:  'plugins-scripts/Makefile.in' seems to ignore the --datarootdir setting
config.status: creating plugins-scripts/subst
config.status: creating t/Makefile
config.status: WARNING:  't/Makefile.in' seems to ignore the --datarootdir setting
Making all in plugins-scripts
make[1]: Entering directory `/tmp/check_oracle_health-1.7.3/plugins-scripts'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/tmp/check_oracle_health-1.7.3/plugins-scripts'
Making all in t
make[1]: Entering directory `/tmp/check_oracle_health-1.7.3/t'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/tmp/check_oracle_health-1.7.3/t'
make[1]: Entering directory `/tmp/check_oracle_health-1.7.3'
make[1]: Nothing to be done for `all-am'.
make[1]: Leaving directory `/tmp/check_oracle_health-1.7.3'
Making install in plugins-scripts
make[1]: Entering directory `/tmp/check_oracle_health-1.7.3/plugins-scripts'
make[2]: Entering directory `/tmp/check_oracle_health-1.7.3/plugins-scripts'
test -z "/usr/local/nagios/libexec" || mkdir -p -- "/usr/local/nagios/libexec"
 /usr/bin/install -c 'check_oracle_health' '/usr/local/nagios/libexec/check_oracle_health'
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/tmp/check_oracle_health-1.7.3/plugins-scripts'
make[1]: Leaving directory `/tmp/check_oracle_health-1.7.3/plugins-scripts'
Making install in t
make[1]: Entering directory `/tmp/check_oracle_health-1.7.3/t'
make[2]: Entering directory `/tmp/check_oracle_health-1.7.3/t'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/tmp/check_oracle_health-1.7.3/t'
make[1]: Leaving directory `/tmp/check_oracle_health-1.7.3/t'
make[1]: Entering directory `/tmp/check_oracle_health-1.7.3'
make[2]: Entering directory `/tmp/check_oracle_health-1.7.3'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/tmp/check_oracle_health-1.7.3'
make[1]: Leaving directory `/tmp/check_oracle_health-1.7.3'
ORACLE_HOME=/usr/lib/oracle/11.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
But when I am running the check command, i am getting error. Could you please help me with this issue.

Code: Select all

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client /usr/local/nagios/libexec/check_oracle_health --connect 'xx.xx.xx.xx:1521/Database' --username 'abc' --password 'abc' --mode sql --name="select count(*) from v\$session where status = 'active'" --warning 50 --critical 200
CRITICAL - cannot connect to 172.28.45.45:1521/DB. install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.11.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
 at (eval 19) line 3
Compilation failed in require at (eval 19) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at /usr/local/nagios/libexec/check_oracle_health line 4755

Re: Oracle Agent Issue

Posted: Mon Feb 06, 2017 10:55 pm
by raamardhani7
Hi Team,

This can be closed. I have installed DB2::Oracle perl module and exported the Oracle home and Oracle library. It is working fine. Please close this thread. thanks. :D :)

Re: Oracle Agent Issue

Posted: Tue Feb 07, 2017 9:55 am
by rkennedy
We just got into the office for the day. Great to hear you figured it out - going to lock this one up!