Install Oracle Instant Client

First, the demand

The database and application are not on the same host, so you need to install an Oracle Instant client or an Oracle client. But the client is rather large.

Second, install Oracle Instant Client

Download the Oracle Instant Client package

Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Database version is 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 or RPM Package Select one, the system is CentOS, is inherently compatible with Rhel, so choose RPM format.

Take the 64-bit example to download the following files:

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

Install it after downloading. Rpm-uhv

[Email protected] 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 June 9 09:39 oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64 (1). rpm

-rw-r--r--1 root root 595K June 8 18:01 oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm

-rw-r--r--1 root root 813K June 8 18:01 oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm

Drwxrwxr-x 4.0K June 8 17:11 tmp-2.0.6

-rw-r--r--1 root root 13M Apr 20:34 tmp-2.0.6.tar.gz

[Email protected] tmp]#

[Email protected] tmp]# RPM-UHV oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64\ (1\). rpm

99%) ########################################### [100%]

[Email protected] tmp]#

[Email protected] tmp]# RPM-UHV oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm

Preparing ... (100%) # (100%) # # 99%) ######################### ################## [100%]

[Email protected] tmp]#

[Email protected] 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%]

[Email protected] tmp]#

[Email protected] 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

[Email protected] client64]# pwd

/usr/lib/oracle/11.2/client64

[Email protected] client64]# CD bin/

[Email protected] bin]#

[Email protected] bin]#./sqlplus

./sqlplus:error while loading shared libraries:libsqlplus.so:cannot open Shared object file:no such file or directory

[Email protected] bin]#

Add Oracle Libraries

[Email protected] tmp-2.0.6]# more/etc/ld.so.conf.d/oracle.conf

/usr/lib/oracle/11.2/client64/lib

[Email protected] tmp-2.0.6]#

[Email protected] bin]# Ldconfig

[Email protected] bin]#./sqlplus

Sql*plus:release 11.2.0.3.0 Production on Sun June 9 10:24:26 2013

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

Enter User-name:

ERROR:

Ora-12162:tns:net Service name is incorrectly specified

Enter User-name: ^c

[Email protected] bin]#

Test it:

[Email protected] oracle]# sqlplus tmp/[email protected]/momorac.momo.org

Sql*plus:release 11.2.0.3.0 Production on Sun June 9 12:21:29 2013

Copyright (c) 1982, 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>

This article is from the "Travel Life" blog, please be sure to keep this source http://felixgzf.blog.51cto.com/4108324/1792505

Install Oracle Instant Client