1.下载instance client

[https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html]

下载包：

instantclient-sqlplus-linux.x64-12.2.0.1.0.zip

instantclient-tools-linux.x64-12.2.0.1.0.zip

instantclient-basic-linux.x64-11.2.0.4.0.zip

上传至服务器 /usr/local/oracle下,解压

unzip instantclient-basic-linux.x64-12.2.0.1.0.zip

unzip instantclient-tools-linux.x64-12.2.0.1.0.zip

unzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip

创建软链接

cd /usr/local/oracle

ln -s libclntsh.so.12.1 libclntsh.so

ln -s libocci.so.12.1 libocci.so

4.安装 libaio

yum install libaio

5.配置runtime link path

echo /usr/local/oracle/instantclient_12_2 > /etc/ld.so.conf.d/oracle-instantclient.conf

6.指定oracle Lib路径

vi .bash_profile

export LD_LIBRARY_PATH=/usr/local/lib:/usr/local/oracle/instantclient_12_2:$LD_LIBRARY_PATH7

7.创建tns配置文件

mkdir -p /usr/local/oracle/instantclient_12_2/network/admin

cd /usr/local/oracle/instantclient_12_2/network/admin

vi tnsnames.ora

oracle_309=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.102.100)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)))

8.PATH变量增加oracle 可执行文件路径

vi .bash_profile

PATH=$PATH:$HOME/bin:/usr/local/java/jdk/jdk1.8.0_221/bin:/usr/local/oracle/instantclient_12_2

9.测试连接oracle

[root@192 ~]# sqlplus root/123456@oracle_309

SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 2 11:50:42 2020

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>