ubuntu/debian Oracle instant Client 설치

우분투 Oracle Client 설치

Oracle Instant Client 설치

오라클 사이트에서 Instant Client 를 다운 받는다.
oracle-instantclient-basic-10.2.0.3-1.i386.rpm
oracle-instantclient-devel-10.2.0.3-1.i386.rpm
oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

이렇게 네개를 다운 받았음.

root@ubuntu:/usr/local/src# alien -k oracle-instantclient-basic-10.2.0.3-1.i386.rpm
root@ubuntu:/usr/local/src# alien -k oracle-instantclient-devel-10.2.0.3-1.i386.rpm
root@ubuntu:/usr/local/src# alien -k oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm
root@ubuntu:/usr/local/src# alien -k oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

root@ubuntu:/usr/local/src# dpkg -i oracle-instantclient-basic_10.2.0.3-1_i386.deb
root@ubuntu:/usr/local/src# dpkg -i oracle-instantclient-devel_10.2.0.3-1_i386.deb
root@ubuntu:/usr/local/src# dpkg -i oracle-instantclient-jdbc_10.2.0.3-1_i386.deb
root@ubuntu:/usr/local/src# dpkg -i oracle-instantclient-sqlplus_10.2.0.3-1_i386.deb

(tnsname 수정)
root@ubuntu:/usr/local/src# vi /usr/lib/oracle/10.2.0.3/client/network/admin/tnsnames.ora
ORACLE_CLIENT = // 클라이언트 접속명
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 서버호스트아이피)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = 오라클SID입력)
    )
  )

LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib:${LD_LIBRARY_PATH}
TNS_ADMIN=/usr/lib/oracle/10.2.0.3
export LD_LIBRARY_PATH TNS_ADMIN

▲ 추가

(한글 처리)
.bashrc 에 아래 내용 추가
ORACLE_HOME=/usr/lib/oracle/10.2.0.5/client64
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.5/client64/lib:${LD_LIBRARY_PATH}
TNS_ADMIN=/usr/lib/oracle/10.2.0.5
NLS_LANG=KOREAN_KOREA.UTF8
export ORACLE_HOME NLS_LANG LD_LIBRARY_PATH TNS_ADMIN
PATH=$ORACLE_HOME/bin:${PATH}

댓글

이 블로그의 인기 게시물

ubuntu에서 samba로 파일 공유하기

화이트해커를 위한 암호와 해킹

Shell Program(1) 변수, 상수