Centos Oracle Client 安裝

1. 下載: Oracle Client
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html
oracle-instantclient11.1-basic-11.1.0.7.0-1.i386.rpm
oracle-instantclient11.1-sqlplus-11.1.0.7.0-1.i386.rpm
2. 安裝:
rpm -ivh oracle*.rpm
3. 配置:
修改 vi ~/.bash_profile

ORACLE_HOME=/usr/lib/oracle/11.1
LD_LIBRARY_PATH=$ORACLE_HOME/client/lib
NLS_LANG=AMERICAN_AMERICA.UTF8
SQLPATH=$ORACLE_HOME/client/lib
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_HOME
export PATH
export LD_LIBRARY_PATH NLS_LANG SQLPATH

4. 建立目錄
在$oracle_home下
mkdir network
mkdir admin
touch tnsnames.ora

5. 修改
vi /etc/ld.so.conf
/usr/lib/oracle/11.1/client/lib

6. 執行
ldconfig

7. 測試
sqlplus /nolog