Install the Oracle client using instant in CentOS 5.6

Source: Internet
Author: User

Installing the Oracle client in Linux to connect to a remote oracle host to complete data operations is a problem I will solve this time. Search for the Linux oracle keyword on google and find some articles, but it seems that the installation of oracle cient is a bit complicated. In addition, the main function is to connect to remote oracle to query data.

Some articles have mentioned that using instant client to implement functions is feasible based on the original experience, but an error occurs when using sqlplus/nolog in actual operations.

The following is a record of my installation process:

Program:

Wget http://download.oracle.com/otn/linux/instantclient/112020/oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm

Wget http://download.oracle.com/otn/linux/instantclient/112020/oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm

Only the two packages can be downloaded.

Note: To download these two packages, you can go to www.oracle.com to download them. However, you must have an account registered on the oracle website.

Step 1: view the content in the package:

Rpm-qpl oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm

/Usr/lib/oracle/11.2/client/bin/adrci
/Usr/lib/oracle/11.2/client/bin/genezi
/Usr/lib/oracle/11.2/client/lib/libclntsh. so.11.1
/Usr/lib/oracle/11.2/client/lib/libnnz11.so
/Usr/lib/oracle/11.2/client/lib/libocci. so.11.1
/Usr/lib/oracle/11.2/client/lib/libociei. so
/Usr/lib/oracle/11.2/client/lib/libocijdbc11.so
/Usr/lib/oracle/11.2/client/lib/ojdbc5.jar
/Usr/lib/oracle/11.2/client/lib/ojdbc6.jar
/Usr/lib/oracle/11.2/client/lib/xstreams. jar

Rpm-qpl oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm

/Usr/lib/oracle/11.2/client/bin/sqlplus
/Usr/lib/oracle/11.2/client/lib/glogin. SQL
/Usr/lib/oracle/11.2/client/lib/libsqlplus. so
/Usr/lib/oracle/11.2/client/lib/libsqlplusic. so

The time shown above is mainly in two directories:

/Usr/lib/oracle/11.2/client

/Usr/lib/oracle/11.2/client/lib/

Step 2: Install and modify configurations

Rpm-ivh oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm

Rpm-ivh oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm


Add the following environment variables to. bashrc (there is a hidden variable in the $ HOME folder of the logged-on user)

LD_LIBRARY_PATH =/usr/local/lib:/usr/lib/oracle/11.2/client64/lib

Error reported when SQL plus/nolog is enabled

Sqlplus: error while loading shared libraries: */libnnz *. so: cannot restore segment prot after reloc: Permission denied

At that time, I forgot to make an error and noted down the information provided above.

Step 3: modify the system configuration (root user is required)

# Vi/etc/ld. so. conf

/Usr/lib/oracle/11.2/client/lib/

#/Sbin/ldconfig

Run sqlplus/nolog

SQL * Plus: Release 11.2-Production on Wed May 10 17:44:34 2011

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

SQL & gt;

This error is reported and started successfully,

 

Step 4: Configure TNS to connect to a remote oracle database

To connect to a remote oracle database, you must create TNS.

Mkdir-p/usr/lib/oracle/11.2/network/admin/

Cd/usr/lib/oracle/11.2/network/admin/

Touch tnsnames. ora

Edit tnsnames. ora to add your own string

Example:

Orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.99) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)
)
)


Note: You must modify the environment variable:

Add in. bashrc

Export ORACLE_HOME =/usr/lib/oracle/11.2
Export TNS_ADMIN =/usr/lib/oracle/11.2/network/admin

 

Use the source. bashrc command to restart the configuration.

Unregister the user.

Sqlplus username/userpass @ orcl

You can connect to the remote database,

I would like to thank the netizens who posted related articles on the Internet. I have sorted out my installation process here. Most of them have borrowed your experience and I would like to thank you here.

Related Article

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.