1 前言

一个问题，一篇文章，一出故事。
笔者生产环境有一台服务器需要连接Oracle数据库，于是整理此文。

2 最佳实践

2.1 在线安装客户端

dnf install https://download.oracle.com/otn_software/linux/instantclient/1916000/oracle-instantclient19.16-basic-19.16.0.0.0-1.x86_64.rpm
dnf install https://download.oracle.com/otn_software/linux/instantclient/1916000/oracle-instantclient19.16-basiclite-19.16.0.0.0-1.x86_64.rpm
dnf install https://download.oracle.com/otn_software/linux/instantclient/1916000/oracle-instantclient19.16-sqlplus-19.16.0.0.0-1.x86_64.rpm
dnf install https://download.oracle.com/otn_software/linux/instantclient/1916000/oracle-instantclient19.16-tools-19.16.0.0.0-1.x86_64.rpm
dnf install https://download.oracle.com/otn_software/linux/instantclient/1916000/oracle-instantclient19.16-devel-19.16.0.0.0-1.x86_64.rpm
dnf install https://download.oracle.com/otn_software/linux/instantclient/1916000/oracle-instantclient19.16-jdbc-19.16.0.0.0-1.x86_64.rpm
dnf install https://download.oracle.com/otn_software/linux/instantclient/1916000/oracle-instantclient19.16-odbc-19.16.0.0.0-1.x86_64.rpm

以上连接可能会失效或你有其他的版本需求，请参考如下链接，
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

2.2 配置环境变量

vim /etc/profile.d/oracle-client.sh

加入如下配置，

export ORACLE_HOME=/usr/lib/oracle/19.16/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin

然后，使用如下命令导入环境变量，

source /etc/profile

根据以上环境变量配置，我们需要创建以下文件和文件夹，

mkdir -p $TNS_ADMIN
vim $TNS_ADMIN/tnsnames.ora

加入如下配置，

ORADB_CON=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.168.0.34)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oraser)
    )
)

2.3 测试连接

sqlplus oraUser/oraPassword@ORADB_CON

参阅文档
===============
https://docs.oracle.com/en/database/oracle/oracle-database/21/lacli/install-instant-client-using-rpm.html#GUID-2E81E2AE-E94C-413F-99B2-AE9A3949F05D

https://www.unixmen.com/install-oracle-client-centos/