linux环境安装oracle客户端

一、部署包下载

Oracle Instant Client - Free tools and libraries for connecting to Oracle Database

包名：instantclient-basic-linux.x64-11.2.0.4.0.zip

          instantclient-sqlplus-linux.x64-11.2.0.4.0.zip

二、解压安装

        部署路径为/usr/local，故步骤如下：

mkdir /usr/local/oracle
unzip /usr/local/oracle/instantclient-basic-linux.x64-11.2.0.4.0.zip
unzip /usr/local/oracle/instantclient-sqlplus-linux.x64-11.2.0.4.0.zip
cd /usr/local/oracle/instantclient_11_2
mkdir -p network/admin
cd network/admin
新建tnsnames.ora文件

CM = (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.26.156.232)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = UFICS)
    )
  )

以上ip为oracle数据库服务器ip及端口，service_name为oracle服务名，可通过服务器查询，sql如下：SELECT name FROM gv$services;

三、环境变量修改

cd ~
vi vi .bash_profile    添加如下内容

export ORACLE_HOME=/usr/local/oracle/instantclient_11_2
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
export PATH=$PATH:/usr/sbin:/sbin:$FBASE_HOME/bin
export PATH=$ORACLE_HOME:$PATH

执行环境变量
source .bash_profile

测试数据库连接
sqlplus username/passwd@cm

注：其他用户需要使用oracle客户端，则只需要将对应用户下环境变量增加上述内容即可，并执行source即可