How to install the sqlplus client on Linux

How to install the sqlplus client on Linux 1. first go to the Oracle official website to download two packages: oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpmo

How to install the sqlplus client on Linux 1. First download two packages from the official Oracle Website: oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm o

How to install the sqlplus client on Linux

1. First download two packages from the official Oracle Website:

Oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm

Oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

2. install the software package

A) RedHat/CentOS direct rpm installation.

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

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

B) because it is an rpm package, convert it into a deb package in Debian/Ubuntu first:

Alien oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm

Alien oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

Get

Oracle-instantclient11.2-basic-11.2.0.2.0-2_amd64.deb

Oracle-instantclient11.2-sqlplus-11.2.0.2.0-2_amd64.deb

Then install dpkg

Dpkg-I oracle-instantclient11.2-basic-11.2.0.2.0-2_amd64.deb

Dpkg-I oracle-instantclient11.2-basic-11.2.0.2.0-2_amd64.deb

This will be installed in the default directory --/usr/lib/oracle/11.2/client64/

4. Some environment variables need to be exposed after installation.

Nano/etc/profile

Add:

Export ORACLE_HOME =/usr/lib/oracle/11.2/client64
Export TNS_ADMIN = $ ORACLE_HOME
Export PATH = $ PATH: $ ORACLE_HOME/bin
Export LD_LIBRARY_PATH = $ LD_LIBRARY_PATH: $ ORACLE_HOME/lib

5. Configure the TNS connection file.

Cd/usr/lib/oracle/11.2/client64/
Vi tnsnames. ora

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.109) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

6. Execute sqlplus. If the package libaio cannot be found, download and install it here.

In the same way, Redhat/CentOS is directly installed by rpm, and Debian/Ubuntu is converted into a. deb package and then installed.

Wget ftp://mirror.switch.ch/pool/3/mirror/centos/4.8/ OS /x86_64/CentOS/RPMS/libaio-0.3.105-2.x86_64.rpm

6. Execute sqlplus again. If there is still a mistake, reboot should be OK.

Sqlplus system/123456 @ test

Oracle Study Notes: sqlplus User Logon

Sqlplus ORA-01017 when logging on to Oracle: invalid username/password; logon denied Error

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

This article permanently updates the link address:

,