Hi to everyone.
I’ve released my first release of orabbix.
Orabbix is a plug-in for zabbix, and more or less do the same work of check_ora BUT has this pros (compared with shell script):
- connection pool
- use log4j
- is completely in java
so pratically:
- you don’t need more to install an oracle client (simply download this package and install)
- you will neve see listener.log on oracle server that grown anc ocntinue to grown (because in check_ora for every query there is a new connection) here everything is solved with connection pooling
- you have a log wrote with log4j
- is wrote in java so can run on windows and linux machine without troubles
This is my first initial release so please give any feedback to me and in particular this is tested on redhat EL 5.3 and with java-1.6.0-openjdk.x86_64 prm package it’s tested also with java jre 1.6.0_10, actually work with Zabbix server 1.6.6.
everyone can donwload the release here:
https://sourceforge.net/projects/orabbix/
NOTE:
* This software is released orabbix is free software: you can redistribute it and/or modify it under the
* terms of the GNU General Public License as published by the Free Software
* Foundation, either version 3 of the License, or (at your option) any later
* version.
*
* orabbix is distributed in the hope that it will be useful, but WITHOUT ANY
* WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
I’ve found a bug inside a check_ora_sendtrap.sh on line 58:
echo ” -s for sqlplus login connection and return time in second”
in particular there was an escape character and the line appear so:
echo ” -s for sqlplus login connection and return time in seco
without a correct termination, pleas download the new release 1.2.2 at
https://sourceforge.net/projects/checkora/
Note: there’s a trouble when import the template of mine inside zabbix server 1.8.1 i don’t know why but happen just on this release. if you find an error like this:
Added new application Template_Oracle:Oracle
Added new item Template_Oracle:ALERTLOG
Added new item Template_Oracle:alertlog.warn
Added new item Template_Oracle:archive
Added new item Template_Oracle:audit
…..
Added new item Template_Oracle:pinhitratio_
Incorrect key format ‘key_name[param1,param2,…]’
Internal zabbix error
No such monitored parameter (session) for host (Template_Oracle)
Unknown ZABBIX internal error
<description>Pin hit ratio – TABLE/PROCEDURE</description>
<ipmi_sensor></ipmi_sensor>
<delay>300</delay>
<history>90</history>
<trends>365</trends>
<status>0</status>
<units>%</units>
<multiplier>0</multiplier>
<delta>0</delta>
<formula>1</formula>
<lastlogsize>0</lastlogsize>
<logtimefmt></logtimefmt>
<delay_flex></delay_flex>
<params>DSN=<database source name>\nuser=<user name>\npassword=<password>\nsql=<query ></params>
<trapper_hosts></trapper_hosts>
<snmp_community>public</snmp_community>
<snmp_oid>interfaces.ifTable.ifEntry.ifInOctets. 1</snmp_oid>
<snmp_port>161</snmp_port>
<snmpv3_securityname></snmpv3_securityname>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authpassphrase></snmpv3_authpassphrase>
<snmpv3_privpassphrase></snmpv3_privpassphrase>
<applications>
<application>Oracle</application>
</applications>
</item>
In this release i have correct the item template and removed some useless query and item never used.
NOTICE: all this work is tested and run correctly on zabbix server 1.6.6 i still have this release (that is mine production release) so i didn’t try mine work on zabbix server 1.8.1
New release is avalable here:
https://sourceforge.net/projects/checkora/
i’ve re-up mine version
In this release is included a new item and graph that is used to monitor archivelog production on a database.
In particular i’m going to get an average value that is calculate on a slice of 10 minutes.
So you can monitor your archivelog production, this is really useful if you have an Oracle DataGuard installation or simply to monitor the workload of transaction that are acting on youd database.
Normally this value is really low, on mine database is something like 500 MB/hour but if an hig load is coming this value grown until 16-20GB/hour and is becoming dangerous.
The trigger associated send a mail if this value is mode than 100MB/minute.
Here you can see an example graph of mine database.
archivelog production example
the query used to retrieve this value is:
select round(A.LOGS*B.AVG/1024/1024/10)
from (
SELECT COUNT (*) LOGS
FROM V$LOG_HISTORY
WHERE FIRST_TIME >= (sysdate -10/60/24) )A,
(
SELECT Avg(BYTES) AVG, Count(1) Count#, Max(BYTES) Max_Bytes, Min(BYTES) Min_Bytes
FROM v$log) B;
I retrieve the value on last 10 mintes to have an average that have a sense.
get the new package here:
New minor release of mine zabbix plug-in is out, downloadable from:
http://sourceforge.net/projects/checkora/
if someone has something to add please contact me.
now work better, some news are coming to monitor directoly inside zabbix oracle export, oracle export datapump, and rman backup status, with log history, errors etc, also an integration between zabbix and oracle alertlog is coming soon.
there is an officiale Thred on zabbix forum available here:
http://www.zabbix.com/forum/showthread.php?t=13666&page=3
everyone can fell free to contribute.
