oracle客戶端的安裝是非常簡(jiǎn)單的，關(guān)鍵在tns配置，我這里使用的rpm安裝包，oracle本身就不是開源，那使用rpm安裝時(shí)最簡(jiǎn)單的。
1.要遠(yuǎn)程使用oracle，先下載下面三個(gè)文件，注意版本最好一致。
oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm oracle-instantclient-devel-10.2.0.4-1.i386.rpm |
2.PM安裝
oracle-instantclient-basic-10.2.0.4-1.i386.rpm是基本的動(dòng)態(tài)庫(kù)、jar包，默認(rèn)安裝路徑是：/usr/lib/oracle/10.2.0.4/client oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm是客戶端sqlplus安裝包, 默認(rèn)安裝路徑是：/usr/lib/oracle/10.2.0.4/client oracle-instantclient-devel-10.2.0.4-1.i386.rpm是api接口文件,默認(rèn)安裝路徑是：/usr/include/oracle/10.2.0.4/client |
這里不需要修改默認(rèn)路徑,直接安裝即可：
sudo rpm-avi oracle-instantclient-basic-10.2.0.4-1.i386.rpm sudo rpm-avi oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm sudo rpm-avi oracle-instantclient-devel-10.2.0.4-1.i386.rpm |
3.配置環(huán)境變量
vi /etc/profile export ORACLE_HOME=/usr/lib/oracle/10.2.0.4 export TNS_ADMIN=$ORACLE_HOME/network/admin export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK exportLD_LIBRARY_PATH=$ORACLE_HOME/client/lib:$LD_LIBRARY_PATH exportOCI_HEADERS_HOME=/usr/include/oracle/10.2.0.4/client export OCI_LIBS_HOME=$ORACLE_HOME/client/lib |
后面兩項(xiàng)是為了我們的程序程序編譯時(shí)使用方便，編譯時(shí)直接加入選項(xiàng)：
-I$( OCI_HEADERS_HOME) –L$( OCI_LIBS_HOME) –l occi
4.配置監(jiān)聽器和網(wǎng)絡(luò)環(huán)境
[huangxw@ubuntu admin]$ cat/usr/lib/oracle/10.2.0.4/network/admin/tnsnames.ora test_base= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = ****)) ) (CONNECT_DATA = (SERVICE_NAME = tt4adol) ) ) |
5.測(cè)試連接
[huangxw@ubuntu bin]$./sqlplus USERNAME/PASSWD@test_base SQL*Plus: Release 10.2.0.4.0 - Production onMon Jan 13 10:09:31 2014 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining andReal Application Testing options SQL> select * from USERNAME.TABLENAME where accountid = 8401428; ACCOUNTID INVTA SNDA RAINA INSB SPEN REMN ---------- ---------- ---------- -------------------- ---------- ---------- INVTC SPDC REIN ---------- ---------- ---------- 8401428 0 0 100000 0 0 0 0 0 0 |