meta données pour cette page
Ceci est une ancienne révision du document !
Patch ODA from 19.21 to 19.22
This procedure is a classical patch, no reimaging
Following patches are required:
- Oracle Database Appliance Server Patch for the ODACLI/DCS stack (patch 36269277)
- Oracle Grid Infrastructure clone files (patch 30403673)
- Oracle Database clone files (patch 30403662)
Update ODA Repositories
- Unzip files. Once unpacked, we will have the following.
[root@phanes patch1922]# ls -ltra oda* -r--r--r-- 1 root root 4420437140 Mar 6 18:42 oda-sm-19.22.0.0.0-240306-server.zip -r--r--r-- 1 root root 5484816510 Mar 6 18:45 odacli-dcs-19.22.0.0.0-240306-DB-19.22.0.0.zip -r--r--r-- 1 root root 7002170313 Mar 6 18:48 odacli-dcs-19.22.0.0.0-240306-GI-19.22.0.0.zip [root@phanes patch1922]#
Update the repository with the server patch
[root@phanes patch1922]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/patch1922/oda-sm-19.22.0.0.0-240306-server.zip { "jobId" : "16c1193e-61ba-4b95-b46d-60ff5b47bebf", "status" : "Created", "message" : "/u01/Download/patch1922/oda-sm-19.22.0.0.0-240306-server.zip", "reports" : [ ], "createTimestamp" : "May 13, 2024 13:28:21 PM CEST", "resourceList" : [ ], "description" : "Repository Update", "updatedTime" : "May 13, 2024 13:28:21 PM CEST", "jobType" : null }
- Validate that the job was fine
[root@phanes patch1922]# odacli describe-job -i "16c1193e-61ba-4b95-b46d-60ff5b47bebf" Job details ---------------------------------------------------------------- ID: 16c1193e-61ba-4b95-b46d-60ff5b47bebf Description: Repository Update Status: Success Created: May 13, 2024 1:28:21 PM CEST Message: /u01/Download/patch1922/oda-sm-19.22.0.0.0-240306-server.zip Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Unzip bundle May 13, 2024 1:28:21 PM CEST May 13, 2024 1:28:50 PM CEST Success [root@phanes patch1922]#
- Update DCS admin
[root@phanes patch1922]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.22.0.0.0 { "jobId" : "22ef0e92-24c8-41f2-8382-0f67da826ead", "status" : "Created", "message" : null, "reports" : [ ], "createTimestamp" : "May 13, 2024 13:30:30 PM CEST", "resourceList" : [ ], "description" : "DcsAdmin patching", "updatedTime" : "May 13, 2024 13:30:30 PM CEST", "jobType" : null } [root@phanes patch1922]# odacli describe-job -i "22ef0e92-24c8-41f2-8382-0f67da826ead" Job details ---------------------------------------------------------------- ID: 22ef0e92-24c8-41f2-8382-0f67da826ead Description: DcsAdmin patching Status: Success Created: May 13, 2024 1:30:30 PM CEST Message: Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Patch location validation May 13, 2024 1:30:30 PM CEST May 13, 2024 1:30:30 PM CEST Success Dcs-admin upgrade May 13, 2024 1:30:30 PM CEST May 13, 2024 1:30:36 PM CEST Success [root@phanes patch1922]#
- Update the DCS components
[root@phanes patch1922]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.22.0.0.0 { "jobId" : "b259672f-8a9a-470d-a904-9bc0bce70759", "status" : "Success", "message" : " DCS-Agent shutdown is successful. MySQL upgrade is successful. Metadata schema update is done. dcsagent RPM upgrade is successful. dcscli RPM upgrade is successful. dcscontroller RPM upgrade is successful. Successfully reset the Keystore password. HAMI RPM and DCS ensemble update was successful. Removed old Libs Successfully ran setupAgentAuth.sh ", "reports" : null, "createTimestamp" : "May 13, 2024 13:31:55 PM CEST", "description" : "Update-dcscomponents job completed and is not part of Agent job list", "updatedTime" : "May 13, 2024 13:33:43 PM CEST", "jobType" : null } [root@phanes patch1922]#
- Update DCS agent
[root@phanes patch1922]# /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.22.0.0.0 { "jobId" : "186f0662-920d-4720-866c-7cf790313230", "status" : "Created", "message" : "DCS agent will be restarted after the update. Please wait for 2-3 mins before executing the other commands", "reports" : [ ], "createTimestamp" : "May 13, 2024 13:34:38 PM CEST", "resourceList" : [ ], "description" : "DcsAgent patching", "updatedTime" : "May 13, 2024 13:34:38 PM CEST", "jobType" : null } [root@phanes patch1922]# [root@phanes patch1922]# odacli describe-job -i "186f0662-920d-4720-866c-7cf790313230" Job details ---------------------------------------------------------------- ID: 186f0662-920d-4720-866c-7cf790313230 Description: DcsAgent patching Status: Success Created: May 13, 2024 1:34:38 PM CEST Message: Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------- Dcs-agent upgrade to version May 13, 2024 1:34:38 PM CEST May 13, 2024 1:37:43 PM CEST Success 19.22.0.0.0 Update System version May 13, 2024 1:37:43 PM CEST May 13, 2024 1:37:43 PM CEST Success [root@phanes patch1922]#
Update repository with grid clone and db clone
- Grid clone
[root@phanes patch1922]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/patch1922/odacli-dcs-19.22.0.0.0-240306-GI-19.22.0.0.zip { "jobId" : "a7ba0c70-057e-4533-95f0-028abf77769f", "status" : "Created", "message" : "/u01/Download/patch1922/odacli-dcs-19.22.0.0.0-240306-GI-19.22.0.0.zip", "reports" : [ ], "createTimestamp" : "May 13, 2024 13:40:31 PM CEST", "resourceList" : [ ], "description" : "Repository Update", "updatedTime" : "May 13, 2024 13:40:31 PM CEST", "jobType" : null } [root@phanes patch1922]# [root@phanes patch1922]# odacli describe-job -i "a7ba0c70-057e-4533-95f0-028abf77769f" Job details ---------------------------------------------------------------- ID: a7ba0c70-057e-4533-95f0-028abf77769f Description: Repository Update Status: Success Created: May 13, 2024 1:40:31 PM CEST Message: /u01/Download/patch1922/odacli-dcs-19.22.0.0.0-240306-GI-19.22.0.0.zip Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------- Unzip bundle May 13, 2024 1:40:31 PM CEST May 13, 2024 1:41:14 PM CEST Success [root@phanes patch1922]#
- Database clone
[root@phanes patch1922]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/patch1922/odacli-dcs-19.22.0.0.0-240306-DB-19.22.0.0.zip { "jobId" : "fcb822ee-6b2f-4ff4-bccc-361276b455b7", "status" : "Created", "message" : "/u01/Download/patch1922/odacli-dcs-19.22.0.0.0-240306-DB-19.22.0.0.zip", "reports" : [ ], "createTimestamp" : "May 13, 2024 13:41:49 PM CEST", "resourceList" : [ ], "description" : "Repository Update", "updatedTime" : "May 13, 2024 13:41:49 PM CEST", "jobType" : null } [root@phanes patch1922]# [root@phanes patch1922]# odacli describe-job -i "fcb822ee-6b2f-4ff4-bccc-361276b455b7" Job details ---------------------------------------------------------------- ID: fcb822ee-6b2f-4ff4-bccc-361276b455b7 Description: Repository Update Status: Success Created: May 13, 2024 1:41:49 PM CEST Message: /u01/Download/patch1922/odacli-dcs-19.22.0.0.0-240306-DB-19.22.0.0.zip Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------- Unzip bundle May 13, 2024 1:41:49 PM CEST May 13, 2024 1:42:23 PM CEST Success [root@phanes patch1922]#
Run patching pre-checks Before launching the patch, be sure that the prepatch check did not return any error.
[root@phanes patch1922]# /opt/oracle/dcs/bin/odacli create-prepatchreport -s -v 19.22.0.0.0
Job details
ID: cc822327-5f38-4bab-9bc5-c333b0f66485
Description: Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER, SERVER]
Status: Created
Created: May 13, 2024 1:45:30 PM CEST
Message: Use 'odacli describe-prepatchreport -i cc822327-5f38-4bab-9bc5-c333b0f66485' to check details of results
Task Name Start Time End Time Status —————————————- —————————————- —————————————- —————-
[root@phanes patch1922]#
Validate the output
[root@phanes patch1922]# odacli describe-prepatchreport -i cc822327-5f38-4bab-9bc5-c333b0f66485
Patch pre-check report
Job ID: cc822327-5f38-4bab-9bc5-c333b0f66485
Description: Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER, SERVER]
Status: SUCCESS
Created: May 13, 2024 1:45:30 PM CEST
Result: All pre-checks succeeded
Node Name
phanes
Pre-Check Status Comments —————————— ——– ————————————– OS Validate supported versions Success Validated minimum supported versions. Validate patching tag Success Validated patching tag: 19.22.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 ILOM server reachable Success Successfully connected with ILOM
server using public IP and USB
interconnect
Validate supported versions Success Validated minimum supported versions. Validate patching tag Success Validated patching tag: 19.22.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 GI metadata Success Successfully validated GI metadata Validate supported GI versions Success Successfully validated minimum version Validate available space Success Validated free space under /u01 Is clusterware running Success Clusterware is running Validate patching tag Success Validated patching tag: 19.22.0.0.0. Is system provisioned Success Verified system is provisioned Validate ASM in online Success ASM is online Validate kernel log level Success Successfully validated the OS log
level
Validate minimum agent version Success GI patching enabled in current
DCSAGENT version
Validate Central Inventory Success oraInventory validation passed Validate patching locks Success Validated patching locks Validate clones location exist Success Validated clones location Validate DB start dependencies Success DBs START dependency check passed Validate DB stop dependencies Success DBs STOP dependency check passed Validate space for clones Success Clones volume is already created volume Evaluate GI patching Success Successfully validated GI patching Validate command execution Success Validated command execution
ORACHK Running orachk Success Successfully ran Orachk Validate command execution Success Validated command execution
SERVER Validate local patching Success Successfully validated server local
patching
Validate command execution Success Validated command execution
[root@phanes patch1922]#
Update the server
Take an backup with odabr
[root@phanes patch1922]# /opt/odabr/odabr infosnap
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ odabr - ODA node Backup Restore - Version: 2.0.1-72 Copyright 2013, 2023, 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: 2024-05-13 13:53:18: LVM snapshot for 'root' does not exist WARNING: 2024-05-13 13:53:18: LVM snapshot for 'opt' does not exist WARNING: 2024-05-13 13:53:18: LVM snapshot for 'u01' does not exist
[root@phanes patch1922]# /opt/odabr/odabr backup -snap -rsize 15 -usize 60 -osize 40 INFO: 2024-05-13 13:53:27: Please check the logfile '/opt/odabr/out/log/odabr_21801.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ odabr - ODA node Backup Restore - Version: 2.0.1-72 Copyright 2013, 2023, Oracle and/or its affiliates.
Author: Ruggero Citton ruggero.citton@oracle.com RAC Pack, Cloud Innovation and Solution Engineering Team │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2024-05-13 13:53:27: Checking superuser INFO: 2024-05-13 13:53:27: Checking Bare Metal
INFO: 2024-05-13 13:53:27: Removing existing LVM snapshots WARNING: 2024-05-13 13:53:27: LVM snapshot for 'opt' does not exist WARNING: 2024-05-13 13:53:27: LVM snapshot for 'u01' does not exist WARNING: 2024-05-13 13:53:27: LVM snapshot for 'root' does not exist
INFO: 2024-05-13 13:53:27: Checking current OS version INFO: 2024-05-13 13:53:27: Checking LVM restore backgroud process INFO: 2024-05-13 13:53:27: Checking LVM size
INFO: 2024-05-13 13:53:27: Boot device backup INFO: 2024-05-13 13:53:27: Getting EFI device INFO: 2024-05-13 13:53:27: …step1 - unmounting EFI INFO: 2024-05-13 13:53:27: …step2 - making efi device backup SUCCESS: 2024-05-13 13:53:30: …EFI device backup saved as '/opt/odabr/out/hbi/efi.img' INFO: 2024-05-13 13:53:30: …step3 - checking EFI device backup INFO: 2024-05-13 13:53:30: Getting boot device INFO: 2024-05-13 13:53:30: …step1 - making boot device backup using tar SUCCESS: 2024-05-13 13:53:37: …boot content saved as '/opt/odabr/out/hbi/boot.tar.gz' INFO: 2024-05-13 13:53:37: …step2 - unmounting boot INFO: 2024-05-13 13:53:37: …step3 - making boot device backup using dd SUCCESS: 2024-05-13 13:53:39: …boot device backup saved as '/opt/odabr/out/hbi/boot.img' INFO: 2024-05-13 13:53:39: …step4 - mounting boot INFO: 2024-05-13 13:53:40: …step5 - mounting EFI INFO: 2024-05-13 13:53:40: …step6 - checking boot device backup
INFO: 2024-05-13 13:53:40: Making OCR physical backup INFO: 2024-05-13 13:53:42: …ocr backup saved as '/opt/odabr/out/hbi/ocrbackup_21801.bck' SUCCESS: 2024-05-13 13:53:42: OCR physical backup created successfully INFO: 2024-05-13 13:53:42: OCR export backup INFO: 2024-05-13 13:53:42: …ocr export saved as '/opt/odabr/out/hbi/ocrexport_21801.bck' SUCCESS: 2024-05-13 13:53:42: OCR export backup created successfully
INFO: 2024-05-13 13:53:42: Making LVM snapshot backup SUCCESS: 2024-05-13 13:53:43: …snapshot backup for 'opt' created successfully SUCCESS: 2024-05-13 13:53:43: …snapshot backup for 'u01' created successfully SUCCESS: 2024-05-13 13:53:44: …snapshot backup for 'root' created successfully SUCCESS: 2024-05-13 13:53:44: LVM snapshots backup done successfully
[root@phanes patch1922]# /opt/odabr/odabr infosnap
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ odabr - ODA node Backup Restore - Version: 2.0.1-72 Copyright 2013, 2023, 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.02% opt_snap active 40.00 GiB 0.01% u01_snap active 60.00 GiB 0.01%
[root@phanes patch1922]#
Now you can update the server.
The first time I got error because the gateway was not pingable. Then be sure that you can ping your gateway before launching the server patch
[root@phanes ~]# /opt/oracle/dcs/bin/odacli update-server -v 19.22.0.0.0 {
"jobId" : "53708fa8-757c-487b-a58f-622b12049c3f", "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" : "May 14, 2024 11:23:26 AM CEST", "resourceList" : [ ], "description" : "Server Patching", "updatedTime" : "May 14, 2024 11:23:26 AM CEST", "jobType" : null
} [root@phanes ~]#
The process should return success
[root@phanes ~]# odacli describe-job -i b816575f-5483-4f9d-9c00-35e53d55c014
Job details
ID: b816575f-5483-4f9d-9c00-35e53d55c014
Description: Server Patching
Status: Success
Created: May 15, 2024 10:14:37 AM CEST
Message:
Task Name Start Time End Time Status —————————————- —————————————- —————————————- —————- Validating GI user metadata May 15, 2024 10:14:47 AM CEST May 15, 2024 10:14:47 AM CEST Success Validate ILOM server reachable May 15, 2024 10:14:47 AM CEST May 15, 2024 10:14:47 AM CEST Success Validate DCS Admin mTLS setup May 15, 2024 10:14:47 AM CEST May 15, 2024 10:14:47 AM CEST Success Modify BM udev rules May 15, 2024 10:14:47 AM CEST May 15, 2024 10:15:07 AM CEST Success Creating repositories using yum May 15, 2024 10:15:07 AM CEST May 15, 2024 10:15:11 AM CEST Success Updating YumPluginVersionLock rpm May 15, 2024 10:15:11 AM CEST May 15, 2024 10:15:11 AM CEST Success Applying OS Patches May 15, 2024 10:15:11 AM CEST May 15, 2024 10:26:02 AM CEST Success Creating repositories using yum May 15, 2024 10:26:02 AM CEST May 15, 2024 10:26:02 AM CEST Success Applying HMP Patches May 15, 2024 10:26:02 AM CEST May 15, 2024 10:26:30 AM CEST Success Patch location validation May 15, 2024 10:26:30 AM CEST May 15, 2024 10:26:30 AM CEST Success Oda-hw-mgmt upgrade May 15, 2024 10:26:30 AM CEST May 15, 2024 10:27:03 AM CEST Success OSS Patching May 15, 2024 10:27:03 AM CEST May 15, 2024 10:27:03 AM CEST Success Applying Firmware Disk Patches May 15, 2024 10:27:04 AM CEST May 15, 2024 10:27:06 AM CEST Success Applying Firmware Controller Patches May 15, 2024 10:27:06 AM CEST May 15, 2024 10:27:09 AM CEST Success Checking Ilom patch Version May 15, 2024 10:27:09 AM CEST May 15, 2024 10:27:09 AM CEST Success Patch location validation May 15, 2024 10:27:09 AM CEST May 15, 2024 10:27:10 AM CEST Success Save password in Wallet May 15, 2024 10:27:10 AM CEST May 15, 2024 10:27:10 AM CEST Success Disabling IPMI v2 May 15, 2024 10:27:10 AM CEST May 15, 2024 10:27:11 AM CEST Success Apply Ilom patch May 15, 2024 10:27:11 AM CEST May 15, 2024 10:27:11 AM CEST Success Copying Flash Bios to Temp location May 15, 2024 10:27:11 AM CEST May 15, 2024 10:27:11 AM CEST Success Starting the clusterware May 15, 2024 10:27:11 AM CEST May 15, 2024 10:28:49 AM CEST Success Registering image May 15, 2024 10:28:49 AM CEST May 15, 2024 10:28:49 AM CEST Success Registering working copy May 15, 2024 10:28:49 AM CEST May 15, 2024 10:28:49 AM CEST Success Registering image May 15, 2024 10:28:49 AM CEST May 15, 2024 10:28:50 AM CEST Success Creating GI home directories May 15, 2024 10:28:50 AM CEST May 15, 2024 10:28:50 AM CEST Success Extract GI clone May 15, 2024 10:28:50 AM CEST May 15, 2024 10:28:50 AM CEST Success Provisioning Software Only GI with RHP May 15, 2024 10:28:50 AM CEST May 15, 2024 10:28:50 AM CEST Success Patch GI with RHP May 15, 2024 10:28:50 AM CEST May 15, 2024 10:36:00 AM CEST Success Updating .bashrc May 15, 2024 10:36:01 AM CEST May 15, 2024 10:36:01 AM CEST Success Server patching May 15, 2024 10:36:01 AM CEST May 15, 2024 10:36:01 AM CEST Success Updating GIHome version May 15, 2024 10:36:01 AM CEST May 15, 2024 10:36:05 AM CEST Success Updating All DBHome version May 15, 2024 10:36:05 AM CEST May 15, 2024 10:36:09 AM CEST Success Validate GI availability May 15, 2024 10:36:11 AM CEST May 15, 2024 10:36:12 AM CEST Success Patch KVM CRS type May 15, 2024 10:36:12 AM CEST May 15, 2024 10:36:12 AM CEST Success Patch VM vDisks CRS dependencies May 15, 2024 10:36:12 AM CEST May 15, 2024 10:36:12 AM CEST Success Patch DB System domain config May 15, 2024 10:36:12 AM CEST May 15, 2024 10:36:12 AM CEST Success Update System version May 15, 2024 10:36:12 AM CEST May 15, 2024 10:36:12 AM CEST Success Cleanup JRE Home May 15, 2024 10:36:12 AM CEST May 15, 2024 10:36:12 AM CEST Success Add SYSNAME in Env May 15, 2024 10:36:12 AM CEST May 15, 2024 10:36:12 AM CEST Success Starting the clusterware May 15, 2024 10:36:12 AM CEST May 15, 2024 10:36:12 AM CEST Success Generating and saving BOM May 15, 2024 10:36:12 AM CEST May 15, 2024 10:36:41 AM CEST Success PreRebootNode Actions May 15, 2024 10:36:41 AM CEST May 15, 2024 10:37:41 AM CEST Success Reboot Ilom May 15, 2024 10:37:41 AM CEST May 15, 2024 10:37:41 AM CEST Success
[root@phanes ~]#
Validate your component after the patch
[root@phanes ~]# odacli describe-component System Version
19.22.0.0.0
System node Name
phanes
Local System Version
19.22.0.0.0
Component Installed Version Available Version —————————————- ——————– ——————– OAK
19.22.0.0.0 up-to-date
GI
19.22.0.0.240116 up-to-date
DB[ DBTEST ]
19.21.0.0.231017 19.22.0.0.240116
DCSCONTROLLER
19.22.0.0.0 up-to-date
DCSCLI
19.22.0.0.0 up-to-date
DCSAGENT
19.22.0.0.0 up-to-date
DCSADMIN
19.22.0.0.0 up-to-date
OS
8.9 up-to-date
ILOM
5.1.3.20.r153596 up-to-date
BIOS
52110200 up-to-date
LOCAL CONTROLLER FIRMWARE
214.2.271.9 up-to-date
SHARED CONTROLLER FIRMWARE
VDV1RL06 up-to-date
LOCAL DISK FIRMWARE
XC311132 up-to-date
HMP
2.4.9.2.600 up-to-date
[root@phanes ~]#
Remove the odabr backups
[root@phanes ~]# /opt/odabr/odabr delsnap INFO: 2024-05-15 11:02:05: Please check the logfile '/opt/odabr/out/log/odabr_66739.log' for more details
INFO: 2024-05-15 11:02:05: Removing LVM snapshots INFO: 2024-05-15 11:02:05: …removing LVM snapshot for 'opt' SUCCESS: 2024-05-15 11:02:05: …snapshot for 'opt' removed successfully INFO: 2024-05-15 11:02:05: …removing LVM snapshot for 'u01' SUCCESS: 2024-05-15 11:02:06: …snapshot for 'u01' removed successfully INFO: 2024-05-15 11:02:06: …removing LVM snapshot for 'root' SUCCESS: 2024-05-15 11:02:06: …snapshot for 'root' removed successfully SUCCESS: 2024-05-15 11:02:06: Remove LVM snapshots done successfully
[root@phanes ~]# /opt/odabr/odabr infosnap
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ odabr - ODA node Backup Restore - Version: 2.0.1-72 Copyright 2013, 2023, 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: 2024-05-15 11:02:12: LVM snapshot for 'root' does not exist WARNING: 2024-05-15 11:02:12: LVM snapshot for 'opt' does not exist WARNING: 2024-05-15 11:02:13: LVM snapshot for 'u01' does not exist
[root@phanes ~]#
Patch the storage Run a prepatch report
[root@phanes ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport -st -v 19.22.0.0.0
Job details
ID: de0ba736-bea2-4de4-b35d-e36e8a3bf450
Description: Patch pre-checks for [STORAGE]
Status: Created
Created: May 15, 2024 11:19:55 AM CEST
Message: Use 'odacli describe-prepatchreport -i de0ba736-bea2-4de4-b35d-e36e8a3bf450' to check details of results
Task Name Start Time End Time Status —————————————- —————————————- —————————————- —————-
[root@phanes ~]#
Validate the output
[root@phanes ~]# odacli describe-prepatchreport -i de0ba736-bea2-4de4-b35d-e36e8a3bf450
Patch pre-check report
Job ID: de0ba736-bea2-4de4-b35d-e36e8a3bf450
Description: Patch pre-checks for [STORAGE]
Status: SUCCESS
Created: May 15, 2024 11:19:55 AM CEST
Result: All pre-checks succeeded
Node Name
phanes
Pre-Check Status Comments —————————— ——– ————————————– STORAGE Validate patching tag Success Validated patching tag: 19.22.0.0.0. Patch location validation Success Verified patch location Patch tag validation Success Verified patch tag Storage patch tag validation Success Verified storage patch location Verify ASM disks status Success ASM disks are online Validate command execution Success Validated command execution
[root@phanes ~]#
If no error, than run the storage patch
[root@phanes ~]# /opt/oracle/dcs/bin/odacli update-storage -v 19.22.0.0.0 {
"jobId" : "1b6a7023-0822-49c6-acb4-411064724e09", "status" : "Created", "message" : "Success of Storage Update may trigger reboot of node after 4-5 minutes. Please wait till node restart", "reports" : [ ], "createTimestamp" : "May 15, 2024 11:21:47 AM CEST", "resourceList" : [ ], "description" : "Storage Firmware Patching", "updatedTime" : "May 15, 2024 11:21:47 AM CEST", "jobType" : null
} [root@phanes ~]#
Check the result
[root@phanes ~]# odacli describe-job -i “1b6a7023-0822-49c6-acb4-411064724e09”
Job details
ID: 1b6a7023-0822-49c6-acb4-411064724e09
Description: Storage Firmware Patching
Status: Success
Created: May 15, 2024 11:21:47 AM CEST
Message:
Task Name Start Time End Time Status —————————————- —————————————- —————————————- —————- Applying Firmware Disk Patches May 15, 2024 11:21:50 AM CEST May 15, 2024 11:21:53 AM CEST Success Generating and saving BOM May 15, 2024 11:21:53 AM CEST May 15, 2024 11:22:20 AM CEST Success PreRebootNode Actions May 15, 2024 11:22:20 AM CEST May 15, 2024 11:22:20 AM CEST Success Reboot Ilom May 15, 2024 11:22:20 AM CEST May 15, 2024 11:22:20 AM CEST Success
[root@phanes ~]#
Patch databases First list the dbhomes
[root@phanes ~]# odacli list-dbhomes ID Name DB Version DB Edition Home Location Status —————————————- ——————– ——————– ———- ——————————————————– ———- 10d35634-771c-4f07-9389-638f191ca1b8 OraDB19000_home1 19.21.0.0.231017 EE /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1 CONFIGURED ff400f69-1355-449d-80de-c25c6039ac94 OraDB19000_home2 19.22.0.0.240116 EE /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_2 CONFIGURED [root@phanes ~]#
Run the prepatch report for the dbhome you want to upgrade
[root@phanes ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport –dbhome –dbhomeid 10d35634-771c-4f07-9389-638f191ca1b8 -v 19.22.0.0.0
Job details
ID: 8d3cda1a-c2a8-4bef-a93c-ae9ae0deb5e6
Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home1
Status: Created
Created: May 15, 2024 11:31:30 AM CEST
Message: Use 'odacli describe-prepatchreport -i 8d3cda1a-c2a8-4bef-a93c-ae9ae0deb5e6' to check details of results
Task Name Start Time End Time Status —————————————- —————————————- —————————————- —————-
[root@phanes ~]#
Check the report
[root@phanes ~]# odacli describe-prepatchreport -i 8d3cda1a-c2a8-4bef-a93c-ae9ae0deb5e6
Patch pre-check report
Job ID: 8d3cda1a-c2a8-4bef-a93c-ae9ae0deb5e6
Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home1
Status: SUCCESS
Created: May 15, 2024 11:31:30 AM CEST
Result: All pre-checks succeeded
Node Name
phanes
Pre-Check Status Comments —————————— ——– ————————————– DB Validate DB Home ID Success Validated DB Home ID:
10d35634-771c-4f07-9389-638f191ca1b8
Validate patching tag Success Validated patching tag: 19.22.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 Validate dbHomesOnACFS Success User has configured disk group for configured Database homes on ACFS Validate Oracle base Success Successfully validated Oracle Base Is DB clone available Success Successfully validated clone file
exists
Evaluate DBHome patching with Success Successfully validated updating RHP dbhome with RHP. and local patching
is possible
Validate command execution Success Validated command execution
ORACHK Running orachk Success Successfully ran Orachk Validate command execution Success Validated command execution
[root@phanes ~]#
[root@phanes ~]# /opt/oracle/dcs/bin/odacli update-dbhome -i 10d35634-771c-4f07-9389-638f191ca1b8 -v 19.22.0.0.0 {
"jobId" : "d3ea8afa-d48b-4503-aeb1-3f59d97fc194", "status" : "Created", "message" : null, "reports" : [ ], "createTimestamp" : "May 15, 2024 11:48:38 AM CEST", "resourceList" : [ ], "description" : "DB Home Patching: Home ID is 10d35634-771c-4f07-9389-638f191ca1b8", "updatedTime" : "May 15, 2024 11:48:38 AM CEST", "jobType" : null
} [root@phanes ~]#
Validate that the job is fine
[root@phanes ~]# odacli describe-job -i “d3ea8afa-d48b-4503-aeb1-3f59d97fc194”
Job details
ID: d3ea8afa-d48b-4503-aeb1-3f59d97fc194
Description: DB Home Patching: Home ID is 10d35634-771c-4f07-9389-638f191ca1b8
Status: Success
Created: May 15, 2024 11:48:38 AM CEST
Message:
Task Name Start Time End Time Status —————————————- —————————————- —————————————- —————- Creating ACFS database home May 15, 2024 11:48:56 AM CEST May 15, 2024 11:48:56 AM CEST Success Validating dbHome available space May 15, 2024 11:48:56 AM CEST May 15, 2024 11:48:57 AM CEST Success Creating DbHome Directory May 15, 2024 11:48:57 AM CEST May 15, 2024 11:48:57 AM CEST Success Create required directories May 15, 2024 11:48:57 AM CEST May 15, 2024 11:48:57 AM CEST Success Extract DB clone May 15, 2024 11:48:57 AM CEST May 15, 2024 11:50:07 AM CEST Success ProvDbHome by using RHP May 15, 2024 11:50:07 AM CEST May 15, 2024 11:51:25 AM CEST Success Enable DB options May 15, 2024 11:51:25 AM CEST May 15, 2024 11:51:39 AM CEST Success Creating wallet for DB Client May 15, 2024 11:51:44 AM CEST May 15, 2024 11:51:44 AM CEST Success Creating wallet for DB Client May 15, 2024 11:52:12 AM CEST May 15, 2024 11:52:12 AM CEST Success Patch databases by RHP - [DBTEST] May 15, 2024 11:52:12 AM CEST May 15, 2024 11:56:34 AM CEST Success Updating database metadata May 15, 2024 11:56:34 AM CEST May 15, 2024 11:56:34 AM CEST Success Set log_archive_dest for Database May 15, 2024 11:56:34 AM CEST May 15, 2024 11:56:37 AM CEST Success Update System version May 15, 2024 11:56:37 AM CEST May 15, 2024 11:56:37 AM CEST Success Generating and saving BOM May 15, 2024 11:56:37 AM CEST May 15, 2024 11:57:18 AM CEST Success TDE parameter update May 15, 2024 11:58:02 AM CEST May 15, 2024 11:58:02 AM CEST Success
[root@phanes ~]#