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.
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
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 =)
Dalle
Leave a comment: