189 8069 5689
一、需求
数据库和应用没在同一台主机上，所以需要安装oracle即时客户端，也可以是oracle的客户端。只不过客户端比较庞大。
二、安装oracle即时客户端
下载Oracle即时客户端程序包
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
数据库版本是11.2.0.3.0
Instant Client Package - Basic:
All files required to run OCI, OCCI, and JDBC-OCI applications
Image instantclient-basic-linux.x64-11.2.0.3.0.zip (60,331,694 bytes) (cksum - 3890813254)
oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm (59,492,344 bytes) (cksum - 3293107452)
*Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client
instantclient-sqlplus-linux.x64-11.2.0.3.0.zip (837,574 bytes) (cksum - 3996754029)
oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm (831,586 bytes) (cksum - 2150224972)
*Instant Client Package - SDK:
Additional header files and an example makefile for developing Oracle applications with Instant Client
instantclient-sdk-linux.x64-11.2.0.3.0.zip (641,586 bytes) (cksum - 1205517808)
oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm (609,139 bytes) (cksum - 2701969031)
zip 或者 rpm 包选择一种，系统是centos，天生兼容RHEL，所以选择rpm格式的。
以64位为例，下载以下几个文件：
oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm
下载完以后装上。 rpm -Uhv
[root@mpaydb tmp]# rm -f oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm
ll -h
total 71M
-rw-r--r-- 1 root root 57M Jun 9 09:39 oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64(1).rpm
-rw-r--r-- 1 root root 595K Jun 8 18:01 oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm
-rw-r--r-- 1 root root 813K Jun 8 18:01 oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm
drwxrwxr-x 13 1000 1000 4.0K Jun 8 17:11 tmp-2.0.6
-rw-r--r-- 1 root root 13M Apr 22 20:34 tmp-2.0.6.tar.gz
[root@mpaydb tmp]#
[root@mpaydb tmp]# rpm -Uhv oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64\(1\).rpm
99%)########################################### [100%]
[root@mpaydb tmp]#
[root@mpaydb tmp]# rpm -Uhv oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm
Preparing... (100%)# (100%)## 99%)########################################### [100%]
[root@mpaydb tmp]#
[root@mpaydb tmp]# rpm -Uhv oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm sqlplus-11.2.0.3.0-1.x86_64.rpm
Preparing... (100%)# (100%)##
(100%)########################################### [100%]
[root@mpaydb tmp]#
[root@mpaydb tmp]# rpm -qa|grep oracle
oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64
oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64
oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64
[root@mpaydb client64]# pwd
/usr/lib/oracle/11.2/client64
[root@mpaydb client64]# cd bin/
[root@mpaydb bin]#
[root@mpaydb bin]# ./sqlplus
./sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
[root@mpaydb bin]#
添加 Oracle libraries
[root@mpaydb tmp-2.0.6]# more /etc/ld.so.conf.d/oracle.conf
/usr/lib/oracle/11.2/client64/lib
[root@mpaydb tmp-2.0.6]#
[root@mpaydb bin]# ldconfig
[root@mpaydb bin]# ./sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Sun Jun 9 10:24:26 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name: ^C
[root@mpaydb bin]#
测试一下：
[root@mpaydb oracle]# sqlplus tmp/111111@10.101.5.77/MOMORAC.momo.org
SQL*Plus: Release 11.2.0.3.0 Production on Sun Jun 9 12:21:29 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
SQL>
另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。