Install and configure oracle client in linux

The installation of the oracle client is very simple. The key lies in the tns configuration. The rpm installation package I used here is that oracle itself is not open source, which is the easiest to install with rpm.

First, download the following three files. Note that the versions are best consistent.

Oracle-instantclient-basic-10.2.0.4-1.i386.rpm

Oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm

Oracle-instantclient-devel-10.2.0.4-1.i386.rpm

2.

Oracle-instantclient-basic-10.2.0.4-1.i386.rpm is the basic dynamic library, jar package, the default installation path is:

The oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm is the client sqlplus installation package, the default installation path is:/usr/lib/oracle/10.2.0.4/client

The oracle-instantclient-devel-10.2.0.4-1.i386.rpm is the api interface file, the default installation path is:/usr/include/oracle/10.2.0.4/client

 

Sudo rpm-avi oracle-instantclient-basic-10.2.0.4-1.i386.rpm

Sudo rpm-avi oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm

Sudo rpm-avi oracle-instantclient-devel-10.2.0.4-1.i386.rpm

 

4.

5. Test the connection

USERNAME/PASSWD@ Test_base

USERNAME.TABLENAMEWhere accountid = 8401428;