linux安装oracle客户端

下载客户端软件

客户端下载地址

?

1 2	链接：https://pan.baidu.com/s/1StXjSjQ_6wRuwj4tewRlaA 提取码：8ynu

 sqlldr工具

链接：https://pan.baidu.com/s/1ZmGSY0ECliLhY5s6FXBNeA 
提取码：8iab

plsql工具

链接：https://pan.baidu.com/s/1v8F-uR7X923qTy8SULHbEg 
提取码：e2an

将软件上传至服务器，进入软件目录执行安装

rpm -ivh oracle-instantclient18.5-basic-18.5.0.0.0-3.x86_64.rpm
rpm -ivh oracle-instantclient18.5-sqlplus-18.5.0.0.0-3.x86_64.rpm
rpm -ivh oracle-instantclient18.5-tools-18.5.0.0.0-3.x86_64.rpm

配置环境变量

vi /etc/profile

PATH=$PATH:$HOME/bin
export ORACLE_HOME=/usr/lib/oracle/18.5/client64
export ORACLE_BASE=/usr/lib/oracle/18.5/
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH

source /etc/profile

配置监听

vi  $ORACLE_HOME/network/admin/tnsnames.ora

lol_114 = 

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

报如下错误：

sqlplus: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

yum install libnsl.x86_64

连接测试

sqlplus tuser/123456@192.168.101.114:1521/orcl