Solaris용 Oracle Instant Client 설치

Oracle Instant Client는 오라클 10g에서 새롭게 선 보이는 배포버전으로 오라클 OCI 라이브러리와 SDK, SQL*Plus, JDBC드라이버만을 지원해준다.

Solaris용 Oracle Instant Client 를 아래 주소에서 다운 받는다.

Instant Client Package - Basic
Instant Client Package - JDBC Supplement
Instant Client Package - SQL*Plus
Instant Client Package - SDK

http://www.oracle.com/technology/global/kr/tech/oci/instantclient/instantclient.html

# unzip instantclient-basic-solaris32-10.2.0.2-20060303.zip
# unzip instantclient-jdbc-solaris32-10.2.0.2-20060303.zip
# unzip instantclient-sdk-solaris32-10.2.0.2-20060303.zip
# unzip instantclient-sqlplus-solaris32-10.2.0.2-20060303.zip
# cd instantclient_10_2
# mkdir /usr/lib/oracle
# mv * /usr/lib/oracle/
# 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


# vi /usr/lib/oracle/tnsnames.ora

사용자 환경에 맞게 수정

ORA9 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 211.XXX.XXX.XXX)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora9)
    )
  )

로그아웃 후 재접속. 테스트

# sqlplus oracle/qwer@ora9
SQL*Plus: Release 10.2.0.2.0 - Production on 화 11월 21 16:47:39 2006
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

다음에 접속됨:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL>