Install Oracle Client On CentOS

By
Roy s

This installation is same for all rpm based systems like (Centos/Fedora/RHEL/SLES/Opensuse/Mandriva..)

This tutorial is about 11.2 version client, but should work even for 12.1 version.

Packages are:

oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

In the future, i will include a post with how to download these packages.

1. Oracle Client Installation

Go to Downloaded rpm packages directory and install them with root privileges.

[root@Client-server ~]# yum localinstall oracle* --nogpgcheck

---> Package oracle-instantclient11.2-basic.x86_64 0:11.2.0.4.0-1 set to be updated
 ---> Package oracle-instantclient11.2-devel.x86_64 0:11.2.0.4.0-1 set to be updated
 ---> Package oracle-instantclient11.2-sqlplus.x86_64 0:11.2.0.4.0-1 set to be updated
 --> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================================
 Package                                           Arch                    Version                         Repository                                                              Size
 ========================================================================================================================================================================================
 Installing:
 oracle-instantclient11.2-basic                    x86_64                  11.2.0.4.0-1                    /oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64                    179 M
 oracle-instantclient11.2-devel                    x86_64                  11.2.0.4.0-1                    /oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64                    1.9 M
 oracle-instantclient11.2-sqlplus                  x86_64                  11.2.0.4.0-1                    /oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64                  2.8 M
Transaction Summary
 ========================================================================================================================================================================================
 Install       3 Package(s)
 Upgrade       0 Package(s)
Total size: 184 M
 Is this ok [y/N]: y

2. Configure TNSNames.ora

tnsnames.ora file is used to store database connection information. This file must be created and configured in your current client installation.

To do this, first create your network/admin directory

[root@Client-server ~]# mkdir /usr/lib/oracle/11.2/client64/network/admin -p

Now inside you can make your tnsnames.ora  file.

3. Configure Environment Variables

Create file /etc/profile.d/client.sh with the following file content

 export ORACLE_HOME=/usr/lib/oracle/11.2/client64
 export PATH=$PATH:$ORACLE_HOME/bin
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib
 export TNS_ADMIN=$ORACLE_HOME/network/admin

Now,

1) logout and logon again.

2) Then, run:

sh /etc/profile.d/client.sh

4. Test Installation

To test if Oracle Client and tnsnames.ora works properly execute the following command:

[root@Client-server ~]# sqlplus username@SID-FROM_TNSNAMNE.ORA

Done!