Thisguide is based upon there being two (2) Hosts, 1x Zabbix Server and 1x OracleServer. If you are planning on monitoring an Oracle instance that is running onyour Zabbix Server, the steps are the same, with minor adjustments required foryour connection information.

Thesteps also assume you are configuring Orabbix to monitor a new installation orsetup of Oracle. The installation steps will have you GRANT access for theZabbix user to all tables, and this will include any USER tables present at thetime of execution. If you do not want Zabbix to have access to specific tablesor resources within your database, you will need to set a DENY to the Zabbixusers access as required. Consult your DBA for details, as this is beyond thescope of these instructions.

Stepsfor Installation

Download Orabbix to your Zabbix Server

On your Zabbix server, unzip Orabbix to: /opt/orabbix

Copy file /opt/orabbix/init.d/orabbix to /etc/init.d/orabbix

Grant execute permissions to the following files:

/etc/init.d/orabbix

/opt/orabbix/run.sh

Create a User (ZABBIX) for Orabbix to access your Oracle Database. You can use the following script:

CREATE USER ZABBIX

IDENTIFIED BY ZABBIX

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;

GRANT UNLIMITED TABLESPACE TO ZABBIX;

GRANT SELECT ANY DICTIONARY TO ZABBIX;

NOTE if you need an User (ZABBIX) for Orabbix with the minimum grants available, you can use the following script:

CREATE USER ZABBIX

IDENTIFIED BY ZABBIX

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT ALTER SESSION TO ZABBIX;

GRANT CREATE SESSION TO ZABBIX;

GRANT CONNECT TO ZABBIX;

ALTER USER ZABBIX DEFAULT ROLEALL;

GRANT SELECT ON V_$INSTANCE TOZABBIX;

GRANT SELECT ON DBA_USERS TOZABBIX;

GRANT SELECT ON V_$LOG_HISTORYTO ZABBIX;

GRANT SELECT ON V_$PARAMETER TOZABBIX;

GRANT SELECT ON SYS.DBA_AUDIT_SESSIONTO ZABBIX;

GRANT SELECT ON V_$LOCK TOZABBIX;

GRANT SELECT ON DBA_REGISTRY TOZABBIX;

GRANT SELECT ON V_$LIBRARYCACHETO ZABBIX;

GRANT SELECT ON V_$SYSSTAT TOZABBIX;

GRANT SELECT ON V_$PARAMETER TOZABBIX;

GRANT SELECT ON V_$LATCH TOZABBIX;

GRANT SELECT ON V_$PGASTAT TOZABBIX;

GRANT SELECT ON V_$SGASTAT TOZABBIX;

GRANT SELECT ON V_$LIBRARYCACHETO ZABBIX;

GRANT SELECT ON V_$PROCESS TOZABBIX;

GRANT SELECT ON DBA_DATA_FILESTO ZABBIX;

GRANT SELECT ON DBA_TEMP_FILESTO ZABBIX;

GRANT SELECT ON DBA_FREE_SPACETO ZABBIX;

GRANT SELECT ON V_$SYSTEM_EVENTTO ZABBIX;

NOTE : If you are using Oracle 11g, you will need to add the following:

exec dbms_network_acl_admin.create_acl(acl=> 'resolve.xml',description => 'resolve acl', principal =>'ZABBIX',is_grant => true, privilege => 'resolve');