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

What is the oracle client:

The oracle client only refers to the tools that interact with the server. To log in to use the oracle database service, you need to install the client (such as PLSQL) and connect to the database using PLSQL to perform some operations such as adding, deleting, modifying and querying the oralce service.

Linux how to install the oracle client:

1. First of all, download the installation package on Oracle's official website:

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

Download the corresponding client according to the version of the accessed data. Each package is divided into .zip and .rpm format packages. Zip package is equivalent to unzipped installation version, while rpm package requires installation version.

2, install and extract to / usr/local/oracle

Unzip instantclient-basic-linux.x64-11.2.0.4.0.zip

Unzip instantclient-sqlplus-linux.x64-11.2.0.4.0.zip

Generate directory / usr/local/oracle/instantclient_11_2

3, create a new mkdir-p. / network/admin in the above directory

Generate directory / usr/local/oracle/instantclient_11_2/network/admin

4, create a new tnsnames.ora file in the above directory and edit the database connection information

History_162 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.1.197.1) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SID = xxx)

5. Configure environment variables

Vi .bash _ profile

Export ORACLE_HOME=/usr/local/oracle/instantclient_11_2export TNS_ADMIN=$ORACLE_HOME/network/admin##export NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8export LD_LIBRARY_PATH=$ORACLE_HOMEexport PATH=$ORACLE_HOME:$PATH

Source .bash _ profile

6. Test the database connection

Sqlplus username/passwd@history_162

This is how linux installs the oracle client. For more details, please pay attention to other related articles!

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.