Shulou(Shulou.com)06/01 Report--

I. demand

The database and the application are not on the same host, so you need to install the oracle instant client, which can also be the client of oracle. It's just that the client is huge.

Second, install the oracle instant client

Download the Oracle Instant client package

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

The 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 (60331694 bytes) (cksum-3890813254)

Oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm (59492344 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 (837574 bytes) (cksum-3996754029)

Oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm (831586 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 (641586 bytes) (cksum-1205517808)

Oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm (609139 bytes) (cksum-2701969031)

Choose one of the zip or rpm packages, the system is centos, naturally compatible with RHEL, so choose the rpm format.

Take 64-bit as an example, 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 it. 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] #

Add 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] #

Test it:

[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 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.