# zabora

**Repository Path**: dd9394/zabora

## Basic Information

- **Project Name**: zabora
- **Description**: Zabbix Agent - Oracle
- **Primary Language**: Shell
- **License**: GPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 2
- **Created**: 2020-08-27
- **Last Updated**: 2022-06-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# zabora
Zabbix Agent - Oracle

# Dependencies
## Packages
* ksh

### Debian/Ubuntu

```
#~ sudo apt install ksh
#~
```

### Red Hat

```
#~ sudo yum install ksh
#~
```

## User account
We will need an account to perform all the checks. Below are the sentences to do it.

```plsql
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;
```

# Deploy
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.*

## Zabbix

```
#~ git clone https://github.com/d9394/zabora.git
#~ sudo ./zabora/deploy_zabbix.sh "${ORACLE_USER}" "${ORACLE_PASS}"
#~ sudo systemctl restart zabbix-agent
```
### Other

!!!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*