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

Sourcecode, plugin scripts ecc can be downloaded here: https://sourceforge.net/projects/checkora/

Tags: , , ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this. To know all the policy detais click here.

Close