ubuntu/debian Oracle instant Client 설치

우분투 Oracle Client 설치

Oracle Instant Client 설치 http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html 오라클 사이트에서 Instant Client 를 다운 받는다. oracle-instantclient-basic-10.2.0.3-1.i386.rpm oracle-instantclient-devel-10.2.0.3-1.i386.rpm oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm 이렇게 네개를 다운 받았음. root@ubuntu:/usr/local/src# alien -k oracle-instantclient-basic-10.2.0.3-1.i386.rpm root@ubuntu:/usr/local/src# alien -k oracle-instantclient-devel-10.2.0.3-1.i386.rpm root@ubuntu:/usr/local/src# alien -k oracle-instantclient-jdbc-10.2.0.3-1.i386.rpm root@ubuntu:/usr/local/src# alien -k oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm root@ubuntu:/usr/local/src# dpkg -i oracle-instantclient-basic_10.2.0.3-1_i386.deb root@ubuntu:/usr/local/src# dpkg -i oracle-instantclient-devel_10.2.0.3-1_i386.deb root@ubuntu:/usr/local/src# dpkg -i oracle-instantclient-jdbc_10.2.0.3-1_i386.deb root@ubuntu:/usr/local/src# dpkg -i oracle-instantclient-sqlplus_10.2.0.3-1_i386.deb (tnsname 수정) root@ubuntu:/usr/local/src# vi /usr/lib/oracle/10.2.0.3/client/network/admin/tnsnames.ora ORACLE_CLIENT = // 클라이언트 접속명   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = 서버호스트아이피)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = 오라클SID입력)     )   ) LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib:${LD_LIBRARY_PATH} TNS_ADMIN=/usr/lib/oracle/10.2.0.3 export LD_LIBRARY_PATH TNS_ADMIN ▲ 추가 [출처] ubuntu 서버에 Oracle instant Client를 설치 연동방법|작성자 베이더 (한글 처리) .bashrc 에 아래 내용 추가 ORACLE_HOME=/usr/lib/oracle/10.2.0.5/client64 LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.5/client64/lib:${LD_LIBRARY_PATH} TNS_ADMIN=/usr/lib/oracle/10.2.0.5 NLS_LANG=KOREAN_KOREA.UTF8 export ORACLE_HOME NLS_LANG LD_LIBRARY_PATH TNS_ADMIN PATH=$ORACLE_HOME/bin:${PATH}