내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.6, 7.9 (64bit)
DB 환경 : Oracle Database 19.11.0.0
방법 : Oracle Linux 7.6 커널 패치 가이드
Oracle Linux 7.6을 7.9로 패치하는 방법을 설명함
현재 Oracle 19c 가 설치되어있는 서버임
기존 커널 버전 확인
|
1
2
3
4
|
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.6 (Maipo)
# 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 및 리스너 종료
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
# 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.11.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.11.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.11.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 진행(인터넷이 가능한 환경이어야함)
시간이 조금 걸림
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# yum update -y
Loaded plugins: langpacks, ulninfo
ol7_UEKR5 | 3.0 kB 00:00:00
ol7_latest | 3.6 kB 00:00:00
(2/5): ol7_UEKR5/x86_64/primary_db 0% [ ] 0.0 B/s | 0 B --:--:-- ETA
(1/5): ol7_UEKR5/x86_64/updateinfo | 186 kB 00:00:00
(2/5): ol7_latest/x86_64/group_gz | 136 kB 00:00:00
(3/5): ol7_latest/x86_64/updateinfo | 3.4 MB 00:00:00
.
.
xorg-x11-server-common.x86_64 0:1.20.4-16.el7_9 yum.noarch 0:3.4.3-168.0.3.el7
zlib.x86_64 0:1.2.7-19.el7_9 zlib-devel.x86_64 0:1.2.7-19.el7_9
Replaced:
iwl7265-firmware.noarch 999:22.0.7.0-999.1.el7
Complete!
|
패치후 커널 버전 확인
|
1
2
3
4
|
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)
# 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
|
정상적으로 커널 버전이 7.9로 패치됨
db relink
|
1
2
3
|
$ export ORACLE_HOME=/app/oracle/product/19c;
$ cd $ORACLE_HOME/bin/
$ ./relink all
|
리스너 및 db 기동
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
$ 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.11.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 인 경우 추가 작업이 더 필요함
'Linux, Unix > Install' 카테고리의 다른 글
| Oracle Linux 8.4 설치 가이드(VirtualBox) (0) | 2024.03.21 |
|---|---|
| Oracle Linux 8.4 커널 패치 가이드 (0) | 2021.12.06 |
| Oracle Linux 8.4 설치 가이드 (0) | 2021.10.14 |
| Oracle Linux 6.8 설치 가이드 (0) | 2020.12.17 |
| Oracle Linux 7.6에 FreeTDS 설치 가이드 (0) | 2020.07.20 |