Projects / orabbix

orabbix

Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring and performance and availability reporting and measurement for Oracle Databases, along with server performance metrics. It provides an effective mechanism to acquire data from numerous Oracle instances, and in turn provides this information for monitoring and performance metrics to your Zabbix server. You can then utilise the reporting capabilities of Zabbix for all data collected, and provide analysis such as graphs and service level agreement metrics for stakeholders. The current distribution contains a set of pre-defined templates that incorporate alerting and graphing capabilities from initial deployment. However, these can be fine tuned to suit your needs and data/monitoring requirements.

Tags
Licenses
Operating Systems
Implementation

Last announcement

Orabbix 0.9.1 is OUT! 13 Jul 2010 08:05

In this release there is just a little but really nice improvement: Now Orabbix retrieve the connection, once has get the connection to database execute a query like “select sysdate from dual” this just to pubblish a green dot on zabbix if database is alive, if DB is Alive i send “1? to Zabbix Server, and if ALIVE Orabbix goes ahead with all database checks. This pros is just to exclude an useless execution of queryes on database that are unavailable. On zabbix template I’ve added “alive” that register if a database is alive or not. This is really useful e.g. to calculate a SLA so you can put database availability on your SLAS. Other than i’ve added a trigger if Alive is 0 a trigger send a mail that database is not available. Alive is also useful because there is another trigger connected with. This new trigger is “no data received from orabbix” that is incredibly useful because simply “sum” the value retrieved from zabbix and if the sum is less than 1 on 10 minutes zabbix send an email. I consider 10 minute the maximum acceptable time between a run of Orabbis to anotheone (you can change an spcify a different schedule con config.props) {Template_Oracle:alive.sum(600)}<1 so if Orabbix is not working you are going to have a new mail. Orabbix is freely available and downloadable from my website http://www.smartmarmot.com/2010/07/orabbix-0-9-1-is-out/ or on sourceforge as usual.

Recent releases

  •  19 Oct 2011 10:21

    Release Notes: This release adds the following parameter to the main configuration file: DefaultUser = \ DefaultPassword = \ .ExtraQueryListFile =. To the query's properties file, it adds the following parameter:.WhenNotAlive = .

    •  24 Feb 2011 16:26

      Release Notes: Improved scalability and multithreading; now orabbix can scale very easily. Now controls executed on databases are independent of each other. An almost completely sequential procedure on software has been removed, so bottlenecks are higly reduced. The parameter Trim=[true|false] has been added; if true, the resultset is trimmed. AddSpaces=[true|false] has been added; if true, a space is added between columns of the resultset. ExcludeColumnsList=[1,2,3,..n]= will exclude the 1st, 2nd, etc. columns from the resultset. This release uses OJDBC6 for Oracle 11.2. This is a Candidare Release.

      •  17 Dec 2010 15:42

        Release Notes: This release has moved to a more standard library. It utilizes the Apache library.

        •  29 Nov 2010 17:52

          Release Notes: The resultset is now protected from null values. A parameter .Period=10 that introduces a period execution between two executions of the specified query value expressed in minutes. If not specified, the default value is 5 minutes. A query file for each database can be specified via .QueryListFile=./conf/query.props, so each database can have its own customized parameter file and many other features.

          •  24 Sep 2010 13:15

            Release Notes: This release improves the dynamic rebuild of the database list. It corrects a critical bug where in some cases, Orabbix could send incorrect values. It corrects a template for easy importing.

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.