Setting up Oracle database Monitoring - facing issue

[maxwellmiranda]

this works...

thanks a lot

[tureem]

Hi!

With this post i finally got the oracle check to work at the command prompt using the last command example.

But, how do i add this oracle test using nagiosxi oracle wizard?

In the table space wizard it asks for
Address:
Port:
Username:
Password:
Tablespace/Database:

If this is not possible, how do i add the tests then?

Mvh
Roar

[shiwpam]

Hi!

With this post i finally got the oracle check to work at the command prompt using the last command example.

But, how do i add this oracle test using nagiosxi oracle wizard?

In the table space wizard it asks for
Address:
Port:
Username:
Password:
Tablespace/Database:

If this is not possible, how do i add the tests then?

Mvh
Roar

I have the same issue. How do I get this to work from the wizard?

[ghostzy]

Hi Guys, i've just installed today the plugin for oracle and i'm getting the same error:
CRITICAL - cannot connect to <IP>:1521/ORCL. install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/nagios/libexec /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/

i'm running a VM CentOS 6.7 on 64bits;
ORACLE_HOME=/usr/lib/oracle/12.1/client64
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib

i've followed the guide from link:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

at the end when i run : cpan -i DBD::Oracle
i'm getting the following error:

Code: Select all

Installing on a linux, Ver#2.6
Using Oracle in /usr/lib/oracle/12.1/client64
DEFINE _SQLPLUS_RELEASE = "1201000200" (CHAR)
Oracle version 12.1.0.2 (12.1)

        Unable to locate an oracle.mk or other suitable *.mk
        file in your Oracle installation.  (I looked in
        /usr/lib/oracle/12.1/client64/rdbms/demo/demo_xe.mk /usr/lib/oracle/12.1/client64/rdbms/lib/oracle.mk /usr/lib/oracle/12.1/client64/rdbms/demo/oracle.mk /usr/lib/oracle/12.1/client64/rdbms/demo/demo_rdbms.mk /usr/lib/oracle/12.1/client64/rdbms/demo/demo_rdbms64.mk /usr/lib/oracle/12.1/client64/rdbms/lib/ins_rdbms.mk /usr/share/oracle/12.1/client64/demo.mk under /usr/lib/oracle/12.1/client64)

        The oracle.mk (or demo_rdbms.mk) file is part of the Oracle
        RDBMS product.  You need to build DBD::Oracle on a
        system which has one of these Oracle components installed.
        (Other *.mk files such as the env_*.mk files will not work.)
        Alternatively you can use Oracle Instant Client.

        In the unlikely event that a suitable *.mk file is installed
        somewhere non-standard you can specify where it is using the -m option:
                perl Makefile.PL -m /path/to/your.mk

        See the appropriate README file for your OS for more information and some alternatives.

     at Makefile.PL line 1187.
Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDIRS=site]
  PYTHIAN/DBD-Oracle-1.74.tar.gz
  /usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK
Running make test
  Make had some problems, won't test
Running make install
  Make had some problems, won't install

Can you please help me out ?
Cheers
Cristi

[ghostzy]

IT worked for me by setting the following exports:

Code: Select all

export ORACLE_HOME=/usr/lib/oracle/12.1/client64/lib
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/
export PATH=$PATH:/usr/lib/oracle/12.1/client64/bin

After that i could run the CPAN installation oK.
Cheers.

[wallys65]

Dear all,
I try test oracle plugin for 2 DB PSAPSR3 and PSAPSR370 with the follows command :

COMMAND: /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64 /usr/local/nagios/libexec/check_oracle_health --connect '10.51.6.104:1527/MPT' --username 'nagios' --password 'oradbmon' --mode tablespace-free --name PSAPSR3 PSAPSR3700 --warning 5: --critical 0:
OUTPUT: OK - tbs PSAPSR3 has 9.72% free space left | 'tbs_psapsr3_free_pct'=9.72%;5:;0: 'tbs_psapsr3_free'=27648MB;14219.00:;0.00:;0;284380.00

I see only the first DB "PSAPSR3"

How Can I see 2 or more DB ?
Is it possible to use an option in --name for to see it ?

Thanks in advance

Walter