前往Oracle官网下载rpm包:点击前往
我选择安装的版本是11.2.0.4.0,所以我下载的文件分别为:
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
创建安装文件夹:
mkdir /data/oracle
将文件移动到此文件夹下:
安装rpm包:
rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
查看rpm的安装路径:
rpm -qpl oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
在对应路径下手动创建sqlnet.ora和tnsnames.ora:
mkdir -p /usr/lib/oracle/11.2/client64/network/admin
添加环境变量:
vim /root/.bash_profile
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib export TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin export ORACLE_HOME=/usr/lib/oracle/11.2/client64/bin export PATH=$PATH:$LD_LIBRARY_PATH:$TNS_ADMIN:$ORACLE_HOME
加载环境变量:
source /root/.bash_profile
使用命令sqlplus测试: