Zabbix Agent - Oracle
- bash
#~ sudo apt install bash
#~
#~ sudo yum install bash
#~
We will need an account to perform all the checks. Below are the sentences to do it.
CREATE USER monitor IDENTIFIED BY 'xxxxxxx' DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO monitor;
GRANT RESOURCE TO monitor;
ALTER USER monitor DEFAULT ROLE ALL;
GRANT SELECT ANY TABLE TO monitor;
GRANT CREATE SESSION TO monitor;
GRANT SELECT ANY DICTIONARY TO monitor;
GRANT UNLIMITED TABLESPACE TO monitor;
GRANT SELECT ANY DICTIONARY TO monitor;
GRANT SELECT ON V_$SESSION TO monitor;
GRANT SELECT ON V_$SYSTEM_EVENT TO monitor;
GRANT SELECT ON V_$EVENT_NAME TO monitor;
GRANT SELECT ON V_$RECOVERY_FILE_DEST TO monitor;
The username and the password can't be empty. Default variables:
NAME | VALUE |
---|---|
ORACLE_USER | monitor |
ORACLE_PASS | xxxxxxx |
Note: these variables have to be saved in the config file (zabora.conf) in the same directory than the script.
#~ git clone https://github.com/waldo323/zabora.git
#~ sudo ./zabora/deploy_zabbix.sh "${ORACLE_USER}" "${ORACLE_PASS}"
#~ sudo systemctl restart zabbix-agent
!!!make sure zabbix has right env, and edit zabora.oraenv file #~ sudo vi zabora.oraenv
!!!you should add a Macros in the host item setting like: Macro Value {$ORACLE_SID} = orcl
Note: the installation has to be executed on the zabbix agent host and you have to import the template on the zabbix web. The default installation directory is /etc/zabbix/scripts/agentd/zabora