====== 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
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
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
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
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 ~]#