dbms:oracle:admin:instantclient

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- dbms:oracle:admin:instantclient [2017/05/29 14:39]
starlits 만듦
+++ dbms:oracle:admin:instantclient [2018/08/25 18:42] (현재)
starlits [압축해제]
@@ 줄 13: / 줄 13: @@
 # apt-get install unzip libaio1
 </code>
+===== 다운로드 =====
+  - http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
+===== 압축해제 =====
+  - unzip 파일이름 <code>
+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
+</code>
+  - 압축해제한 디렉토리를 이동한다. <code>
+# mv instantclient_11_2/ /usr/local/
+</code>
+===== 환경변수 설정 =====
+  - vi ~/.bashrc <code>
+#!/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
+</code>
+===== ldconfig 설정 =====
+  - ld.so.config 설정파일에 oracle.conf 를 만든다. <code>
+# echo "/usr/local/instantclient_11_2/" > /etc/ld.so.conf.d/oracle.conf
+</code>
+  - ldconfig 명령으로 적용한다. <code>
+ldconfig
+</code>
+===== 테스트 =====
+   - sqlplus 를 실행해 본다. <code>
+$ 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.
+사용자명 입력:
+</code>

dbms/oracle/admin/instantclient.1496036363.txt.gz · 마지막으로 수정됨: 2017/05/29 14:39 저자 starlits