meta données pour cette page
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 a 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, then 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 ~]#
- if success, then launch the patching
[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 ~]#