11.zabbix学习笔记：zabbix监控oracle_zabbix里面totoal sessions,active sessions,inactive s-CSDN博客

本文链接：https://blog.csdn.net/linux_player_c/article/details/53005347

本文详细介绍了如何使用Zabbix结合orabbix插件监控Oracle数据库。内容包括可监控的Oracle指标，实施步骤如前期准备、安装配置，可能出现的问题及解决办法。监控项涉及数据库版本、I/O、会话数等，确保全面掌握数据库运行状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

zabbix监控oracle

可监控项

使用zabbix监控oracle数据库需要借助第三方的插件，目前使用较多的是orabbix。目前维护到了1.2.3版本。关于oracle自带的监控项目有以下几个：
DB Version (i.e. Validity of package)数据库版本
Archiving (Archive log production with trend analysis)归档文件
Event Waits (Files I/O, single block read, multi-block read, direct path read, SQLNet Messages, Control file I/O, Log Write)等待的事件
Hit Ratio (Hit Ratio on Triggers, Tables/Procedures, SQL Area, Body)
Logical I/O (Server performance on Logical I/O of: Current Read, Consistent Read, Block Change)逻辑I/O
Physical I/O (Redo Writes, Datafile Writes, Datafile Reads)物理I/O
PGA
SGA (In particular; Fixed Buffer, Java Pool, Large Pool, Log Buffer, Shared Poolm Buffer Cache)
Shared Pool (Pool Dictionary Cache, Pool Free Memory, Library Chache, SQL Area, MISC.)共享池
Pin Hit Ratio (Oracle library cache pin are caused by contention with the library cache, the area used to store SQL executables for re-use)
Sessions / Processes**会话数和进程数**
Sessions (Active Sessions, Inactive Sessions, System Sessions)
DBSize/DBFileSize (DBSize size of database really used space and of Filesize)数据库大小

实施步骤

前期准备

1.节点：zabbix服务端和oracle数据库两个节点。
2.安全设置：为了实验起见，关闭selinux和iptables
3.获取安装包：
orabbix-1.2.3.zip
4.下载安装jdk（x86_64），在oracle的官网可以下载，配置好JAVA_HOME等环境变量。

安装步骤

1.创建访问数据库的用户并进行相关授权

使用oracle的管理员用户登录oracle数据库：

[oracle@server ~]$ sqlplus sys/oracle@hybris as sysdba

创建zabbix用户并且授予其相关权限：

（1）创建用户

CREATE USER ZABBIX
 IDENTIFIED BY ZABBIX DEFAULT TABLESPACE SYSTEM
 TEMPORARY TABLESPACE TEMP
 PROFILE DEFAULT
 ACCOUNT UNLOCK;

（2）授予权限

GRANT CONNECT TO ZABBIX;
GRANT RESOURCE TO ZABBIX;
ALTER USER ZABBIX DEFAULT ROLE ALL;
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;

上述是给zabbix较高权限，如果只是为了满足orabbix自带的监控项目，可以只授予zabbix如下权限：

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 ROLE ALL;
GRANT SELECT ON V_$INSTANCE TO ZABBIX;
GRANT SELECT ON DBA_USERS TO ZABBIX;
GRANT SELECT ON V_$LOG_HISTORY TO ZABBIX;
GRANT SELECT ON V_$PARAMETER TO ZABBIX;
GRANT SELECT ON SYS.DBA_AUDIT_SESSION TO ZABBIX;
GRANT SELECT ON V_$LOCK TO ZABBIX;
GRANT SELECT ON DBA_REGISTRY TO ZABBIX;
GRANT SELECT ON V_$LIBRARYCACHE TO ZABBIX;
GRANT <