instantclient 설치하기 (window)

DOWNLOAD :http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

 

1. instantclient-basic  , instantclient-SQL*Plus , SDK 등 다운로드

 

2. 적당한 위에 압축 풀기

  C:\instantclient_10_2

 

3. tnsnames.ora 생성

  C:\instantclient_10_2\network\ 에 생성.

 

ORADB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 211.42.87.150)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = NONGUP)
    )
  )

 

4. 환경변수 설정

* PATH  : C:\instantclient_10_2 추가.

* ORACLE_HOME : C:\instantclient_10_2 신규 추가.

* TNS_ADMIN : C:\instantclient_10_2\network 신규추가.

 

5. 레지스트리 추가

  

  

   KOREAN_KOREA.KO16KSC5601

 

   * 서버쪽 NLS_LANG 과 같게 셋팅.