목차

Oracle Database Instant Client Installation

사전작업

  1. ubuntu 16.04 설치한다.
    $ lsb_release -a
    No LSB modules are available.
    Distributor ID:	Ubuntu
    Description:	Ubuntu 16.04.2 LTS
    Release:	16.04
    Codename:	xenial
  2. 기본 패키지를 설치한다.
    # apt-get install unzip libaio1 

다운로드

압축해제

  1. unzip 파일이름
    unzip instantclient-basic-linux.x64-11.2.0.4.0.zip 
    unzip instantclient-jdbc-linux.x64-11.2.0.4.0.zip 
    unzip instantclient-odbc-linux.x64-11.2.0.4.0.zip 
    unzip instantclient-sdk-linux.x64-11.2.0.4.0.zip 
    unzip instantclient-sqlplus-linux.x64-11.2.0.4.0.zip 
    unzip instantclient-tools-linux.x64-11.2.0.4.0.zip 
  2. 압축해제한 디렉토리를 이동한다.
    # mv instantclient_11_2/ /usr/local/

환경변수 설정

  1. vi ~/.bashrc
    #!/bin/sh
    #
    # starlits at gmail.com 
    # adminschool.net
    # 
    
    export DYLD_LIBRARY_PATH="/usr/local/instantclient_11_2"
    export TNS_ADMIN="/usr/local/instantclient_11_2"
    export ORACLE_HOME="/usr/local/instantclient_11_2"
    export OCI_LIB="/usr/local/instantclient_11_2"
    export OCI_INCLUDE_DIR="/usr/local/instantclient_11_2/sdk/include"
    # export NLS_LANG=KOREAN_KOREA.KO16MSWIN949
    # export NLS_LANG=KOREAN_KOREA.KO16KSC5601
    export NLS_LANG=KOREAN_KOREA.UTF8
    
    export PATH=$DYLD_LIBRARY_PATH:$PATH

ldconfig 설정

  1. ld.so.config 설정파일에 oracle.conf 를 만든다.
    # echo "/usr/local/instantclient_11_2/" > /etc/ld.so.conf.d/oracle.conf
  2. ldconfig 명령으로 적용한다.
    ldconfig

테스트

  1. sqlplus 를 실행해 본다.
    $ sqlplus 
    
    SQL*Plus: Release 11.2.0.4.0 Production on 월 5월 29 14:46:29 2017
    
    Copyright (c) 1982, 2013, Oracle.  All rights reserved.
    
    사용자명 입력: