Zabbix 7.0 监控Oracle数据库ODBC配置

一、环境准备与依赖安装

1. Oracle Instant Client部署

# 下载最新版客户端（Oracle 23c）
wget https://download.oracle.com/otn_software/linux/instantclient/239000/instantclient-basic-linux.x64-23.9.0.0.0.zip 
 
# 解压并配置环境变量 
unzip instantclient-*.zip -d /opt/oracle 
echo 'export ORACLE_HOME=/opt/oracle/instantclient_23_9' >> /etc/profile 
echo 'export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH' >> /etc/profile 
source /etc/profile 

验证安装：

$ ldd $ORACLE_HOME/libsqora.so.23.1 
    linux-vdso.so.1 (0x00007ffd4d3f0000)
    libclntsh.so => /opt/oracle/instantclient_23_9/libclntsh.so (0x00007f8a1a200000)

二、ODBC驱动配置

1. 驱动注册文件

# /etc/odbcinst.ini 
[Oracle23c]
Description     = Oracle ODBC Driver 23c 
Driver          = /opt/oracle/instantclient_23_9/libsqora.so.23.1 
UsageCount      = 1 
FileUsage       = 1 

2. 数据源配置

# /etc/odbc.ini 
[ORCLPDB1]
Description     = Oracle Production DB 
Driver          = Oracle23c 
ServerName      = //10.1.1.100:1521/ORCLPDB1 
UserID          = zabbix_mon 
Password        = Zbx#2025Secure 
Port            = 1521 

连接测试：

isql -v ORCLPDB1 
+---------------------------------------+
| Connected!