linux下安装oracle instant client,Linux下安装Oracle Instant Client

Linux下安装Oracle Instant Client

Oracle Instant Client下载地址：

http://www.doczj.com/doc/1b3b3a34b90d6c85ec3ac635.html/technetwork/topics/linuxsoft-082809.html

可以下载rpm包或者zip包进行安装,这里已rpm包为例;

1、下载rpm 包

oracle-instantclient11.2-basic-11.2.0.3.0-1.i386.rpm

oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.i386.rpm

oracle-instantclient11.2-devel-11.2.0.3.0-1.i386.rpm

2、使用如下命令进行安装

rpm -ivh oracle-instantclient11.2-basic-11.2.0.3.0-1.i386.rpm

rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.i386.rpm

rpm -ivh oracle-instantclient11.2-devel-11.2.0.3.0-1.i386.rpm

安装完成后，

ORACLE Instant Client 相关的头文件在/usr/include/oracle/11.2/client/下；

库文件在/usr/lib/oracle/11.2/client/下(cliient目录下有lib 和bin两个目录.)；

配置如下环境变量：~/.bashrc

export ORACLE_HOME=/usr/lib/oracle/11.2/client

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

{ network/admin目录是手动创建的，用于sqlplus连接数据库}，再在目录下创建一个文件tnsnames.ora，配置了数据库连接，文件内容如下：

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 199.20.10.5)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

配置完毕后，执行命令：source ~/.bashrc

执行sqlplus命令即可连接数据库进行操作，例如：

sqlplus /nolog

conn scott/tiger@orcl