오라클 DB - 오라클 instance client 설치

* 설치 과정
step 1. 오라클 인스턴스 클라이언트 설치
step 2. 접속 환경 설정
step 3. 접속 테스트

 

step 1. 오라클 인스턴스 클라이언트 설치

 

① 설치할 오라클 인스턴스 클라이언트는 오라클 한국어 사이트인 https://www.oracle.com/kr/index.ht
ml 에서 oracle-instantclient19.5-basic-19.5.0.0.0-1.x86_64.rpm 와 oracle-instantclient19.5-devel-
19.5.0.0.0-1.x86_64.rpm 두 개의 파일을 다운 받는다. 

 

② /usr/lib/oracle/12.2을 ORACLE_BASE 디렉토리로 설치된다. 
# rpm -Uvh oracle-instantclient19.5-basic-19.5.0.0.0-1.x86_64.rpm
준비 중... ########################################### [100%]
 1:oracle-instantclient11.########################################### [100%]
# rpm -Uvh oracle-instantclient19.5-sqlplus-19.5.0.0.0-1.x86_64.rpm
준비 중... ########################################### [100%]
 1:oracle-instantclient11.########################################### [100%]

 

③ sqlnet.ora 파일과 tnsnames.ora 파일을 생성한다. 

# mkdir -p /usr/lib/oracle/network/admin/ 

 

# vi /usr/lib/oracle/network/admin/sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES)

 

# vi /usr/lib/oracle/network/admin/tnsnames.ora

oracle =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.12.12) (port = 1521))
 (CONNECT_DATA = (SID = DB12))
 )

 

step 2. 접속 환경 설정
① 각 사용자의 .bash_profile에 다음을 추가한다.
cat ~/.bach_profile
.............
# oracle install

export TNS_ADMIN=/usr/lib/oracle/network/admin
export LD_LIBRARY_PATH=/usr/lib/oracle/19.5/client64/lib
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
 (또는 AMERICAN_AMERICA.KO16MSWIN949)

 

② 또는 동일한 설정을 /etc/profile에 설정할 수도 있다.
 모든 리눅스 계정에서 오라클 접속 가능하다.

cf.
오라클 서버 시스템에서 일반 OS 계정에 오라클 접속을 위한 환경 변수는 아래와 같다.
export ORACLE_HOME=/app/ora19c/19c
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_SID=DB19
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME:/usr/bin:.

 

step 3. 접속 테스트
① 접속을 확인한다.
# sqlplus 계정/패스워드@TNS명

ex) sqlplus sys/zaqxsw123@oracle as sysdba