一 . 下载地址
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