check_oracle_health
check_oracle_health copied to clipboard
lausser
A plugin (monitoring-plugin, not nagios-plugin, see also http://is.gd/PP1330) which checks various parameters of Oracle database servers. (We also offer trainings: http://www.consol.de/open-source-mo...
./check_oracle --connect //x.x.x.x/XE --mode connection-time --password test --report long --username nagios **Cannot determine ORACLE_HOME for sid //x.x.x.x/XE** I am currently trying to run the script in shell only, however I...
Fix detection of invalid domain indexes. Indeed, in some cases the main status is VALID but DOMIDX_STATUS or DOMIDX_OPSTATUS could be not VALID, impacting statements on the related table (for...
I found out that blocking-sessions mode doesn't really detect blocking sessions! It simply prints "OK - " and returns OK state. Developed & tested against real Oracle DB and simulated...
Hello, I'd like to ask about possibility to build-up the connection string out of provided HOST, PORT and SID command line options instead (or better: in addition to) of specifying...
Hi When I run the plugin with **--mode dataguard-mrp-status** on a STANDBY database I have : _CRITICAL - Unable to find MRP process, managed recovery may be stopped_ Is it...
Hi, I have an issue with the plugin when I want to check session-usage and process-usage. I figured out that issue is related to multitenant architecture. It cannot check those...
Hi, I have a problem with an old Oracle 9i instance which returns negative values for undo tablespace usage. for example we have an undo tbs (UNDOTBS2) made by 3...
Hello, I have exactly same issue as #26 with Oracle Client 12.2.0.1 and Oracle 12.1.0.2 - also on Centos 7.5 with perl 5.16,3. Using --sqlplus is OK but this means...
Hello, https://github.com/lausser/check_oracle_health/blob/6e2a96cbe57eeb6eabae7f7e853ccb88106e72c0/plugins-scripts/Nagios/DBD/Oracle/Server/Database/Tablespace.pm#L199 Having the "d.maxbytes" condition in "GROUP BY" leads to inability to create rrd file in case TEMP tablespace have more than 1 datafile with different "MAXBYTES" values. In...
Sometimes, the flash recovery area usage checks, are exiting with state critical and negative usage values. This happens on several monitoring-/oracle-systems. Example: ``` CRITICAL - flra (/u01/app/oracle/fast_recovery_area) usage is -2.80%...
