Oracle

Oracle 19c 설치 (centos7)

ksk04 2024. 9. 15. 18:50

ORACLE 19c 설치

  • 필수 패키지 설치하기
 yum install -y oracle-database-preinstall-19c
  • or
yum install -y bc    
yum install -y binutils
yum install -y compat-libcap1
yum install -y compat-libstdc++-33
#yum install -y dtrace-modules
#yum install -y dtrace-modules-headers
#yum install -y dtrace-modules-provider-headers
yum install -y dtrace-utils
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio
yum install -y libaio-devel
yum install -y libdtrace-ctf-devel
yum install -y libXrender
yum install -y libXrender-devel
yum install -y libX11
yum install -y libXau
yum install -y libXi
yum install -y libXtst
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc++
yum install -y libstdc++-devel
yum install -y libxcb
yum install -y make
yum install -y net-tools # Clusterware
yum install -y nfs-utils # ACFS
yum install -y python # ACFS
yum install -y python-configshell # ACFS
yum install -y python-rtslib # ACFS
yum install -y python-six # ACFS
yum install -y targetcli # ACFS
yum install -y smartmontools
yum install -y sysstat
  • yum 레포지토리 업데이트
yum update -y
  • 그륩 추가
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
#groupadd -g 54324 backupdba
#groupadd -g 54325 dgdba
#groupadd -g 54326 kmdba
#groupadd -g 54327 asmdba
#groupadd -g 54328 asmoper
#groupadd -g 54329 asmadmin
#groupadd -g 54330 racdba

useradd -u 54321 -g oinstall -G dba,oper oracle
  • root 에서 oracle 유저 passwd 변경
passwd oracle
  • Selinux 보안모듈 비활성화
setenforce 0
  • 방화벽 비활성화
systemctl stop firewalld
systemctl disable firewalld
  • ORACLE_HOME & ORACLE_BASE 경로 생성
mkdir -p /u01/app/oracle/product/19/db_1 -- 이경로에 패키지 올림.
chown -R oracle:oinstall /u01
chmod -R 775 /u01
  • oracle 유저에서 환경변수 설정
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=ora_db
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19/db_1
export ORACLE_SID=orcl
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
  • 디스플레이 관련 에러
[root@localhost ~]# xhost +
xhost:  unable to open display ""
[root@localhost ~]# export DISPLAY=:0
[root@localhost ~]# xhost +
access control disabled, clients can connect from any host
[root@localhost ~]#

# oracle 유저에서
 export DISPLAY=:0
  • oracle_home 에서 압출풀고 설치 진행
cd $ORACLE_HOME
unzip LINUX.X64_193000_db_home.zip
./runInstaller

  • 확인
[oracle@ora_db db_1]$ sqlplus 'sys as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 15 02:43:30 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>