zabbix 7 监控 oracle 19c 方法 增加agent2监控需要的变量环境

oracle 开通账号，并给与查看数据表权限

创建zabbix监控需要的用户，使用独立表空间后续方便管理

创建表空间
create tablespace zabbix datafile '/data/zabbix.ora' size 5G autoextend off;

create tablespace zabbix datafile '/data/zabbix.ora' size 5G autoextend off;

创建业务用户
create user zabbix identified by zabbix;
设置业务用户使用独立表空间
create user zabbix identified by zabbix default tablespace zabbix;

GRANT SELECT ANY DICTIONARY TO zabbix;     --权限比较大，谨慎使用。

精选分配权限

GRANT CONNECT TO zabbix;
GRANT RESOURCE TO zabbix;
GRANT CREATE SESSION TO zabbix;
GRANT SELECT ON v_$database TO zabbix;
GRANT SELECT ON v_$instance TO zabbix;
GRANT SELECT ON v_$sysstat TO zabbix;
GRANT SELECT ON v_$system_event TO zabbix;
GRANT SELECT ON v_$session TO zabbix;
GRANT SELECT ON v_$process TO zabbix;
GRANT SELECT ON v_$lock TO zabbix;
GRANT SELECT ON v_$sqlarea TO zabbix;
GRANT SELECT ON v_$sqlstats TO zabbix;
GRANT SELECT ON v_$parameter TO zabbix;
GRANT SELECT ON v_$log TO zabbix;
GRANT SELECT ON v_$logfile TO zabbix;
GRANT SELECT ON v_$archived_log TO zabbix;
GRANT SELECT ON v_$tablespace TO zabbix;
GRANT SELECT ON v_$tempfile TO zabbix;
GRANT SELECT ON v_$datafile TO zabbix;
GRANT SELECT ON v_$filestat TO zabbix;
GRANT SELECT ON v_$undostat TO zabbix;
GRANT SELECT ON v_$pgastat TO zabbix;
GRANT SELECT ON v_$sga TO zabbix;
GRANT SELECT ON v_$sgastat TO zabbix;
GRANT SELECT ON v_$librarycache TO zabbix;
GRANT SELECT ON v_$rowcache TO zabbix;
GRANT SELECT ON v_$sys_time_model TO zabbix;
GRANT SELECT ON v_$system_wait_class TO zabbix;
GRANT SELECT ON v_$waitstat TO zabbix;
GRANT SELECT ON v_$osstat TO zabbix;
GRANT SELECT ON v_$metric TO zabbix;
GRANT SELECT ON v_$metric_history TO zabbix;
GRANT SELECT ON dba_tablespaces TO zabbix;
GRANT SELECT ON dba_data_files TO zabbix;
GRANT SELECT ON dba_free_space TO zabbix;
GRANT SELECT ON dba_segments TO zabbix;
GRANT SELECT ON dba_indexes TO zabbix;
GRANT SELECT ON dba_tables TO zabbix;
GRANT SELECT ON dba_objects TO zabbix;
GRANT SELECT ON dba_users TO zabbix;
GRANT SELECT ON dba_profiles TO zabbix;

GRANT SELECT ON v_$instance TO zabbix;
GRANT SELECT ON v_$sysstat TO zabbix;
GRANT SELECT ON v_$system_event TO zabbix;
GRANT SELECT ON v_$session TO zabbix;
GRANT SELECT ON v_$process TO zabbix;
GRANT SELECT ON v_$lock TO zabbix;
GRANT SELECT ON v_$sqlarea TO zabbix;
GRANT SELECT ON v_$parameter TO zabbix;
GRANT SELECT ON v_$tablespace TO zabbix;
GRANT SELECT ON v_$datafile TO zabbix;
GRANT SELECT ON v_$log TO zabbix;
GRANT SELECT ON v_$archived_log TO zabbix;
GRANT SELECT ON v_$logfile TO zabbix;

DBA 视图权限
GRANT SELECT ON dba_tablespaces TO zabbix;
GRANT SELECT ON dba_data_files TO zabbix;
GRANT SELECT ON dba_free_space TO zabbix;
GRANT SELECT ON dba_segments TO zabbix;
GRANT SELECT ON dba_users TO zabbix;
GRANT SELECT ON dba_profiles TO zabbix;

#zabbix 监控客户端安装监控包

rpm -ivh https://download.oracle.com/otn_software/linux/instantclient/213000/oracle-instantclient-basic-21.3.0.0.0-1.x86_64.rpm

#下载oracle 客户端rpm位置

Instant Client for Linux x86-64 (64-bit)

下载自己需要的版本

下载完成后，编辑 

vi /etc/profile  配置文件增加如下内容

这里以oracle 19c 为例，最后增加如下内容

RACLE_HOME=/usr/lib/oracle/19.30/client64/;export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib64:$LD_LIBRARY_PATH;export LD_LIBRARY_PATH

重启agent2

 systemctl restart zabbix-agent2

最后调试zabbix监控选线

Template DB Oracle by Zabbix Agent 2"，

在"宏"一栏分别修改

"{$ORACLE.SERVICE}"、"为"orcl"

"{$ORACLE.USER}"、为 zabbix

"{$ORACLE.PASSWORD} 为 zabbix