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) 파일다운로드.

• //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>