oracle instantclient_12_2安装

最新推荐文章于 2023-06-09 14:03:24 发布

weixin_30823833

最新推荐文章于 2023-06-09 14:03:24 发布

阅读量5.1k

点赞数

文章标签：数据库网络运维

原文链接：http://www.cnblogs.com/Dev0ps/p/11128514.html

版权

下载地址

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 LD_LIBRARY_PATH=/soft/instantclient_12_2
export TNS_ADMIN=/soft/instantclient_12_2
export 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)))

转载于:https://www.cnblogs.com/Dev0ps/p/11128514.html