Oracle Client 설치

1. Oracle Instant Client RPM 다운

   오라클 인스턴스 클라이언트

• oracle-instantclient-basic-버전.x86_64.rpm
• oracle-instantclient-devel-버전.x86_64.rpm
• oracle-instantclient-sqlplus-버전.x86_64.rpm

2. 설치

yum install -y oracle-instantclient-basic-버전.x86_64.rpm
yum install -y oracle-instantclient-devel-버전.x86_64.rpm
yum install -y oracle-instantclient-sqlplus-버전.x86_64.rpm

3. PATH 지정

vi /etc/bashrc # or /etc/profile

# /etc/bashrc

ORACLE_HOME=/usr/lib/oracle/11.2/client64
TNS_ADMIN=/etc/oracle
CFLAGS=-I/usr/include/oracle/11.2/client64
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
NLS_LANG=KOREAN_KOREA.KO16MSWIN949
PATH=$ORACLE_HOME/bin:$PATH
export TNS_ADMIN LD_LIBRARY_PATH PATH CFLAGS NLS_LANG ORACLE_HOME

4. tnsnames.ora 작성

ORC01=  # 원하는 이름
    (DESCRIPTION = 
        (ADDRESS_LIST = 
            (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = XXXX)) 
        ) 
        (CONNECT_DATA = 
            (SID = "") 
        ) 
    ) 

5. ORACLE 접속

ID/PASSWD@ORC01