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


Distrib:
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Info:
http://docs.oracle.com/cd/E11882_01/server.112/e16604/apd.htm

Нужны:

  • instantclient-basic-linux.x64-11.2.0.3.0.zip
  • instantclient-sqlplus-linux.x64-11.2.0.3.0.zip


Archives should be unzipped in 1 catalog
Or you could recieve next error:
SP2-0667: Message file sp1.msb not found


# 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 [email protected]:1521/ora112.localdomain
Connected.


Creating tnsnames.ora file

# 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 [email protected]
Connected.

system -login manager - password