Install Oracle Instant Client

Source: Internet
Author: User
Tags sqlplus

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.