oracle instant client 설치하기

1. 다운로드 및 압축 해제
 - /usr/lib/oracle
 - c:\oracle\

2. os에 맞는 path 설정

2-1. linux
# vi /etc/profile
-----------------------------------------------------------------
# for Oracle Instant Client
if [ -d /usr/lib/oracle ]
then
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle;export LD_LIBRARY_PATH
PATH=$PATH:/usr/lib/oracle;export PATH;
NLS_LANG=Korean_Korea.KO16KSC5601;export NLS_LANG;
TNS_ADMIN=/usr/lib/oracle; export TNS_ADMIN;
SQLPATH=/usr/lib/oracle; export SQLPATH;
fi
-----------------------------------------------------------------

2-2. window
- 환경변수에 path 등록
ORACLE_HOME -> instance client 설치 경로
path -> %ORACLE_HOME% 추가
- registry 추가
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOME -> 설치 경로 
NLS_LANG

[출처] 간단한 오라클 클라이언트(instant client) 설치방법[windows]|작성자 하늘아이

 ->  KOREAN_KOREA.KO16MSWIN949

[출처] 간단한 오라클 클라이언트(instant client) 설치방법[windows]|작성자 하늘아이

3. tnsnames.ora 세팅
%oracle_home%/tnsnames.ora
-----------------------------------------------------------------
ORA=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =XXX.XXX.XXX.XXX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora)
)

)