http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
select ones matched verion of oracle server. (rpm)
2.
> mkdir /usr/lib/oracle
> cd /usr/lib/oracle
> rpm -Uvh oracle-instantclient-basic-10.2.0.4-1.x86_64.rpm
> rpm -Uvh oracle-instantclient-sqlplus-10.2.0.4-1.x86_64.rpm
> vi /usr/lib/oracle/10.2.0.4/client64/tnsnames.ora
HDA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =IP_ADRESS)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hda)
)
)
> vi /etc/profile.d/oracle.sh
# for Oracle Instant Client
if [ -d /usr/lib/oracle ]
then
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/10.2.0.4/client64/lib/;export LD_LIBRARY_PATH
TNS_ADMIN=/usr/lib/oracle/10.2.0.4/client64; export TNS_ADMIN;
NLS_LANG=AMERICAN_AMERICA.KO16KSC5601;export NLS_LANG;
# PATH=$PATH:/usr/lib/oracle;export PATH;
# SQLPATH=/usr/lib/oracle; export SQLPATH;
fi
> source /etc/profile/oracle.sh
> sqlplus64 DBNAME@HDA
== sqlldr ==
> scp orahda@111.111.111.11:/oracle/orahda/product/10.2.0/bin/sqlldr /usr/bin/
> mkdir /usr/lib/oracle/10.2.0.4/client64/rdbms/mesg/
> scp orahda@111.111.111.11:/oracle/orahda/product/10.2.0/rdbms/mesg/ulus.msb /usr/lib/oracle/10.2.0.4/client64/rdbms/mesg/
> vi /etc/profile.d/oracle.sh
ORACLE_HOME=/usr/lib/oracle/10.2.0.4/client64; export ORACLE_HOME
> source /etc/profile.d/oracle.sh
'Bioinformatics > Informatics' 카테고리의 다른 글
[flex] The Solution to Flex Remoting Over SSL (0) | 2012.12.24 |
---|---|
[blazeds] Blazeds 를 이용하여 자바로 부터 데이터 전달 받는 방법 (0) | 2012.06.13 |
[erwin] SQL 문으로 ERWIN 에서 ERD 그리기 (0) | 2011.07.19 |