Oracle cloud 콘솔을 통해 PaaS상품인 DBCS에서 RAC를 구성 후 패치를 진행하도록 하겠습니다.
패치셋은 OCI에서 진행하는 패치셋만 콘솔을 통해 적용 할 수 있으며 원하는 패치셋을 On-prem와 같이 패치를 적용 할 수있을지는 다음 테스트를 통해 알아보도록 하겠습니다.
DBCS RAC생성
■ DB시스템 구성 항목의 총 노드 수를 2로 설정
■ subnet 22port open
노드간 통신
■ creating
2 node, 1 database
Patch
Patch 순서
DB System precheck -> DB System patch -> DB precheck -> DB patch
■ Grid 패치
precheck (OCW패치는 GRID 홈, ORACLE 홈 두 곳 모두 적용합니다. 해당 패치가 다른 경우 버그 픽스된 리스트가 상이하여 GRID/ORACLE 버전을 맞춰주는 것을 권장합니다.)
OCW -> GRID Patch는 여러 구성 요소가 포함되어 있습니다. 이들은 Clusterware, Automatic Storage Management, ASM Cluster File System, Java Virtual Machine 등과 관련이 있습니다. Clusterware용 패치는 OCW이고 클러스터 파일 시스템용 패치는 ACFS입니다.
■ 현재 패치셋 확인
[root@jhtest1 ~]# dbcli describe-component
System Version
---------------
22.1.1.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
GI 19.13.0.0.0 19.14.0.0
DB 19.13.0.0.0 19.14.0.0
## job list 확인
[root@jhtest1 ~]# dbcli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
5a334b6a-0dc3-4543-aa67-30b7d1f6577c Provisioning service creation Monday, February 28, 2022, 00:07:54 UTC Success
16a9f2bc-c041-4df7-a615-fab9f55d0e22 SSH keys update Monday, February 28, 2022, 01:02:06 UTC Success
02c32b4b-ae8f-4772-8e49-be2099ad326c SSH key delete Monday, February 28, 2022, 01:03:45 UTC Success
bc27fa7e-0bf5-4062-bcd2-249cc604cc76 SSH key delete Monday, February 28, 2022, 01:03:51 UTC Success
cd6a758e-c57d-4537-9df2-cd958836c734 Resource Principle certification generation/rotation Monday, February 28, 2022, 01:04:13 UTC Success
7b181772-9dee-4c70-8a62-1a601d37cbc9 Resource Principle certification generation/rotation Monday, February 28, 2022, 01:04:30 UTC Success
20707545-7cbf-4e4a-9458-a308fc048a24 Authentication key update for DCS_ADMIN Monday, February 28, 2022, 01:06:44 UTC Success
4b28a259-62e1-4a2c-9f38-18c00c3fa71d Authentication key update for DCS_ADMIN Monday, February 28, 2022, 01:07:35 UTC Success
91f5eb5d-40ef-4fa4-b2dd-0b0cc722a478 Infra upgrade Monday, February 28, 2022, 01:07:43 UTC Success
6cdec043-09df-4cdd-bcde-725d64f04853 Infra upgrade Monday, February 28, 2022, 01:07:46 UTC Success
c33dbf13-5649-42a3-925a-408326f71d9c Manage AHF telemetry Monday, February 28, 2022, 01:11:32 UTC Success
6eb945fb-7fe5-4cac-8dae-668070774218 Manage AHF telemetry Monday, February 28, 2022, 01:11:54 UTC Success
f19a5ddb-dc7b-44c7-86a5-17a9c9b90bd1 Server Patching Prechecks Monday, February 28, 2022, 04:54:19 UTC Running
## job 상태 확인
[root@jhtest1 ~]# dbcli describe-job -i f19a5ddb-dc7b-44c7-86a5-17a9c9b90bd1
Job details
----------------------------------------------------------------
ID: f19a5ddb-dc7b-44c7-86a5-17a9c9b90bd1
Description: Server Patching Prechecks
Status: Running
Created: February 28, 2022 4:54:19 AM UTC
Progress: 33%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching February 28, 2022 4:54:19 AM UTC February 28, 2022 4:57:19 AM UTC Success
Server Patching February 28, 2022 4:57:19 AM UTC February 28, 2022 4:57:19 AM UTC Running
[root@jhtest1 ~]# dbcli describe-job -i f19a5ddb-dc7b-44c7-86a5-17a9c9b90bd1
Job details
----------------------------------------------------------------
ID: f19a5ddb-dc7b-44c7-86a5-17a9c9b90bd1
Description: Server Patching Prechecks
Status: Success
Created: February 28, 2022 4:54:19 AM UTC
Progress: 100%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching February 28, 2022 4:54:19 AM UTC February 28, 2022 4:57:19 AM UTC Success
Server Patching February 28, 2022 4:57:19 AM UTC February 28, 2022 5:06:08 AM UTC Success■ Patch 적용
[root@jhtest1 ~]# dbcli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
5a334b6a-0dc3-4543-aa67-30b7d1f6577c Provisioning service creation Monday, February 28, 2022, 00:07:54 UTC Success
16a9f2bc-c041-4df7-a615-fab9f55d0e22 SSH keys update Monday, February 28, 2022, 01:02:06 UTC Success
02c32b4b-ae8f-4772-8e49-be2099ad326c SSH key delete Monday, February 28, 2022, 01:03:45 UTC Success
bc27fa7e-0bf5-4062-bcd2-249cc604cc76 SSH key delete Monday, February 28, 2022, 01:03:51 UTC Success
cd6a758e-c57d-4537-9df2-cd958836c734 Resource Principle certification generation/rotation Monday, February 28, 2022, 01:04:13 UTC Success
7b181772-9dee-4c70-8a62-1a601d37cbc9 Resource Principle certification generation/rotation Monday, February 28, 2022, 01:04:30 UTC Success
20707545-7cbf-4e4a-9458-a308fc048a24 Authentication key update for DCS_ADMIN Monday, February 28, 2022, 01:06:44 UTC Success
4b28a259-62e1-4a2c-9f38-18c00c3fa71d Authentication key update for DCS_ADMIN Monday, February 28, 2022, 01:07:35 UTC Success
91f5eb5d-40ef-4fa4-b2dd-0b0cc722a478 Infra upgrade Monday, February 28, 2022, 01:07:43 UTC Success
6cdec043-09df-4cdd-bcde-725d64f04853 Infra upgrade Monday, February 28, 2022, 01:07:46 UTC Success
c33dbf13-5649-42a3-925a-408326f71d9c Manage AHF telemetry Monday, February 28, 2022, 01:11:32 UTC Success
6eb945fb-7fe5-4cac-8dae-668070774218 Manage AHF telemetry Monday, February 28, 2022, 01:11:54 UTC Success
f19a5ddb-dc7b-44c7-86a5-17a9c9b90bd1 Server Patching Prechecks Monday, February 28, 2022, 04:54:19 UTC Success
c5cc2b8d-38ea-4acd-bb94-a8131ab14b5b Server Patching Monday, February 28, 2022, 05:10:35 UTC Running
[root@jhtest1 ~]# dbcli describe-job -i c5cc2b8d-38ea-4acd-bb94-a8131ab14b5b
Job details
----------------------------------------------------------------
ID: c5cc2b8d-38ea-4acd-bb94-a8131ab14b5b
Description: Server Patching
Status: Running
Created: February 28, 2022 5:10:35 AM UTC
Progress: 0%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching February 28, 2022 5:10:36 AM UTC February 28, 2022 5:10:36 AM UTC Running
[root@jhtest1 ~]# dbcli describe-job -i c5cc2b8d-38ea-4acd-bb94-a8131ab14b5b
Job details
----------------------------------------------------------------
ID: c5cc2b8d-38ea-4acd-bb94-a8131ab14b5b
Description: Server Patching
Status: Running
Created: February 28, 2022 5:10:35 AM UTC
Progress: 28%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching February 28, 2022 5:10:36 AM UTC February 28, 2022 5:12:58 AM UTC Success
Server Patching February 28, 2022 5:12:58 AM UTC February 28, 2022 5:12:58 AM UTC Running■ DB System Patch 완료
■ DB Precheck
■ patch 적용
[root@jhtest1 ~]# dbcli describe-job -i ed7005be-43a7-4e34-8a85-950944cf29aa
Job details
----------------------------------------------------------------
ID: ed7005be-43a7-4e34-8a85-950944cf29aa
Description: DBHome Patching: Home ID is c0a9f3af-b99a-4c53-87a5-c1f7e7f37de0
Status: Success
Created: February 28, 2022 7:57:38 AM UTC
Progress: 100%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for DBHome patching February 28, 2022 7:57:39 AM UTC February 28, 2022 8:00:30 AM UTC Success
DBHome patching February 28, 2022 8:00:30 AM UTC February 28, 2022 9:33:40 AM UTC Success
Post-operations for DBHome patching February 28, 2022 9:33:40 AM UTC February 28, 2022 9:35:35 AM UTC Success
■ 패치 완료
[root@jhtest1 ~]# dbcli describe-component
System Version
---------------
19.14.0.0.220118
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
GI 19.14.0.0.0 up-to-date
DB 19.14.0.0.0 up-to-date'Cloud > OCI(Oracle Cloud Infrastructure)' 카테고리의 다른 글
| [OCI - ATP to Oracle DBLink] (0) | 2022.12.01 |
|---|---|
| [OCI - ATP Database 접속 방법] (0) | 2022.12.01 |
| [OCI - SR(Service Request) manual] (0) | 2022.02.26 |
| [OCI - DBCS autobackup Email 얼롯팅 설정] (0) | 2022.02.26 |
| [OCI DBCS Metrics 설정] (0) | 2022.01.20 |