Oracle Linux 8.4 커널 패치 가이드

OS환경 : Oracle Linux 8.4, 8.5 (64bit)

 

DB 환경 : Oracle Database 19.12.0.0

 

방법 : Oracle Linux 8.4 커널 패치 가이드

Oracle Linux 8.4을 8.5로 패치하는 방법을 설명함

현재 Oracle 19c 가 설치되어있는 서버임

 

 

기존 커널 버전 확인

# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 8.4 (Ootpa)
# uname -a
Linux ORACLE19 4.14.35-1818.3.3.el7uek.x86_64 #2 SMP Mon Sep 24 14:45:01 PDT 2018 x86_64 x86_64 x86_64 GNU/Linux

 

 

db 및 리스너 종료

# su - oracle
Last login: Mon Dec  6 13:27:59 KST 2021 on pts/0
 
$ sqlplus / as sysdba
 
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 6 13:33:31 2021
Version 19.12.0.0.0
 
Copyright (c) 1982, 2020, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
 
$ lsnrctl stop
 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-DEC-2021 13:34:00
 
Copyright (c) 1991, 2021, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLE19)(PORT=1521)))
The command completed successfully

 

 

yum update 진행(인터넷이 가능한 환경이어야함)

시간이 조금 걸림

# yum update -y
Loaded plugins: langpacks, ulninfo                                                                                  ]  0.0 B/s |    0 B  --:--:-- ETA 
(1/5): ol8_UEKR5/x86_64/updateinfo                                                                                                    | 186 kB  00:00:00     
(2/5): ol8_latest/x86_64/group_gz                                                                                                     | 136 kB  00:00:00     
(3/5): ol8_latest/x86_64/updateinfo                                                                                                                   
.
.
Complete!

 

 

패치후 커널 버전 확인

# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 8.5 (Ootpa)
# uname -a
Linux ORACLE19 4.14.35-1818.3.3.el7uek.x86_64 #2 SMP Mon Sep 24 14:45:01 PDT 2018 x86_64 x86_64 x86_64 GNU/Linux

정상적으로 커널 버전이 8.5로 패치됨

 

 

db relink

$ export ORACLE_HOME=/app/oracle/product/19c;
$ cd $ORACLE_HOME/bin/
$ ./relink all

 

 

리스너 및 db 기동

$ lsnrctl start
 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-DEC-2021 14:03:11
 
Copyright (c) 1991, 2021, Oracle.  All rights reserved.
 
Starting /app/oracle/product/19c/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /app/oracle/product/19c/network/admin/listener.ora
Log messages written to /app/oracle/diag/tnslsnr/ORACLE19/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE19)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLE19)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                06-DEC-2021 14:03:11
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /app/oracle/product/19c/network/admin/listener.ora
Listener Log File         /app/oracle/diag/tnslsnr/ORACLE19/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE19)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
 
$ sqlplus / as sysdba
 
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 6 14:03:19 2021
Version 19.12.0.0.0
 
Copyright (c) 1982, 2020, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORACLE instance started.
 
Total System Global Area 1157627160 bytes
Fixed Size            8895768 bytes
Variable Size          872415232 bytes
Database Buffers      268435456 bytes
Redo Buffers            7880704 bytes
Database mounted.
Database opened.

os 커널 패치 작업 완료

db가 rac 인 경우 추가 작업이 더 필요함

 

 

참조 : https://almost-native.tistory.com/384

https://positivemh.tistory.com/788