Linux下如何安装sqlplus

1 下载软件

https://www.oracle.com/cn/database/technology/linuxx86-64soft.html

2 主要是下载2个

sqlplus、basic,注意选择相同版本

比如这里我选择的两个:oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm、oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

3 安装

rpm -ivh ./oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
rpm -ivh ./oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

4 配置

~/.bash_profile

ORACLE_HOME=/usr/lib/oracle/11.2/client64
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

export PATH
export ORACLE_HOME
export LD_LIBRARY_PATH

5 测试

sqlplus

 

Leave a Reply

Your email address will not be published.