下载地址
选择:
Instant Client for Linux x86-641)下载以下两个ZIP包:
- instantclient-basic-linux.x64-12.2.0.1.0.zip
- instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
yum install libaio* -y
3)上传到服务器并解压到相同目录下
unzip instantclient-basic-linux.x64-12.2.0.1.0.zipunzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zipsudo mv instantclient_12_2 /soft/
4)添加环境变量
export ORACLE_HOME=/soft/instantclient_12_2export LD_LIBRARY_PATH=/soft/instantclient_12_2export TNS_ADMIN=/soft/instantclient_12_2export PATH=$PATH:/soft/instantclient_12_2
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)))