ALBERT SITE

Oracle Client 설치(Centos)

Posted by Albert 532Day 17Hour 52Min 50Sec ago [2023-11-04]

1. 우선 설치파일 다운로드

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

에 접속하여 client 설치 파일 다운로드

========================================

oracle-instantclient19.21-basic-19.21.0.0.0-1.x86_64.rpm

oracle-instantclient19.21-sqlplus-19.21.0.0.0-1.x86_64.rpm

oracle-instantclient19.21-devel-19.21.0.0.0-1.x86_64.rpm

=========================================

2. rpm 설치

rpm -ivh oracle-instantclient19.21-basic-19.21.0.0.0-1.x86_64.rpm

rpm -ivh oracle-instantclient19.21-sqlplus-19.21.0.0.0-1.x86_64.rpm

rpm -ivh oracle-instantclient19.21-devel-19.21.0.0.0-1.x86_64.rpm

3. oracle_home 등록

1) vi /etc/bashrc

2) 하단에 관련 설정 내용 추가

export ORACLE_HOME=/usr/lib/oracle/19.21/client64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG=AMERICAN_AMERICA.UTF8

3) source /etc/bashrc

4) echo $ORACLE_HOME

4. sqlplus로 접속확인

sqlplus visionboy/dbpassword@ip/sid

끝

LIST