Linux Oracle 19c client 설치 - Linux Oracle 19c client seolchi

Oracle Database Database Client Installation Guide, 19c for Linux

E96433-15

Copyright © 2015, 2022, Oracle and/or its affiliates. 

Primary Author: Prakash Jashnani

Contributing Authors: Douglas Williams, Subhash Chandra

Contributors: Jean-Francois Verrier, Neha Avasthy, Kalambhatti Prashanth, Prasad Bagal, Subhranshu Banerjee, Tammy Bednar, Eric Belden, Gavin Bowe, Robert Chang, Darcy Christensen, Kiran Chamala, Jonathan Creighton, Benoit Dageville, Sudip Datta, Jim Erickson, Marcus Fallen, Joseph Francis, Richard Roddy, Allan Graves, Barbara Glover, Aneesh Khandelwal, Joel Kallman, Eugene Karichkin, Jai Krishnani, Sangeeth Kumar, Kevin Jernigan, Christopher Jones, Prasad Kuruvadi Nagaraj, Bryn Llewellyn, Saar Maoz, Sunil Surabhi, Gopal Mulagund, Sue Lee, Rich Long, Barb Lundhild, Rudregowda Mallegowda, Padmanabhan Manavazhi, Mughees Minhas, Krishna Mohan, Matthew McKerley, John McHugh, Gurudas Pai, Satish Panchumarthy , Rajesh Prasad, Rajendra Pingte, Sivaselvam Narayanasamy, Srinivas Poovala, Mohammed Shahnawaz Quadri, Sangeeth Jose, Gurumurthy Ramamurthy, Hema Ramamurthy, Sunil Ravindrachar, Mark Richwine, Dipak Saggi, Trivikrama Samudrala, Pushkar Punit, David Schreiner, Ara Shakian, Mohit Singhal, Dharma Sirnapalli, Akshay Shah, James Spiller, Roy Swonger, Binoy Sukumaran, Kamal Tbeileh, Ravi Thammaiah, Shekhar Vaggu, Peter Wahl, Terri Winters, Sergiusz Wolicki

-테스트베드 OS 정보.

$ hostnamectl
...
Operating System: CentOS Linux 8
Kernel: Linux 4.18.0-348.7.1.el8_5.x86_64
Architecture: x86-64
...

-하단의링크접속후원하는오라클클라이언트버전에 맞춰서 Basic Package (RPM) & SQL*Plus Package (RPM) 파일다운로드.

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

-root 계정으로접속후다운로드한 *.rpm 파일설치.

# yum install -y oracle-instantclient19.15-basic-19.15.0.0.0-1.x86_64.rpm
마지막 메타자료 만료확인 0:24:45 이전인: 2022년 04월 29일 (금) 오후 03시 29분 50초.
종속성이 해결되었습니다.
==================================================================================================================================================
 꾸러미                                            구조                     버전                             레포지터리                      크기
==================================================================================================================================================
설치 중:
 oracle-instantclient19.15-basic                   x86_64                   19.15.0.0.0-1                    @commandline                    51 M

연결 요약
==================================================================================================================================================
설치  1 꾸러미

전체 크기: 51 M
설치된 크기 : 226 M
꾸러미 내려받기중:
연결 확인 실행 중
연결 확인에 성공했습니다.
연결 시험 실행 중
연결 시험에 성공했습니다.
연결 실행 중
  준비 중           :                                                                                                                         1/1 
  설치 중           : oracle-instantclient19.15-basic-19.15.0.0.0-1.x86_64                                                                    1/1 
  스크립트릿 실행 중: oracle-instantclient19.15-basic-19.15.0.0.0-1.x86_64                                                                    1/1 
  확인 중           : oracle-instantclient19.15-basic-19.15.0.0.0-1.x86_64                                                                    1/1 

설치되었습니다:
  oracle-instantclient19.15-basic-19.15.0.0.0-1.x86_64                                                                                            

완료되었습니다!

# yum install -y oracle-instantclient19.15-sqlplus-19.15.0.0.0-1.x86_64.rpm
마지막 메타자료 만료확인 0:25:34 이전인: 2022년 04월 29일 (금) 오후 03시 29분 50초.
종속성이 해결되었습니다.
==================================================================================================================================================
 꾸러미                                             구조                    버전                              레포지터리                     크기
==================================================================================================================================================
설치 중:
 oracle-instantclient19.15-sqlplus                  x86_64                  19.15.0.0.0-1                     @commandline                  687 k

연결 요약
==================================================================================================================================================
설치  1 꾸러미

전체 크기: 687 k
설치된 크기 : 3.1 M
꾸러미 내려받기중:
연결 확인 실행 중
연결 확인에 성공했습니다.
연결 시험 실행 중
연결 시험에 성공했습니다.
연결 실행 중
  준비 중           :                                                                                                                         1/1 
  설치 중           : oracle-instantclient19.15-sqlplus-19.15.0.0.0-1.x86_64                                                                  1/1 
  스크립트릿 실행 중: oracle-instantclient19.15-sqlplus-19.15.0.0.0-1.x86_64                                                                  1/1 
  확인 중           : oracle-instantclient19.15-sqlplus-19.15.0.0.0-1.x86_64                                                                  1/1 

설치되었습니다:
  oracle-instantclient19.15-sqlplus-19.15.0.0.0-1.x86_64                                                                                          

완료되었습니다!

-다운로드한 *.rpm 파일설치간하단의에러발생할경우, libaio 라이브러리설치해야함.

Failed dependencies:libaio is needed by oracle-instantclient19.15-basiclite-19.15.0.0.0-1.x86_64

-libaio 라이브러리 설치 방법.

$ yum install -y libaio

-"/etc/profile.d/oracle.sh" 생성후하단과같이 $ORACLE_HOME, $TNS_ADMIN 설정추가.

 # vi /etc/profile.d/oracle.sh
export ORACLE_HOME=/usr/lib/oracle/19.15/client64
export TNS_ADMIN=/usr/lib/oracle/19.15/client64/bin

-oracle instant client 사용하려는계정의 .bash_profile에하단과같이 $ORACLE_HOME, $TNS_ADMIN, $PATH 설정추가후 .bash_profile 적용.

$ vi ~/.bash_profile
export NLS_LANG=KOREAN_KOREA.AL32UTF8
export ORACLE_HOME=/usr/lib/oracle/19.15/client64
export TNS_ADMIN=/usr/lib/oracle/19.15/client64/bin
export PATH=${PATH}:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib

-oracle instant client에서 oracle server로접속(sqlplus)을위해서 tnsnames.ora 설정.

$ vi $TNS_ADMIN/tnsnames.ora
serviceName =
  (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx))
        (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SID = sid)
        )
 )

-oracle instant client에서 oracle server로접속(sqlplus) 확인.

$ sqlplus id/passwd@serviceName

SQL*Plus: Release 19.0.0.0.0 - Production on 금 4월 29 16:15:19 2022
Version 19.15.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
마지막 성공한 로그인 시간: 금 4월  29 2022 16:14:30 +09:00
다음에 접속됨:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>