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>
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>