[oracle] installation of oracle instant client

1. download instant client
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
select ones matched verion of oracle server.  (rpm)

2.
> mkdir /usr/lib/oracle
> cd /usr/lib/oracle
> rpm -Uvh oracle-instantclient-basic-10.2.0.4-1.x86_64.rpm
> rpm -Uvh oracle-instantclient-sqlplus-10.2.0.4-1.x86_64.rpm
> vi /usr/lib/oracle/10.2.0.4/client64/tnsnames.ora
HDA =
    (DESCRIPTION =
         (ADDRESS = (PROTOCOL = TCP)(HOST =IP_ADRESS)(PORT = 1521))
         (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = hda)
         )
    )
> vi /etc/profile.d/oracle.sh
# for Oracle Instant Client
if [ -d /usr/lib/oracle ]
then
     LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/10.2.0.4/client64/lib/;export   LD_LIBRARY_PATH
     TNS_ADMIN=/usr/lib/oracle/10.2.0.4/client64; export TNS_ADMIN;
     NLS_LANG=AMERICAN_AMERICA.KO16KSC5601;export NLS_LANG;
#   PATH=$PATH:/usr/lib/oracle;export PATH;
#   SQLPATH=/usr/lib/oracle; export SQLPATH;
fi
> source /etc/profile/oracle.sh
> sqlplus64 DBNAME@HDA

== sqlldr ==
> scp orahda@111.111.111.11:/oracle/orahda/product/10.2.0/bin/sqlldr /usr/bin/
> mkdir /usr/lib/oracle/10.2.0.4/client64/rdbms/mesg/
> scp orahda@111.111.111.11:/oracle/orahda/product/10.2.0/rdbms/mesg/ulus.msb /usr/lib/oracle/10.2.0.4/client64/rdbms/mesg/
> vi /etc/profile.d/oracle.sh
ORACLE_HOME=/usr/lib/oracle/10.2.0.4/client64; export ORACLE_HOME
> source /etc/profile.d/oracle.sh