R学习笔记之<访问远程Oracle数据库>

一、install the Oracle Instant Client

注意：Each step must be performed as root.

(1) 到官网上 http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html下载以下文件：

• oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm (必须的)
  
• oracle-instantclient12.1-odbc-12.1.0.2.0-1.x86_64.rpm
  
• oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
  
• oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
  
• oracle-instantclient12.1-jdbc-12.1.0.2.0-1.x86_64.rpm

(2) Install the packages. 

[root@localhost ~]# rpm -ivh oracle-instantclient12.1-*

卸载rpm -e file    这里的file不要有.rpm后缀

(3) 在/etc/ld.so.conf.d目录下创建一个配置文件 oracle-instant-client.conf 用来将Oracle client libraries 添加到  LD_LIBRARY_PATH  

[root@localhost ~]# cat > /etc/ld.so.conf.d/oracle-instant-client.conf << EOL
> /usr/lib/oracle/12.1/client64/lib
> EOL

这样编辑的好处是输入目录时可以用Tab键补全。

Rebuild the LD_LIBRARY_PATH：

[root@localhost ~]# ldconfig 

(4)使用sqlplus连接数据库，如果你使用RPMs来安装client，则它们已经存在你的PATH中了。（运行之前确保网络没问题）

[root@localhost ~]# sqlplus64 username/password@remoteIP:1521/databaseName

SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 15 22:58:53 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 

sqlplus登录命令常用的几种方式：

• sqlplus username/password  如：普通用户登录  sqlplus scott/tiger
<