linux系統安裝并配置oracle客戶端

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=: ORACLEB?ASE/product/12.2.0exportLDL?IBRARYP?ATH=: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= ORACLEH?OME/lib32exportLIBPATH=LD_LIBRARY_PATH
export PATH= O R A C L E H O M E / b i n : ORACLE_HOME/bin: ORACLEH?OME/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= PATHexportTNSA?DMIN=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