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;