linux 上簡(jiǎn)單安裝Oracle 11g 客戶端
2022-5-12
因工作需要在linux上安裝oracle客戶端味榛，只要使用到sqlplus摸柄、exp、imp
不想裝完整的包，根據(jù)網(wǎng)上資料實(shí)踐通過牧牢，記錄如下摹菠。
材料：
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
1盒卸、安裝客戶端
rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
2、創(chuàng)建tnsname.ora
mkdir -p /usr/lib/oracle/11.2/client64/network/admin/
vim /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXXX)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
3次氨、設(shè)置環(huán)境變量
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export TNS_ADMIN=ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
#如果想永久有效,編輯 ~/.bashrc_profile
5蔽介、連接數(shù)據(jù)庫(kù)測(cè)試
sqlplus username/passwd@ORCL
#*** 如果sqlplus 用不起來：
#vi /etc/ld.so.conf 最后加入一行 /usr/lib/oracle/11.2/client64/lib
#idconfig -- 重新鏈接動(dòng)態(tài)庫(kù)
6、安裝 exp/imp
把server 端的 exp，imp虹蓄，impus.msb,expus.msb 復(fù)制到客戶端
server端的位置 $ORACLE_HOME/bin/exp,imp
server端的位置 $ORACLE_HOME/rdbms/mesg/expus.msb,impus.msb
先準(zhǔn)備好這4個(gè)文件
cp ./exp /usr/lib/oracle/11.2/client64/bin
cp ./imp /usr/lib/oracle/11.2/client64/bin
mkdir -p /usr/lib/oracle/11.2/client64/rdbms/mesg
cp ./impus.msb /usr/lib/oracle/11.2/client64/rdbms/mesg
cp ./expus.msb /usr/lib/oracle/11.2/client64/rdbms/mesg
chmod 755 /usr/lib/oracle/11.2/client64/bin/*
chmod 755 /usr/lib/oracle/11.2/client64/rdbms/mesg/*
END
