下载地址
http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html
选择:
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)))
文章评论