목차

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. http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

압축해제

  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.

사용자명 입력: