zbxora Module and Template for Oracle Popular
zbxora, a powerful Oracle plugin plus template
- kiss
- small footprint
- easy to extend
- python powered
- responsive
- open for feature requests
- primary databases
- standby databases
- ASM instances
- RAC aware
extensible
For the admins having to monitor Oracle database it is very easy to add extra items to monitor. Even the lld feature it self is implemented as 'just a query'. You can easily define new items and have your own SQL added in your checks directories. The SQL returns the item_key and the value. No hocus pocus, no extra parameters, it is all SQL that does the job.
Queries are organized in sections in an inifile style. Sections that have 'discover' in their name are treated as sections that containt LLD queries for which the output is transformed in a Json array that zabbix uses for this purpose.
Other sections are just passing their query results as key, value pairs to zabbix. The keys are just part of the SQL output so you have full control. The order of SQL output columns must ben key, value.
The result of zbxora.py is a file that is usable for zabbix_sender. If you only use a single database monitor, you could make zbxora launch zabbix_sender and upload it for you. If there are many databases monitored from the same client, it is more efficient to just collect the data and have a separate script collect the files, move them to a transit location and have that call zabbix_sender.
Example for adding extra metrics: http://ronr.blogspot.nl/2015/10/how-to-create-new-metrics-for-zbxora.html
zbxora-1.98 was the start for zbxdb
zbxdb now supports multiple database vendors and drivers.
This makes zbxora deprecated. My advice is: go to zbxdb since it has the same specifications, just a minor modification for the connection parameter file is needed. Unlink the zbxora template and link the zbxdb template instead.