[Oracle Instant Client 11.2 Installation on Oracle Linux 6.xx]

# mkdir -p /u01/app/oracle/instantclient

# unzip instantclient-basic-linux.x64-11.2.0.3.0.zip
# unzip instantclient-sqlplus-linux.x64-11.2.0.3.0.zip
# mv instantclient_11_2/ 11.2
# mv 11.2/ /u01/app/oracle/instantclient

# chown -R oracle11 /u01/app/oracle/instantclient/

# vi /etc/yum.repos.d/oracleLinuxRepoINTERNET.repo

[OEL_INTERNET]
name=Oracle Enterprise Linux $releasever - $basearch
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6
gpgcheck=1
enabled=1

# yum install -y \
gcc \
make \
readline-devel.x86_64

# yum install -y libaio-devel

# cd /tmp
# wget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.37.tar.gz

# tar zxvf rlwrap-0.37.tar.gz
# cd rlwrap-0.37
# ./configure

# make && make check && make install

# su - oracle11

$ vi ~/.bash_profile

#################################
## Oracle Instant Client

export SQLPATH=/u01/app/oracle/instantclient/11.2
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export TNS_ADMIN=${SQLPATH}
export LD_LIBRARY_PATH=${SQLPATH}
export PATH=${SQLPATH}:${PATH}

alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'

#################################

$ source ~/.bash_profile

# sqlplus /nolog

SQL> conn system/system@oracle112:1521/ora112.localdomain
Connected.

# vi /u01/app/oracle/instantclient/11.2/tnsnames.ora

oracle11 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle112.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora112.localdomain)
    )
  )

# sqlplus /nolog

SQL> conn system/manager@oracle11
Connected.