Oracle Instant Client for linux安装

一 . 下载地址

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html?ssSourceSiteId=otncn

二. 解压

[mysql@mysql ~]$ ls
instantclient_11_2                            instantclient-sqlplus-linux.x64-11.2.0.4.0.zip
instantclient-basic-linux.x64-11.2.0.4.0.zip  oradiag_mysql

自然解压后，会生成“instantclient_11_2”目录，在其下建立目录“/network/admin”，创建文件：“tnsnames.ora”,并添加tns：

[mysql@mysql admin]$ cat tnsnames.ora 
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.48.10)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

三. 设置环境变量

[mysql@mysql ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/u01/my3306/bin:/home/mysql/instantclient_11_2


export PATH

export LD_LIBRARY_PATH=/home/mysql/instantclient_11_2 #必须配置
export ORACLE_HOME=/home/mysql/instantclient_11_2
export TNS_ADMIN=/home/mysql/instantclient_11_2