1,首先Oracle官网下载安装包:
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
2,安装解压缩到
mkdir -p /home/oraClient/u01/app/oracle/khd
unzip /home/oraClient/u01/app/oracle/khd/instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip /home/oraClient/u01/app/oracle/khd/instantclient-jdbc-linux.x64-12.2.0.1.0.zip
unzip /home/oraClient/u01/app/oracle/khd/instantclient-odbc-linux.x64-12.2.0.1.0-2.zip
unzip /home/oraClient/u01/app/oracle/khd/instantclient-sdk-linux.x64-12.2.0.1.0.zip
unzip /home/oraClient/u01/app/oracle/khd/instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
unzip /home/oraClient/u01/app/oracle/khd/instantclient-tools-linux.x64-12.2.0.1.0.zip
3, 创建Oracle用户和用户组
[root@getoraclelnx01 Server]# groupadd dba
[root@getoraclelnx01 Server]# groupadd oinstall
[root@getoraclelnx01 Server]# useradd -g oinstall -G dba oraClient
[root@getoraclelnx01 Server]# id oraClient
uid=502(oraClient) gid=503(oinstall) groups=503(oinstall),502(dba)
[root@getoraclelnx01 Server]#
4,配置环境变量
切换到oraClient用户,su oraClient,执行cd ~
添加环境变量
vi .bash_profile
Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
export PATH
export ORACLE_HOME=/home/oraClient/u01/app/oracle/khd/instantclient_12_2
export LD_LIBRARY_PATH= L D L I B R A R Y