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(这条一定要有,不然通过linux导入数据中文可能会乱码)
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