Hi to everyone, i've wrote within a workmate a plugin for zabbix to monitor oracle instances.
This script work on serverside and don't use zabbix send, but simply the zabbix server run some script and collect data from oracle instances.
This plugin is server-centric because for me is more simple manage and upgrade a single application.
The work that is done with zabora is simply great,and i've really apreciate! this is just another way to do more or less the same work.
- a working sqlplus on zabbix server with configured tnsnames, and tnsping utility too. I've installed a complete client and not simply the instantclient, because tnsping is not included inside instant-client.
- an user on every oracle instances
create an user with this oracle script:
CREATE USER ZABBIX
IDENTIFIED BY <REPLACE WITH PASSWORD>
DEFAULT TABLESPACE SYSTEM
TEMPORARY TABLESPACE TEMP
-- 2 Roles for ZABBIX
GRANT CONNECT TO ZABBIX;
GRANT RESOURCE TO ZABBIX;
ALTER USER ZABBIX DEFAULT ROLE ALL;
-- 5 System Privileges for ZABBIX
GRANT SELECT ANY TABLE TO ZABBIX;
GRANT CREATE SESSION TO ZABBIX;
GRANT SELECT ANY DICTIONARY TO ZABBIX;
untar in /etc/zabbix/externalscripts check_ora.tar.gz
write your credentials /username/password and instance etc..) inside
create items like on attachment check_ora_items.txt or import my template.
then the last thing to do is add an host with the same name of SID.
an you'll have a lot of graphs about performaces etc..
in the picture you'll see some graphs
See ya =)