Nov

monitor Oracle with zabbix

The “easy” to monitor Oracle with zabbix is using this plug-in wrote from me.

Everyone can read the full story of this plugin here: http://www.zabbix.com/forum/showthread.php?t=13666

Requirements:

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

Installation steps

create an user with this oracle script:

CREATE USER ZABBIX
IDENTIFIED BY <REPLACE WITH PASSWORD>
DEFAULT TABLESPACE SYSTEM
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
— 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 /etc/zabbix/externalscripts/check_ora/credentials

import my template
schedule on crontab
*/5 * * * * /etc/zabbix/externalscripts/check_ora_cron.sh

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