1. 安装ODBC

yum -y install unixODBC unixODBC-devel

2. 安装Oracle-instantclient

先把需要用到的四个rpm离线包下载到本地

mkdir -p oracle
cd oracle

wget https://download.oracle.com/otn_software/linux/instantclient/199000/oracle-instantclient19.9-basic-19.9.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/199000/oracle-instantclient19.9-sqlplus-19.9.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/199000/oracle-instantclient19.9-devel-19.9.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/199000/oracle-instantclient19.9-odbc-19.9.0.0.0-1.x86_64.rpm

直接通过下面的命令安装 oracle-instantclient

yum localinstall oracle-instantclient19.9-*

oracle-instantclient的安装位置如下

/usr/lib/oracle/19.9/client64
/usr/share/oracle/19.9/client64
/usr/include/oracle/19.9/client64

3. 配置SQLPlus连接

创建 network/admin 文件夹

mkdir /usr/lib/oracle/19.9/client64/network/admin -p
cd /usr/lib/oracle/19.9/client64/network/admin
vim tnsnames.ora

HOST写oracle数据库服务器IP地址，
SERVICE_NAME写global_name
sqlplus / as sysdba
select global_name from global_name;

Oracle=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 数据库SID)
)
)

每次重启虚拟机都要重新配置监听

	su - oracle  #切换到oracle用户,配置监听
	export DISPLAY=IP:0.0  #IP为本机地址，export DISPLAY=本机地址:0.0
	netca -silent -responseFile  /opt/oracle/database/response/netca.rsp
	sqlplus / as sysdba
	startup

	lsnrctl start

环境变量配置

vim /etc/profile添加以下内容
export ORACLE_HOME=/usr/lib/oracle/19.9/client64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib64:$LD_LIBRARY_PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/binsource /etc/profile
source /etc/profile加载环境变量

配置需要的类库

chmod +x /usr/lib/oracle/19.9/client64/lib/libsqora.so.19.1
cd /usr/lib64/
ln -s libodbcinst.so.2.0.0 libodbcinst.so.1

添加Oracle驱动

vim /etc/odbcinst.ini添加以下内容
[Oracle]
Description = Oracle ODBC driver for Oracle 11g
Driver = /usr/lib/oracle/19.9/client64/lib/libsqora.so.19.1

添加Oracle数据源

vim /etc/odbc.ini添加以下内容
[Oracle]           #DSN名称
Driver = Oracle         #驱动名称
ServerName = xxx.xxx.xxx.xxx:1521/数据库SID  #IP:端口/SID
UserID = XXX          #用户名
Password = XXX          #密码

ISQL测试

isql -v Oracle #DSN名称

4. 配置zabbix监控

配置——主机——创建主机