- 下载组件Oracle Instant Client
官网地址:http://www.oracle.com/technetwork/database/database-technologies/instant-client/
- 下载对应安装包
- 安装
rpm -ivh oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
rpm -ivh oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
rpm -ivh oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
- 安装确认
rpm -qa|grep -i oracle
- 配置环境变量
vim ~/.bash_profile
- 编辑文件内容
PATH=$PATH:$HOME/bin
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_BASE=/usr/lib/oracle/12.2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
export PATH
- 使得更新的配置文件生效
source ~/.bash_profile
- 创建tns文件
vim /usr/lib/oracle/12.2/client64/network/admin/tnsnames.ora
- 测试连接
sqlplus 用户名/密码@库名