linux安裝oracle client客戶端連接遠程數據庫
有時候,需要在linux服務器遠程連接oracle數據,此時需要在服務器上安裝oracle clinet客戶端,用來連接遠程的數據庫。
採用rpm安裝方式(root執行)
1:下載rpm軟件包
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm 基本的動態庫(oci,bocci,jdbc-oci)
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm 客戶端sqlplus安裝包
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm API接口文件
2:RPM安裝(默認路徑/usr/lib/oracle/11.2/client64)
rpm -ivh oracle-instantclient-basic-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient-sqlplus-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient-devel-11.2.0.4.0-1.x86_64.rpm
3:創建network/admin目錄
mkdir -p /usr/lib/oracle/11.2/client64/network/admin
chown -R oracle:oracle /usr/lib/oracle
4:創建TNS(TNS是oracle數據庫連接的客戶端的一個工具,添加紅色部分)
cd /usr/lib/oracle/11.2/client64/network/admin
vi tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.169.1.109)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
Note:host是遠程數據庫的ip地址,service_name為遠程數據庫的sid
5:配置環境變量(添加紅色部分的環境變量)
vi .bash_profile
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=’simplified chinese_china’.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
6:生效環境變量
source .bash_profile
echo $OARCLE_HOME
7:測試
sqlplus username/password@orcl
以下文章點擊率最高
Loading…