在这个博客中，我描述了从19.9到19.11的ODA X8补丁
-
p32790643_1911000_Linux-x86-64.zip:ODACLI/DCS堆栈的Oracle数据库设备服务器修补程序
-
p30403673_1911000_Linux-x86-64.zip：用于ODACLI/DCS堆栈的Oracle数据库设备GI克隆
-
p30403662_1911000_Linux-x86-64.zip：用于ODACLI/DCS堆栈的Oracle数据库设备RDBMS克隆19.11.0.0.210420
修补Oracle数据库设备服务器
在开始该过程之前，我们首先使用odabr（ODA（Oracle数据库设备）：odabr系统备份/恢复实用程序（Doc ID 2466177.1））对系统进行备份
下载最新版本后，我们将安装odabr
[root@oda-prod software]# rpm -ivh odabr-2.0.1-70.noarch.rpm
warning: odabr-2.0.1-70.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 939112d6: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:odabr-2.0.1-70 ################################# [100%]
odabr-2.0.1.70 has been installed on /opt/odabr succesfully!
[root@oda-prod software]#
我们可以验证实际上没有快照
[root@oda-prod software]# /opt/odabr/odabr infosnap
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
odabr - ODA node Backup Restore - Version: 2.0.1-70
Copyright 2013, 2021, Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
LVM snap name Status COW Size Data%
------------- ---------- ---------- ------
WARNING: 2022-08-30 09:07:58: LVM snapshot for 'root' does not exist
WARNING: 2022-08-30 09:07:58: LVM snapshot for 'opt' does not exist
WARNING: 2022-08-30 09:07:58: LVM snapshot for 'u01' does not exist
让我们使用odabr进行备份
[root@oda-prod software]# /opt/odabr/odabr backup -snap -rsize 15 -usize 90 -osize 60
INFO: 2022-08-30 09:08:51: Please check the logfile '/opt/odabr/out/log/odabr_35684.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
odabr - ODA node Backup Restore - Version: 2.0.1-70
Copyright 2013, 2021, Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2022-08-30 09:08:51: Checking superuser
INFO: 2022-08-30 09:08:51: Checking Bare Metal
INFO: 2022-08-30 09:08:51: Removing existing LVM snapshots
WARNING: 2022-08-30 09:08:51: LVM snapshot for 'opt' does not exist
WARNING: 2022-08-30 09:08:51: LVM snapshot for 'u01' does not exist
WARNING: 2022-08-30 09:08:51: LVM snapshot for 'root' does not exist
INFO: 2022-08-30 09:08:51: Checking current OS version
INFO: 2022-08-30 09:08:51: Checking LVM restore backgroud process
INFO: 2022-08-30 09:08:51: Checking LVM size
INFO: 2022-08-30 09:08:51: Boot device backup
INFO: 2022-08-30 09:08:51: Getting EFI device
INFO: 2022-08-30 09:08:51: ...step1 - unmounting EFI
INFO: 2022-08-30 09:08:51: ...step2 - making efi device backup
SUCCESS: 2022-08-30 09:08:52: ...EFI device backup saved as '/opt/odabr/out/hbi/efi.img'
INFO: 2022-08-30 09:08:52: ...step3 - checking EFI device backup
INFO: 2022-08-30 09:08:52: Getting boot device
INFO: 2022-08-30 09:08:52: ...step1 - making boot device backup using tar
SUCCESS: 2022-08-30 09:08:57: ...boot content saved as '/opt/odabr/out/hbi/boot.tar.gz'
INFO: 2022-08-30 09:08:57: ...step2 - unmounting boot
INFO: 2022-08-30 09:08:57: ...step3 - making boot device backup using dd
SUCCESS: 2022-08-30 09:08:59: ...boot device backup saved as '/opt/odabr/out/hbi/boot.img'
INFO: 2022-08-30 09:08:59: ...step4 - mounting boot
INFO: 2022-08-30 09:08:59: ...step5 - mounting EFI
INFO: 2022-08-30 09:08:59: ...step6 - checking boot device backup
INFO: 2022-08-30 09:08:59: Making OCR physical backup
INFO: 2022-08-30 09:09:02: ...ocr backup saved as '/opt/odabr/out/hbi/ocrbackup_35684.bck'
SUCCESS: 2022-08-30 09:09:02: OCR physical backup created successfully
INFO: 2022-08-30 09:09:02: OCR export backup
INFO: 2022-08-30 09:09:03: ...ocr export saved as '/opt/odabr/out/hbi/ocrexport_35684.bck'
SUCCESS: 2022-08-30 09:09:03: OCR export backup created successfully
INFO: 2022-08-30 09:09:03: Making LVM snapshot backup
SUCCESS: 2022-08-30 09:09:04: ...snapshot backup for 'opt' created successfully
SUCCESS: 2022-08-30 09:09:05: ...snapshot backup for 'u01' created successfully
SUCCESS: 2022-08-30 09:09:05: ...snapshot backup for 'root' created successfully
SUCCESS: 2022-08-30 09:09:05: LVM snapshots backup done successfully
我们现在应该有快照了
[root@oda-prod software]# /opt/odabr/odabr infosnap
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
odabr - ODA node Backup Restore - Version: 2.0.1-70
Copyright 2013, 2021, Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
LVM snap name Status COW Size Data%
------------- ---------- ---------- ------
root_snap active 15.00 GiB 0.01%
opt_snap active 60.00 GiB 0.01%
u01_snap active 90.00 GiB 0.01%
[root@oda-prod software]#
现在我们可以开始打补丁了。首先，让我们解包补丁p32790643_1911000_Linux-x86-64.zip
[root@oda-prod software]# unzip p32790643_1911000_Linux-x86-64.zip
Archive: p32790643_1911000_Linux-x86-64.zip
extracting: oda-sm-19.11.0.0.0-210530-server.zip
inflating: README.txt
[root@x0042db02 local_dumps]#
然后用补丁更新存储库
[root@oda-prod software]# odacli describe-job -i "832fbb4d-2186-4b85-9978-7f642e04f3a9"
Job details
----------------------------------------------------------------
ID: 832fbb4d-2186-4b85-9978-7f642e04f3a9
Description: Repository Update
Status: Success
Created: August 30, 2022 8:56:54 AM CEST
Message: /software/oda-sm-19.11.0.0.0-210530-server.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle August 30, 2022 8:56:54 AM CEST August 30, 2022 8:57:18 AM CEST Success
[root@oda-prod software]#
验证作业是否成功
[root@oda-prod software]# odacli describe-job -i "832fbb4d-2186-4b85-9978-7f642e04f3a9"
Job details
----------------------------------------------------------------
ID: 832fbb4d-2186-4b85-9978-7f642e04f3a9
Description: Repository Update
Status: Success
Created: August 30, 2022 8:56:54 AM CEST
Message: /software/oda-sm-19.11.0.0.0-210530-server.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle August 30, 2022 8:56:54 AM CEST August 30, 2022 8:57:18 AM CEST Success
[root@oda-prod software]#
然后更新DCS_ADMIN
[root@oda-prod software]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.11.0.0.0
{
"jobId" : "fb14a1d0-52ce-43c3-871d-c93fdaff75b9",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "August 30, 2022 09:11:57 AM CEST",
"resourceList" : [ ],
"description" : "DcsAdmin patching",
"updatedTime" : "August 30, 2022 09:11:57 AM CEST"
}
这项工作应该会取得成功
[root@oda-prod software]# odacli describe-job -i "fb14a1d0-52ce-43c3-871d-c93fdaff75b9"
Job details
----------------------------------------------------------------
ID: fb14a1d0-52ce-43c3-871d-c93fdaff75b9
Description: DcsAdmin patching
Status: Success
Created: August 30, 2022 9:11:57 AM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Patch location validation August 30, 2022 9:11:57 AM CEST August 30, 2022 9:11:57 AM CEST Success
dcs-admin upgrade August 30, 2022 9:11:57 AM CEST August 30, 2022 9:12:03 AM CEST Success
[root@oda-prod software]#
让我们更新DCS组件
[root@oda-prod software]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.11.0.0. 0
{
"jobId" : "a274b632-92a8-4f8f-b05d-b3c5d7c67dae",
"status" : "Success",
"message" : "Update-dcscomponents is successful on all the node(s):DCS-Agent shutdown is successful. MySQL installation is successful. Metadata migration is successful. Metadata schema update is done. dcsagent RPM upgrade is successful. dcscli RPM upgrade is successful. dcscontroller RPM upgrade is successful. Successfully ran setupAgentAuth.sh zookeeper RPM upgrade is successful. DCS-Agent restart is successful. ",
"reports" : null,
"createTimestamp" : "August 30, 2022 09:13:37 AM CEST",
"description" : "Update-dcscomponents job completed and is not part of Agent job list",
"updatedTime" : "August 30, 2022 09:15:41 AM CEST"
}
[root@oda-prod software]#
此作业的描述作业不返回任何内容。这很正常，别担心
[root@oda-prod software]# odacli describe-job -i "a274b632-92a8-4f8f-b05d-b3c5d7c67dae"
DCS-10000:Resource Job with ID a274b632-92a8-4f8f-b05d-b3c5d7c67dae is not found.
此时我们可以看到组件的状态
[root@oda-prod software]# odacli describe-component
System Version
---------------
19.11.0.0.0
System node Name
---------------
oda-prod
Local System Version
---------------
19.11.0.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK 19.9.0.0.0 19.11.0.0.0
GI 19.9.0.0.201020 19.11.0.0.210420
DB {
[ OraDB19000_home1 ] 19.9.0.0.201020 19.11.0.0.210420
[ OraDB11204_home1 ] 11.2.0.4.201020 not-available
}
DCSAGENT 19.11.0.0.0 up-to-date
OS 7.8 7.9
ILOM 5.0.1.21.r136383 5.0.1.21.a.r138015
BIOS 52030400 up-to-date
FIRMWARECONTROLLER VDV1RL04 up-to-date
FIRMWAREDISK 1102 up-to-date
ASR 20.3.0 up-to-date
HMP 2.4.7.0.1 2.4.8.0.600
[root@oda-prod software]#
我们现在可以更新DCS代理
[root@oda-prod software]# /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.11.0.0.0
{
"jobId" : "0ea4fc54-4797-47a0-966d-de1f3d14bda4",
"status" : "Created",
"message" : "Dcs agent will be restarted after the update. Please wait for 2-3 mins before executing the other commands",
"reports" : [ ],
"createTimestamp" : "August 30, 2022 09:21:11 AM CEST",
"resourceList" : [ ],
"description" : "DcsAgent patching",
"updatedTime" : "August 30, 2022 09:21:11 AM CEST"
}
[root@oda-prod software]#
作业状态应返回“成功”
[root@oda-prod software]# odacli describe-job -i "0ea4fc54-4797-47a0-966d-de1f3d14bda4"
Job details
----------------------------------------------------------------
ID: 0ea4fc54-4797-47a0-966d-de1f3d14bda4
Description: DcsAgent patching
Status: Success
Created: August 30, 2022 9:21:11 AM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
dcs-agent upgrade to version 19.11.0.0.0 August 30, 2022 9:21:12 AM CEST August 30, 2022 9:23:32 AM CEST Success
Update System version August 30, 2022 9:23:32 AM CEST August 30, 2022 9:23:32 AM CEST Success
[root@oda-prod software]#
现在是时候用网格补丁更新存储库了
我们打开相应的补丁
[root@oda-prod software]# unzip p30403673_1911000_Linux-x86-64.zip
Archive: p30403673_1911000_Linux-x86-64.zip
extracting: odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip
replace README.txt? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
inflating: README.txt
[root@oda-prod software]# ls -l odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip
-rwxrwxrwx 1 root root 5550326480 May 31 2021 odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip
[root@oda-prod software]#
我们用补丁更新存储库
[root@oda-prod software]# /opt/oracle/dcs/bin/odacli update-repository -f /software/odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip
{
"jobId" : "17adc146-c10f-418a-b08b-f7d4c9390cbc",
"status" : "Created",
"message" : "/software/odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip",
"reports" : [ ],
"createTimestamp" : "August 30, 2022 09:27:17 AM CEST",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "August 30, 2022 09:27:17 AM CEST"
}
[root@oda-prod software]#
确保这项工作很好
[root@oda-prod software]# odacli describe-job -i "17adc146-c10f-418a-b08b-f7d4c9390cbc"
Job details
----------------------------------------------------------------
ID: 17adc146-c10f-418a-b08b-f7d4c9390cbc
Description: Repository Update
Status: Success
Created: August 30, 2022 9:27:17 AM CEST
Message: /software/odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle August 30, 2022 9:27:20 AM CEST August 30, 2022 9:27:58 AM CEST Success
registering image August 30, 2022 9:27:58 AM CEST August 30, 2022 9:27:58 AM CEST Success
[root@oda-prod software]#
在应用补丁之前，我们可以运行预补丁检查
[root@oda-prod software]# /opt/oracle/dcs/bin/odacli create-prepatchreport -s -v 19.11.0.0.0
Job details
----------------------------------------------------------------
ID: 09ff843d-1b4c-4a90-91ec-61004684903e
Description: Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER]
Status: Created
Created: August 30, 2022 9:30:58 AM CEST
Message: Use 'odacli describe-prepatchreport -i 09ff843d-1b4c-4a90-91ec-61004684903e' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
[root@oda-prod software]#
结果如下：
[root@oda-prod software]# odacli describe-prepatchreport -i 09ff843d-1b4c-4a90-91ec-61004684903e
Patch pre-check report
------------------------------------------------------------------------
Job ID: 09ff843d-1b4c-4a90-91ec-61004684903e
Description: Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER]
Status: SUCCESS
Created: August 30, 2022 9:30:58 AM CEST
Result: All pre-checks succeeded
Node Name
---------------
oda-prod
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__OS__
Validate supported versions Success Validated minimum supported versions.
Validate patching tag Success Validated patching tag: 19.11.0.0.0.
Is patch location available Success Patch location is available.
Verify OS patch Success Verified OS patch
Validate command execution Success Validated command execution
__ILOM__
Validate supported versions Success Validated minimum supported versions.
Validate patching tag Success Validated patching tag: 19.11.0.0.0.
Is patch location available Success Patch location is available.
Checking Ilom patch Version Success Successfully verified the versions
Patch location validation Success Successfully validated location
Validate command execution Success Validated command execution
__GI__
Validate supported GI versions Success Validated minimum supported versions.
Validate available space Success Validated free space under /u01
Is clusterware running Success Clusterware is running
Validate patching tag Success Validated patching tag: 19.11.0.0.0.
Is system provisioned Success Verified system is provisioned
Validate ASM in online Success ASM is online
Validate minimum agent version Success GI patching enabled in current
DCSAGENT version
Validate clones location exist Success Validated clones location
Validate command execution Success Validated command execution
__ORACHK__
Running orachk Success Successfully ran Orachk
Validate command execution Success Validated command execution
[root@oda-prod software]#
由于一切正常，我们可以应用补丁。我们只需确保为//opt和/u01提供至少20G的可用空间
[root@oda-prod software]# df -h / /opt /u01
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroupSys-LogVolRoot 30G 6.5G 22G 24% /
/dev/mapper/VolGroupSys-LogVolOpt 99G 33G 61G 36% /opt
/dev/mapper/VolGroupSys-LogVolU01 99G 65G 29G 70% /u01
[root@oda-prod software]#
我们为服务器应用补丁
[root@oda-prod software]# /opt/oracle/dcs/bin/odacli update-server -v 19.11.0.0.0
{
"jobId" : "5d3a7493-4426-4272-8ffc-59fad66a1eab",
"status" : "Created",
"message" : "Success of server update will trigger reboot of the node after 4-5 minutes. Please wait until the node reboots.",
"reports" : [ ],
"createTimestamp" : "August 30, 2022 09:37:06 AM CEST",
"resourceList" : [ ],
"description" : "Server Patching",
"updatedTime" : "August 30, 2022 09:37:06 AM CEST"
}
[root@oda-prod software]#
几分钟后，我们验证修补程序是否正常
[root@oda-prod log]# odacli describe-job -i 5d3a7493-4426-4272-8ffc-59fad66a1eab
Job details
----------------------------------------------------------------
ID: 5d3a7493-4426-4272-8ffc-59fad66a1eab
Description: Server Patching
Status: Success
Created: August 30, 2022 9:37:06 AM CEST
Message: Successfully patched GI with RHP
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Patch location validation August 30, 2022 9:37:14 AM CEST August 30, 2022 9:37:14 AM CEST Success
dcs-controller upgrade August 30, 2022 9:37:17 AM CEST August 30, 2022 9:37:17 AM CEST Success
Creating repositories using yum August 30, 2022 9:37:17 AM CEST August 30, 2022 9:37:19 AM CEST Success
Updating YumPluginVersionLock rpm August 30, 2022 9:37:19 AM CEST August 30, 2022 9:37:19 AM CEST Success
Applying OS Patches August 30, 2022 9:37:19 AM CEST August 30, 2022 9:46:49 AM CEST Success
Creating repositories using yum August 30, 2022 9:46:49 AM CEST August 30, 2022 9:46:49 AM CEST Success
Applying HMP Patches August 30, 2022 9:46:49 AM CEST August 30, 2022 9:47:05 AM CEST Success
Patch location validation August 30, 2022 9:47:05 AM CEST August 30, 2022 9:47:05 AM CEST Success
oda-hw-mgmt upgrade August 30, 2022 9:47:05 AM CEST August 30, 2022 9:47:33 AM CEST Success
OSS Patching August 30, 2022 9:47:33 AM CEST August 30, 2022 9:47:33 AM CEST Success
Applying Firmware Disk Patches August 30, 2022 9:47:34 AM CEST August 30, 2022 9:47:40 AM CEST Success
Applying Firmware Controller Patches August 30, 2022 9:47:40 AM CEST August 30, 2022 9:47:44 AM CEST Success
Checking Ilom patch Version August 30, 2022 9:47:44 AM CEST August 30, 2022 9:47:45 AM CEST Success
Patch location validation August 30, 2022 9:47:45 AM CEST August 30, 2022 9:47:45 AM CEST Success
Save password in Wallet August 30, 2022 9:47:45 AM CEST August 30, 2022 9:47:45 AM CEST Success
Apply Ilom patch August 30, 2022 9:47:45 AM CEST August 30, 2022 9:56:18 AM CEST Success
Copying Flash Bios to Temp location August 30, 2022 9:56:18 AM CEST August 30, 2022 9:56:18 AM CEST Success
Patch location validation August 30, 2022 9:56:18 AM CEST August 30, 2022 9:56:18 AM CEST Success
ASR Manager RPM update August 30, 2022 9:56:19 AM CEST August 30, 2022 9:56:19 AM CEST Success
Modify JavaExec Path August 30, 2022 9:56:19 AM CEST August 30, 2022 9:56:19 AM CEST Success
Remove AsrConfBackup File August 30, 2022 9:56:19 AM CEST August 30, 2022 9:56:19 AM CEST Success
Starting the clusterware August 30, 2022 9:56:19 AM CEST August 30, 2022 9:58:23 AM CEST Success
create ASM priv network August 30, 2022 9:58:23 AM CEST August 30, 2022 9:58:27 AM CEST Success
configure ASM priv network August 30, 2022 9:58:27 AM CEST August 30, 2022 9:58:29 AM CEST Success
Starting the clusterware August 30, 2022 9:58:29 AM CEST August 30, 2022 9:58:29 AM CEST Success
registering image August 30, 2022 9:58:29 AM CEST August 30, 2022 9:58:29 AM CEST Success
registering working copy August 30, 2022 9:58:29 AM CEST August 30, 2022 9:58:30 AM CEST Success
registering image August 30, 2022 9:58:30 AM CEST August 30, 2022 9:58:30 AM CEST Success
Creating GI home directories August 30, 2022 9:58:30 AM CEST August 30, 2022 9:58:30 AM CEST Success
Extract Gi clone August 30, 2022 9:58:30 AM CEST August 30, 2022 9:59:55 AM CEST Success
Provisioning Software Only GI with RHP August 30, 2022 9:59:55 AM CEST August 30, 2022 10:00:56 AM CEST Success
Patch GI with RHP August 30, 2022 10:00:56 AM CEST August 30, 2022 10:09:13 AM CEST Success
Updating GiHome version August 30, 2022 10:09:13 AM CEST August 30, 2022 10:09:15 AM CEST Success
Starting the clusterware August 30, 2022 10:09:19 AM CEST August 30, 2022 10:09:19 AM CEST Success
remove network public interface August 30, 2022 10:09:19 AM CEST August 30, 2022 10:09:22 AM CEST Success
create bridge network August 30, 2022 10:09:22 AM CEST August 30, 2022 10:09:27 AM CEST Success
modify network public interface August 30, 2022 10:09:27 AM CEST August 30, 2022 10:09:28 AM CEST Success
Update System version August 30, 2022 10:09:28 AM CEST August 30, 2022 10:09:28 AM CEST Success
Cleanup JRE Home August 30, 2022 10:09:28 AM CEST August 30, 2022 10:09:28 AM CEST Success
Add SYSNAME in Env August 30, 2022 10:09:28 AM CEST August 30, 2022 10:09:28 AM CEST Success
Setting ACL for disk groups August 30, 2022 10:09:28 AM CEST August 30, 2022 10:09:31 AM CEST Success
preRebootNode Actions August 30, 2022 10:10:39 AM CEST August 30, 2022 10:11:30 AM CEST Success
Reboot Ilom August 30, 2022 10:11:30 AM CEST August 30, 2022 10:11:30 AM CEST Success
[root@oda-prod log]#
低于组件版本。我们可以看到，除了Oracle数据库19c之外，所有组件都是最新的。稍后我们将对数据库进行路径选择
[root@oda-prod ~]# odacli describe-component
System Version
---------------
19.11.0.0.0
System node Name
---------------
oda-prod
Local System Version
---------------
19.11.0.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK 19.11.0.0.0 up-to-date
GI 19.11.0.0.210420 up-to-date
DB {
[ OraDB19000_home1 ] 19.9.0.0.201020 19.11.0.0.210420
[ OraDB11204_home1 ] 11.2.0.4.201020 not-available
}
DCSAGENT 19.11.0.0.0 up-to-date
OS 7.9 up-to-date
ILOM 5.0.1.21.a.r138015 up-to-date
BIOS 52030400 up-to-date
FIRMWARECONTROLLER VDV1RL04 up-to-date
FIRMWAREDISK 1102 up-to-date
ASR 20.3.0 up-to-date
HMP 2.4.8.0.600 up-to-date
[root@oda-prod ~]#
要修补存储，我们运行以下命令
[root@oda-prod ~]# /opt/oracle/dcs/bin/odacli update-storage -v 19.11.0.0.0
{
"jobId" : "eea8b12b-76d1-4695-9b29-f0102a8a67da",
"status" : "Created",
"message" : "Success of Storage Update may trigger reboot of node after 4-5 minutes. Please wait till node restart",
"reports" : [ ],
"createTimestamp" : "August 30, 2022 10:16:38 AM CEST",
"resourceList" : [ ],
"description" : "Storage Firmware Patching",
"updatedTime" : "August 30, 2022 10:16:38 AM CEST"
}
[root@oda-prod ~]#
这项工作取得了成功
[root@oda-prod ~]# odacli describe-job -i "eea8b12b-76d1-4695-9b29-f0102a8a67da"
Job details
----------------------------------------------------------------
ID: eea8b12b-76d1-4695-9b29-f0102a8a67da
Description: Storage Firmware Patching
Status: Success
Created: August 30, 2022 10:16:38 AM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Applying Firmware Disk Patches August 30, 2022 10:16:45 AM CEST August 30, 2022 10:16:49 AM CEST Success
preRebootNode Actions August 30, 2022 10:16:50 AM CEST August 30, 2022 10:16:50 AM CEST Success
Reboot Ilom August 30, 2022 10:16:50 AM CEST August 30, 2022 10:16:50 AM CEST Success
[root@oda-prod ~]#
由于修补程序运行良好，我们现在可以删除odabr快照
[root@oda-prod software]# /opt/odabr/odabr delsnap
INFO: 2022-08-30 10:22:10: Please check the logfile '/opt/odabr/out/log/odabr_64634.log' for more details
INFO: 2022-08-30 10:22:10: Removing LVM snapshots
INFO: 2022-08-30 10:22:10: ...removing LVM snapshot for 'opt'
SUCCESS: 2022-08-30 10:22:11: ...snapshot for 'opt' removed successfully
INFO: 2022-08-30 10:22:11: ...removing LVM snapshot for 'u01'
SUCCESS: 2022-08-30 10:22:11: ...snapshot for 'u01' removed successfully
INFO: 2022-08-30 10:22:11: ...removing LVM snapshot for 'root'
SUCCESS: 2022-08-30 10:22:11: ...snapshot for 'root' removed successfully
SUCCESS: 2022-08-30 10:22:11: Remove LVM snapshots done successfully
[root@oda-prod software]#
修补现有数据库
在我的例子中，只更新了19c个数据库。此更新不支持Oracle 11g。
第一步是解包相应的文件
[root@oda-prod software]# unzip p30403662_1911000_Linux-x86-64.zip
Archive: p30403662_1911000_Linux-x86-64.zip
extracting: odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip
inflating: README.txt
[root@oda-prod software]#
[root@oda-prod software]# ls -l odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip
-rwxrwxrwx 1 root root 4953108233 May 31 2021 odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip
[root@oda-prod software]#
我们将DB 19c克隆加载到存储库中
[root@oda-prod software]# /opt/oracle/dcs/bin/odacli update-repository -f /software/odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip
{
"jobId" : "87445cac-e643-474c-87ec-93b7811caa17",
"status" : "Created",
"message" : "/software/odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip",
"reports" : [ ],
"createTimestamp" : "August 30, 2022 10:47:07 AM CEST",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "August 30, 2022 10:47:07 AM CEST"
}
[root@oda-prod software]#
我们验证作业的状态
[root@oda-prod software]# odacli describe-job -i "87445cac-e643-474c-87ec-93b7811caa17"
Job details
----------------------------------------------------------------
ID: 87445cac-e643-474c-87ec-93b7811caa17
Description: Repository Update
Status: Success
Created: August 30, 2022 10:47:07 AM CEST
Message: /software/odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle August 30, 2022 10:47:09 AM CEST August 30, 2022 10:47:44 AM CEST Success
registering image August 30, 2022 10:47:44 AM CEST August 30, 2022 10:47:45 AM CEST Success
[root@oda-prod software]#
在文档中，我们可以细化以下行：
从Oracle Database Appliance 19.11版开始，Oracle数据库主目录不会在本地磁盘上创建。Oracle数据库主目录是在Oracle ACFS管理的文件系统上创建的。对于数据库用户oracle，将在/u01/app/odorahome/oracle/下创建新的数据库主页。
在修补数据库主存储之前，请使用odacli configure dbhome storage命令配置数据库主存储：
然后，我们为Dbhome创建存储
[root@oda-prod software]# odacli configure-dbhome-storage -dg DATA
{
"jobId" : "c82c5d33-fe67-4092-86d8-5746db2ac447",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "August 30, 2022 10:50:07 AM CEST",
"resourceList" : [ ],
"description" : "Configure database home storage",
"updatedTime" : "August 30, 2022 10:50:07 AM CEST"
}
You have new mail in /var/spool/mail/root
[root@oda-prod software]#
[root@oda-prod software]# odacli describe-job -i "c82c5d33-fe67-4092-86d8-5746db2ac447"
Job details
----------------------------------------------------------------
ID: c82c5d33-fe67-4092-86d8-5746db2ac447
Description: Configure database home storage
Status: Success
Created: August 30, 2022 10:50:07 AM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Configuring database home storage August 30, 2022 10:50:07 AM CEST August 30, 2022 10:50:07 AM CEST Success
[root@oda-prod software]#
run the prepatch
[root@oda-prod software]# odacli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
2a82f095-5952-42fa-b22c-a81ca6da5f30 OraDB19000_home1 19.9.0.0.201020 /u01/app/oracle/product/19.0.0.0/dbhome_1 CONFIGURED
100c93b2-0f50-43e6-a04f-bb4a78c41aeb OraDB11204_home1 11.2.0.4.201020 /u01/app/oracle/product/11.2.0.4/dbhome_1 CONFIGURED
[root@oda-prod software]#
在修补HOMES之前，我们先进行预检查。
[root@oda-prod software]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid 2a82f095-5952-42fa-b22c-a81ca6da5f30 -v 19.11.0.0.0
Job details
----------------------------------------------------------------
ID: 8ac2998e-ce0e-47e5-b9c3-6e5fd0c49139
Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home1
Status: Created
Created: August 30, 2022 10:52:56 AM CEST
Message: Use 'odacli describe-prepatchreport -i 8ac2998e-ce0e-47e5-b9c3-6e5fd0c49139' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
[root@oda-prod software]#
结果如下
[root@oda-prod software]# odacli describe-prepatchreport -i 8ac2998e-ce0e-47e5-b9c3-6e5fd0c49139
Patch pre-check report
------------------------------------------------------------------------
Job ID: 8ac2998e-ce0e-47e5-b9c3-6e5fd0c49139
Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home1
Status: FAILED
Created: August 30, 2022 10:52:56 AM CEST
Result: One or more pre-checks failed for [ORACHK]
Node Name
---------------
oda-prod
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__DB__
Validate DB Home ID Success Validated DB Home ID:
2a82f095-5952-42fa-b22c-a81ca6da5f30
Validate patching tag Success Validated patching tag: 19.11.0.0.0.
Is system provisioned Success Verified system is provisioned
Validate minimum agent version Success Validated minimum agent version
Is GI upgraded Success Validated GI is upgraded
Validate available space for Success Validated free space required under
db /u01
Is DB clone registered Success Successfully validated clone
registered
Is DB clone available Success Successfully validated clone file
exists
Validate command execution Success Validated command execution
__ORACHK__
Running orachk Failed Orachk validation failed: .
Validate command execution Success Validated command execution
Verify the Alternate Archive Failed AHF-4940: One or more log archive
Destination is Configured to destination and alternate log archive
Prevent Database Hangs destination settings are not as
recommended
Verify the Alternate Archive Failed AHF-4940: One or more log archive
Destination is Configured to destination and alternate log archive
Prevent Database Hangs destination settings are not as
recommended
Verify the Alternate Archive Failed AHF-4940: One or more log archive
Destination is Configured to destination and alternate log archive
Prevent Database Hangs destination settings are not as
recommended
Verify the Alternate Archive Failed AHF-4940: One or more log archive
Destination is Configured to destination and alternate log archive
Prevent Database Hangs destination settings are not as
recommended
Check for parameter Failed AHF-3744: Database parameter
global_names GLOBAL_NAMES is not set to
recommended value
Check for parameter Failed AHF-3744: Database parameter
global_names GLOBAL_NAMES is not set to
recommended value
Check for parameter Failed AHF-3744: Database parameter
global_names GLOBAL_NAMES is not set to
recommended value
Verify the Fast Recovery Area Failed AHF-2929: FRA space management
(FRA) has reclaimable space problem file types are present
without an RMAN backup completion
within the last 7 days
[root@oda-prod software]#
我们有一些错误。在查看了Oracle关于已知问题的文档之后，我们发现了以下几行：
update dbhome命令的预批处理报告中出现AHF错误
将服务器修补到Oracle Database Appliance 19.13版时，odacli update dbhome命令可能会失败。
补丁前报告中显示以下错误消息：
验证备用存档失败AHF-4940：一个或多个日志存档
目标配置为目标和备用日志存档
防止数据库挂起。不建议使用目标设置
硬件模型：所有Oracle数据库设备硬件模型
变通办法
请遵循以下步骤：
使用-f选项运行odacli update dbhome命令。
/opt/oracle/dcs/bin/odacli更新dbhome–dbhomeid 7c67c5b4-f585-4ba9-865f-c719c63c0a6e-v 19.13.0.0-f
此问题由Oracle错误33144170跟踪。
对于与global_name相关的错误，我们将该值更改为true，并在修补后将其设置为false
然后我们使用选项-f运行补丁
[root@oda-prod archivelog]# /opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid 2a82f095-5952-42fa-b22c-a81ca6da5f30 -v 19.11.0.0.0 -f
{
"jobId" : "4b499623-9ca9-4089-b18b-5c13af1d9067",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "August 30, 2022 11:15:58 AM CEST",
"resourceList" : [ ],
"description" : "DB Home Patching: Home Id is 2a82f095-5952-42fa-b22c-a81ca6da5f30",
"updatedTime" : "August 30, 2022 11:15:58 AM CEST"
}
[root@oda-prod archivelog]#
几分钟后，补丁就好了
[root@oda-prod ~]# odacli describe-job -i "4b499623-9ca9-4089-b18b-5c13af1d9067"
Job details
----------------------------------------------------------------
ID: 4b499623-9ca9-4089-b18b-5c13af1d9067
Description: DB Home Patching: Home Id is 2a82f095-5952-42fa-b22c-a81ca6da5f30
Status: Success
Created: August 30, 2022 11:15:58 AM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Creating ACFS database home August 30, 2022 11:16:11 AM CEST August 30, 2022 11:17:01 AM CEST Success
Validating dbHome available space August 30, 2022 11:17:01 AM CEST August 30, 2022 11:17:01 AM CEST Success
Creating DbHome Directory August 30, 2022 11:17:01 AM CEST August 30, 2022 11:17:01 AM CEST Success
Create required directories August 30, 2022 11:17:01 AM CEST August 30, 2022 11:17:01 AM CEST Success
Extract DB clones August 30, 2022 11:17:01 AM CEST August 30, 2022 11:18:09 AM CEST Success
ProvDbHome by using RHP August 30, 2022 11:18:09 AM CEST August 30, 2022 11:19:11 AM CEST Success
Enable DB options August 30, 2022 11:19:11 AM CEST August 30, 2022 11:19:26 AM CEST Success
Creating wallet for DB Client August 30, 2022 11:19:29 AM CEST August 30, 2022 11:19:29 AM CEST Success
Creating wallet for DB Client August 30, 2022 11:19:53 AM CEST August 30, 2022 11:19:53 AM CEST Success
Patch databases by RHP August 30, 2022 11:19:53 AM CEST August 30, 2022 11:24:11 AM CEST Success
updating database metadata August 30, 2022 11:24:54 AM CEST August 30, 2022 11:24:54 AM CEST Success
Patch databases by RHP August 30, 2022 11:24:54 AM CEST August 30, 2022 11:29:01 AM CEST Success
updating database metadata August 30, 2022 11:29:41 AM CEST August 30, 2022 11:29:41 AM CEST Success
Update System version August 30, 2022 11:29:41 AM CEST August 30, 2022 11:29:41 AM CEST Success
Updating metadata for database August 30, 2022 11:30:09 AM CEST August 30, 2022 11:30:09 AM CEST Success
Updating metadata for database August 30, 2022 11:30:09 AM CEST August 30, 2022 11:30:09 AM CEST Success
[root@oda-prod ~]#
连接到19c数据库，我们可以验证RU现在是19.11
SQL> select description from dba_registry_sqlpatch;
DESCRIPTION
--------------------------------------------------------------------------------
OJVM RELEASE UPDATE: 19.9.0.0.201020 (31668882)
Database Release Update : 19.9.0.0.201020 (31771877)
OJVM RELEASE UPDATE: 19.9.0.0.201020 (31668882)
OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)
Database Release Update : 19.11.0.0.210420 (32545013)
SQL>
原文标题：Patch ODA X8 : 19.9 to 19.11
原文作者：Mouhamadou Diaw
原文链接：https://www.dbi-services.com/blog/patch-oda-x8-19-9-to-19-11/
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
