Page 3 of 3
Re: Setting up Oracle database Monitoring - facing issue
Posted: Mon Apr 16, 2012 2:41 pm
by maxwellmiranda
this works...
thanks a lot
Re: Setting up Oracle database Monitoring - facing issue
Posted: Tue Nov 13, 2012 7:16 am
by 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
Re: Setting up Oracle database Monitoring - facing issue
Posted: Fri Feb 13, 2015 12:28 pm
by shiwpam
tureem wrote: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?
Re: Setting up Oracle database Monitoring - facing issue
Posted: Thu Apr 14, 2016 10:39 am
by 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
Re: Setting up Oracle database Monitoring - facing issue
Posted: Wed Apr 27, 2016 7:03 am
by 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.
Re: Setting up Oracle database Monitoring - facing issue
Posted: Fri Nov 11, 2016 6:54 am
by 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