oracle 21c 설치(rhel8)

현스·2025년 2월 20일

ORACLE 설치 script

목록 보기

8/17

https://www.oracle.com/database/technologies/oracle21c-linux-downloads.html

설치 파일 다운로드

rhel8_21c_single
redhat 8.4 19c EE 설치

아이피 주소 설정
CMD 창에 ping 날려보기

192.168.7.232_rhel8_21c_single_jhs

설치파일은 아래 가지 파일을 이용함

DB : LINUX.X64_213000_db_home.zip
OPatch : p6880880_210000_Linux-x86-64.zip(12.2.0.1.27)
Patch 37350281: DATABASE RELEASE UPDATE 21.17.0.0.0

oracd 에 업로드 할 rpm
oracle-database-ee-21c-1.0-1.ol8.x86_64.rpm

1. 리눅스 세팅 및 엔진 설치

#버전확인
uname -a
cat /etc/system-release

#용량확인
df -h

#hostname 확인
hostname


#host 파일 설정 

vi /etc/hosts

#오라클 유저 존재유무 와 생성

[확인]
 grep -E "dba|54321" /etc/group
 grep -E "oracle|54321" /etc/passwd
[생성]
groupadd -g 54321  dba
useradd -g dba -u 54321 oracle

#user패스워드 설정 
passwd oracle

일단 oracle로 하고 고객한테 전달

#방화벽 체크
[확인]
systemcrl status firewalld
[해제]
systemctl stop firewalld
systemctl disable firewalld


#SElinux 비활성화
vi /etc/selinux/config

disabled 

[확인]
getenforce
-> diabled 가 아니면 reboot

#kernel

vi /etc/sysctl.conf

#getconf PAGE_SIZE << page size 구하는 방법
#kernel.shmall: Physical Size/PAGE_SIZE
#kernel.shmmax: 1/2 of Physical Size or more 55G (55*1024*1024*1024)

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

#변경 적용
   /sbin/sysctl -p

#모든정보 표시
   /sbin/sysctl -a

#리소스 설정

vi /etc/security/limits.conf

[값]
oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
oracle   hard   memlock    134217728
oracle   soft   memlock    134217728
oracle   soft   data    unlimited
oracle   hard   data    unlimited

#YUM 실행

dnf update

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' bc binutils gcc-c++ compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make smartmontools sysstat policycoreutils policycoreutils-python xorg-x11-utils xorg-x11-xauth


dnf install -y libnsl 
dnf install -y libnsl.i686 
dnf install -y libnsl2 
dnf install -y libnsl2.i686 
dnf -y groupinstall 'Development Tools'
dnf install bc -y
dnf install binutils -y
dnf install compat-openssl10 -y
dnf install compat-libcap1 -y
dnf install compat-libstdc++ -y
dnf install elfutils-libelf -y
dnf install elfutils-libelf-devel -y
dnf install fontconfig -y
dnf install glibc -y
dnf install glibc-devel -y
dnf install ksh -y
dnf install libaio -y
dnf install libaio-devel -y
dnf install libasan -y
dnf install liblsan -y
dnf install libX11 -y
dnf install libXau -y
dnf install libXi -y
dnf install libXrender -y
dnf install libXtst -y
dnf install libxcrypt-compat -y
dnf install libXrender-devel -y
dnf install libgcc -y
dnf install libibverbs -y
dnf install libnsl -y
dnf install librdmacm -y
dnf install libstdc++ -y
dnf install libxcb -y
dnf install libvirt-libs -y
dnf install make -y
dnf install policycoreutils -y
dnf install policycoreutils-python-utils -y
dnf install smartmontools -y
dnf  install sysstat -y
dnf install libstdc++-devel -y
dnf install -y gcc
dnf install -y unixODBC
dnf install -y glibc-headers
dnf install -y ipmiutil
dnf install -y libnsl2
dnf install -y libnsl2-devel
dnf install -y net-tools
dnf install -y nfs-utils 




#환경변수 설정 (SID , ORACLE_HOME 잘보기)

vi .bash_profile

[환경변수]
export PATH
export PS1="[\u@\h \W]$ "
umask 022
export EDITOR=vi
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/21c/db_home
export ORACLE_SID=orcl
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/lib
export PATH=/usr/sbin:/usr/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export LANG=C



#동기화
. ~/.bash_profile

#디렉토리 생성 및 권한부여 

[root]
mkdir /oracd
mkdir /oracle
mkdir /oradata
mkdir /oraarch
chown oracle:dba /oracle 
chmod 775 /oracle 
chown -R oracle:dba /ora*


[oracle]
su - oracle
mkdir -pv $ORACLE_HOME
chmod -R 775 /oracle/app

#설치파일 unzip

unzip LINUX.X64_213000_db_home.zip -d $ORACLE_HOME
export DISPLAY={ip}:0.0

./runinstaller

안되면
oracle로 접속

엔진설치

2. PATCH

opatch 적용

opatch version

mv OPatch OPatch.OLD

unzip 6880

opatch verison

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracd/37350281

$ORACLE_HOME/OPatch/opatch apply

$ORACLE_HOME/OPatch/opatch lspatches

$ORACLE_HOME/OPatch/opatch lsinventory