oracle instantclient_12_2安装

下载地址

选择：

Instant Client for Linux x86-64

1）下载以下两个ZIP包：

instantclient-basic-linux.x64-12.2.0.1.0.zip

instantclient-sqlplus-linux.x64-12.2.0.1.0.zip

2）安装依赖包：

yum install libaio* -y

3）上传到服务器并解压到相同目录下

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

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

sudo mv instantclient_12_2 /soft/

4）添加环境变量

export ORACLE_HOME=/soft/instantclient_12_2

export TNS_ADMIN=$ORACLE_HOME/network/admin

export LD_LIBRARY_PATH=$ORACLE_HOME

export PATH=$ORACLE_HOME:$PATH

5）添加tnsnames.ora文件

新建目录：

/soft/instantclient_12_2/network/admin

test =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 47.75.108.44)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = tro)))