linux系统安装并配置oracle客户端
1.下载安装包
wget http://repo.yun.ccb.com/PUBLIC/DB/oracle/oracle_client_12.2.0.1_linux.zip
2.解压到当前目录
unzip oracle_client_12.2.0.1_linux.zip
3.安装
rpm - ivh oracle_client_XXXXXXX.rpm
4.切换用户
su - oracle
注:oracle用户是已创建好的
5.配置环境变量
vi /home/oracle/.bash_profile
清空,复制以下内容:
export ORACLE_BASE=/home/uuu/oracle
export ORACLE_HOME=O R A C L E B A S E / p r o d u c t / 12.2.0 e x p o r t L D L I B R A R Y P A T H = : ORACLE_BASE/product/12.2.0 export LD_LIBRARY_PATH=:ORACLEBASE/product/12.2.0exportLDLIBRARYPATH=:ORACLE_HOME/lib:O R A C L E H O M E / l i b 32 e x p o r t L I B P A T H = ORACLE_HOME/lib32 export LIBPATH=ORACLEHOME/lib32exportLIBPATH=LD_LIBRARY_PATH
export PATH=O R A C L E H O M E / b i n : ORACLE_HOME/bin:ORACLEHOME/bin:ORACLE_HOME/OPatch:/usr/bin:/etc:/usr/sbin:P A T H e x p o r t T N S A D M I N = PATH export TNS_ADMIN=PATHexportTNSADMIN=ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exit
su - oracle
6.创建连接串
vi $ORACLE_HOME/network/admin/tnsnames.ora
将以下内容粘至最下方
demo1=
(DESCRIPTION=
(ENABLE=BROKEN)
(LOAD_BALANCE=off)
(FAILOVER=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=128.021.161.238)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=sev)
(FAILOVER_MODE=(TYPE=select)(METHOD=basic))
(server=dedicated)
)
)
7.验证是否成功
sqlplus user1/123456demo1