linux oracle client 连接数据库,linux安装oracle client客户端连接远程数据库

有时候，需要在linux服务器远程连接oracle数据，此时需要在服务器上安装oracle clinet客户端，用来连接远程的数据库。

采用rpm安装方式(root执行)

1:下载rpm软件包

oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm      基本的动态库(oci,bocci,jdbc-oci)

oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm    客户端sqlplus安装包

oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm      API接口文件

2:RPM安装(默认路径/usr/lib/oracle/11.2/client64)

rpm -ivh oracle-instantclient-basic-11.2.0.4.0-1.x86_64.rpm

rpm -ivh oracle-instantclient-sqlplus-11.2.0.4.0-1.x86_64.rpm

rpm -ivh oracle-instantclient-devel-11.2.0.4.0-1.x86_64.rpm

3:创建network/admin目录

mkdir -p /usr/lib/oracle/11.2/client64/network/admin

chown -R oracle:oracle /usr/lib/oracle

4:创建TNS(TNS是oracle数据库连接的客户端的一个工具，添加红色部分)

cd /usr/lib/oracle/11.2/client64/network/admin

vi tnsnames.ora

ORCL =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

Note:host是远程数据库的ip地址，service_name为远程数据库的sid

5:配置环境变量(添加红色部分的环境变量)

vi .bash_profile

export  ORACLE_HOME=/usr/lib/oracle/11.2/client64export  TNS_ADMIN=$ORACLE_HOME/network/adminexport  NLS_LANG='simplified chinese_china'.ZHS16GBKexport  LD_LIBRARY_PATH=$ORACLE_HOME/libexport  PATH=$ORACLE_HOME/bin:$PATH

6:生效环境变量

source .bash_profile

echo $OARCLE_HOME

7:测试

sqlplus username/password@orcl