CentOS-7 Install SQLPlus Client

下载

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

安装

 yum install ./downloads/oracle-*  

$ tree -L 1 ./downloads                   
./downloads
├── oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
└── oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm

$ sudo yum install ./downloads/oracle-*  
已加载插件：fastestmirror, langpacks
正在检查 ./oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm: oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64
./oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm 将被安装
正在检查 ./oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm: oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64
./oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm 将被安装
正在解决依赖关系
--> 正在检查事务
---> 软件包 oracle-instantclient12.2-basic.x86_64.0.12.2.0.1.0-1 将被 安装
---> 软件包 oracle-instantclient12.2-sqlplus.x86_64.0.12.2.0.1.0-1 将被 安装
--> 解决依赖关系完成

.......

总计：214 M
安装大小：214 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  正在安装    : oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64      1/2 
  正在安装    : oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64    2/2 
  验证中      : oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64      1/2 
  验证中      : oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64    2/2

已安装:
  oracle-instantclient12.2-basic.x86_64 0:12.2.0.1.0-1
  oracle-instantclient12.2-sqlplus.x86_64 0:12.2.0.1.0-1 

完毕！

配置环境变量

ORACLE_HOME=/usr/lib/oracle/12.2/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

source /etc/profile

$ sudo vim /etc/profile 

# 添加
ORACLE_HOME=/usr/lib/oracle/12.2/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin

$ sudo source /etc/profile

测试

$ sqlplus system/PASSWORD@ec.orac.uat:1521/ecdbuat as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 22 16:48:25 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> 

sqlplus 命令历史

yum install epel-release
yum install rlwrap 

alias sqlplus='rlwrap sqlplus'

$ vim ~/.bashrc 
# 添加
alias sqlplus='rlwrap sqlplus'

$ source ~/.bashrc

配置连接 tnsnames.ora

执行如下命令 cd $ORACLE_HOME，进入相应的目录下，然后执行命令 vim tnsnames.ora，并写入如下内容：

$ mkdir -p $ORACLE_HOME/network/admin/

$ cd $ORACLE_HOME/network/admin/

$ vim tnsnames.ora

ECDBUAT=
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.12.123)(PORT = 1521))
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = ECDBUAT)
  )
)

$ sqlplus system/PASSWORD@ECDBUAT  as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Dec 1 23:48:12 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Last Successful login time: Sun Dec 01 2019 23:46:46 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>