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