文件下载地址:
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
1.复制压缩包内的2个rpm文件到服务器上
oracle-instantclient12.2-basic-12.2.0.0.0-1.x86_64.rpm
oracle-instantclient12.2-tools-12.2.0.1.0-1.x86_64.rpm
2.oracle-instantclient12.2-basic
在服务器所在rpm文件目录执行:
sudo yum install oracle-instantclient12.2-basic-12.2.0.0.0-1.x86_64.rpm
Is this ok [y/d/N]:
输入y
回车
更新运行时链接路径
执行:
sudo sh -c "echo /usr/lib/oracle/12.2/client64/lib> /etc/ld.so.conf.d/oracle-instantclient.conf"
执行:
sudo ldconfig
3.安装:oracle-instantclient12.2-tools-
执行:
sudo yum install oracle-instantclient12.2-tools-12.2.0.1.0-1.x86_64.rpm
Is this ok [y/d/N]:
输入y
回车
4.添加环境变量
vi /etc/profile
在文件末尾添加环境变量:
export PATH=/usr/lib/oracle/12.2/client64/bin:$PATH
export ORACLE_HOME=/usr/lib/oracle/12.2/client64/lib
export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib:$LD_LIBRARY_PATH
保存退出
执行:source /etc/profile
5.测试
执行:sqlldr
若第一行为:
SQL*Loader: Release 12.2.0.1.0 - Production on Fri Jan 8 02:21:36 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
则表示安装sqlldr命令成功