Oracle DB Client Installation

Go to Oracle Linux x86-64 instant clients download page

Download the matching client

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

Install

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

Set environment variables in your ~/.bash_profile

Reload your .bash_profile by simply typing source ~/.bash_profile (suggested by jbass) or Log-out user and log-in again.

TNS Name Add in Ora file in (/opt/oracle/instantclient/network/admin)

MY.DB.NAME =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP) (HOST = {i put my db host ip}) (PORT = 1521))
  (CONNECT_DATA = 
    (SERVICE_NAME = MY.DB.NAME)
  )
)

Now you’re ready to use SQL*Plus and connect your server. Type in :

sqlplus "username/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.1)(PORT=1521))(CONNECT_DATA=(SID=YOURSID)))"