ODA Upgrade 19.x to 19.10
Today I’m bringing an article with the steps to upgrade the ODA version to 19.10.
Before starting, we must check the minimum release so that we can perform the upgrade successfully.
https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.10/cmtrn/oda-patches.html#GUID-220DA05B-0F52-4EDA-84C9-BFD15F43802D
Before starting the patches, ensure that you have enough space on /, /u01, and /opt filesystems.
1. Backup snapshot from ODA
root@oda-duts-01 / # /opt/odabr/odabr backup -snap -osize 35 -rsize 20 -usize 60
INFO: 2021-07-01 10:58:35: Please check the logfile '/opt/odabr/out/log/odabr_53053.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
odabr - ODA node Backup Restore - Version: 2.0.1-58
Copyright Oracle, Inc. 2013, 2020
--------------------------------------------------------
Author: Ruggero Citton <[email protected]>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2021-07-01 10:58:35: Checking superuser
INFO: 2021-07-01 10:58:35: Checking Bare Metal
INFO: 2021-07-01 10:58:35: Removing existing LVM snapshots
WARNING: 2021-07-01 10:58:36: LVM snapshot for 'opt' does not exist
WARNING: 2021-07-01 10:58:36: LVM snapshot for 'u01' does not exist
WARNING: 2021-07-01 10:58:36: LVM snapshot for 'root' does not exist
INFO: 2021-07-01 10:58:36: Checking LVM size
INFO: 2021-07-01 10:58:36: Boot device backup
INFO: 2021-07-01 10:58:36: Getting EFI device
INFO: 2021-07-01 10:58:36: ...step1 - unmounting EFI
INFO: 2021-07-01 10:58:36: ...step2 - making efi device backup
SUCCESS: 2021-07-01 10:58:40: ...EFI device backup saved as '/opt/odabr/out/hbi/efi.img'
INFO: 2021-07-01 10:58:40: ...step3 - checking EFI device backup
INFO: 2021-07-01 10:58:40: Getting boot device
INFO: 2021-07-01 10:58:40: ...step1 - making boot device backup using tar
SUCCESS: 2021-07-01 10:58:45: ...boot content saved as '/opt/odabr/out/hbi/boot.tar.gz'
INFO: 2021-07-01 10:58:45: ...step2 - unmounting boot
INFO: 2021-07-01 10:58:45: ...step3 - making boot device backup using dd
SUCCESS: 2021-07-01 10:58:50: ...boot device backup saved as '/opt/odabr/out/hbi/boot.img'
INFO: 2021-07-01 10:58:50: ...step4 - mounting boot
INFO: 2021-07-01 10:58:50: ...step5 - mounting EFI
INFO: 2021-07-01 10:58:50: ...step6 - checking boot device backup
INFO: 2021-07-01 10:58:51: OCR backup
INFO: 2021-07-01 10:58:53: ...ocr backup saved as '/opt/odabr/out/hbi/ocrbackup_53053.bck'
INFO: 2021-07-01 10:58:53: Making LVM snapshot backup
SUCCESS: 2021-07-01 10:58:53: ...snapshot backup for 'opt' created successfully
SUCCESS: 2021-07-01 10:58:55: ...snapshot backup for 'u01' created successfully
SUCCESS: 2021-07-01 10:58:55: ...snapshot backup for 'root' created successfully
SUCCESS: 2021-07-01 10:58:55: LVM snapshots backup done successfully
root@oda-duts-01 / # /opt/odabr/odabr infosnap
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
odabr - ODA node Backup Restore - Version: 2.0.1-58
Copyright Oracle, Inc. 2013, 2020
--------------------------------------------------------
Author: Ruggero Citton <[email protected]>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
LVM snap name Status COW Size Data%
------------- ---------- ---------- ------
root_snap active 20.00 GiB 0.01%
opt_snap active 35.00 GiB 0.01%
u01_snap active 60.00 GiB 0.01%
2. Unzip and update the repository
For the patch of the server, you will need the following patches ( to be downloaded from support.oracle.com)
-p32351355_1910000_Linux-x86-64_1of2.zip
-p32351355_1910000_Linux-x86-64_2of2.zip
The steps are the following. All actions can be found in the documentation
2.1 Unpack the two files and then copy them to the oda-duts-01
root@oda-duts-01 /backups # cd patches/
root@oda-duts-01 /backups/patches # ll
total 23037662
-rw-r--r-- 1 root root 3035715218 May 25 10:07 p23494997_1910000_Linux-x86-64.zip
-rw-r--r-- 1 root root 11467982793 May 25 11:18 p32351355_1910000_Linux-x86-64_1of2.zip
-rw-r--r-- 1 root root 9086867187 May 25 09:53 p32351355_1910000_Linux-x86-64_2of2.zip
root@oda-duts-01 /backups/patches # unzip p32351355_1910000_Linux-x86-64_1of2.zip
Archive: p32351355_1910000_Linux-x86-64_1of2.zip
extracting: oda-sm-19.10.0.0.0-210222.4-server1of2.zip
inflating: README.txt
root@oda-duts-01 /backups/patches # unzip p32351355_1910000_Linux-x86-64_2of2.zip
Archive: p32351355_1910000_Linux-x86-64_2of2.zip
extracting: oda-sm-19.10.0.0.0-210222.4-server2of2.zip
root@oda-duts-01 /backups/patches # ll
total 43110758
-rw-r--r-- 1 root root 11467982139 Mar 20 22:40 oda-sm-19.10.0.0.0-210222.4-server1of2.zip
-rw-r--r-- 1 root root 9086866837 Mar 20 23:02 oda-sm-19.10.0.0.0-210222.4-server2of2.zip
-rw-r--r-- 1 root root 3035715218 May 25 10:07 p23494997_1910000_Linux-x86-64.zip
-rw-r--r-- 1 root root 11467982793 May 25 11:18 p32351355_1910000_Linux-x86-64_1of2.zip
-rw-r--r-- 1 root root 9086867187 May 25 09:53 p32351355_1910000_Linux-x86-64_2of2.zip
-rwxr-xr-x 1 root root 191 Feb 24 02:17 README.txt
You have new mail in /var/spool/mail/root
root@oda-duts-01 /backups/patches # ll -ltr
total 43110758
-rwxr-xr-x 1 root root 191 Feb 24 02:17 README.txt
-rw-r--r-- 1 root root 11467982139 Mar 20 22:40 oda-sm-19.10.0.0.0-210222.4-server1of2.zip
-rw-r--r-- 1 root root 9086866837 Mar 20 23:02 oda-sm-19.10.0.0.0-210222.4-server2of2.zip
-rw-r--r-- 1 root root 9086867187 May 25 09:53 p32351355_1910000_Linux-x86-64_2of2.zip
-rw-r--r-- 1 root root 3035715218 May 25 10:07 p23494997_1910000_Linux-x86-64.zip
-rw-r--r-- 1 root root 11467982793 May 25 11:18 p32351355_1910000_Linux-x86-64_1of2.zip
You have new mail in /var/spool/mail/root
2.2 Update the repository with the 2 files
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-repository -f /backups/patches/oda-sm-19.10.0.0.0-210222.4-server1of2.zip
{
"jobId" : "ff6d6ad4-de02-432b-b62e-5986146a8eee",
"status" : "Created",
"message" : "/backups/patches/oda-sm-19.10.0.0.0-210222.4-server1of2.zip",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 11:55:02 AM CEST",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "Jul 01, 2021 11:55:02 AM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i ff6d6ad4-de02-432b-b62e-5986146a8eee
Job details
----------------------------------------------------------------
ID: ff6d6ad4-de02-432b-b62e-5986146a8eee
Description: Repository Update
Status: Running
Created: Jul 01, 2021 11:55:02 AM CEST
Message: /backups/patches/oda-sm-19.10.0.0.0-210222.4-server1of2.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Job details
----------------------------------------------------------------
ID: ff6d6ad4-de02-432b-b62e-5986146a8eee
Description: Repository Update
Status: Success
Created: Jul 01, 2021 11:55:02 AM CEST
Message: /backups/patches/oda-sm-19.10.0.0.0-210222.4-server1of2.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
root@oda-duts-01 /backups/patches #
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-repository -f /backups/patches/oda-sm-19.10.0.0.0-210222.4-server2of2.zip
{
"jobId" : "e07fb8f3-e937-44b9-8934-7c1343b1b3ef",
"status" : "Created",
"message" : "/backups/patches/oda-sm-19.10.0.0.0-210222.4-server2of2.zip",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 11:59:48 AM CEST",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "Jul 01, 2021 11:59:48 AM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i e07fb8f3-e937-44b9-8934-7c1343b1b3ef
Job details
----------------------------------------------------------------
ID: e07fb8f3-e937-44b9-8934-7c1343b1b3ef
Description: Repository Update
Status: Running
Created: Jul 01, 2021 11:59:48 AM CEST
Message: /backups/patches/oda-sm-19.10.0.0.0-210222.4-server2of2.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
root@oda-duts-01 /backups/patches # odacli describe-job -i e07fb8f3-e937-44b9-8934-7c1343b1b3ef
Job details
----------------------------------------------------------------
ID: e07fb8f3-e937-44b9-8934-7c1343b1b3ef
Description: Repository Update
Status: Success
Created: Jul 01, 2021 11:59:48 AM CEST
Message: /backups/patches/oda-sm-19.10.0.0.0-210222.4-server2of2.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
After the update of the repository, you can remove the two files to save space.
3. Update the DCS admin
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.10.0.0.0
{
"jobId" : "03c4fb7f-5de6-425b-bb63-0663180ae488",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 12:04:50 PM CEST",
"resourceList" : [ ],
"description" : "DcsAdmin patching",
"updatedTime" : "Jul 01, 2021 12:04:50 PM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i 03c4fb7f-5de6-425b-bb63-0663180ae488
Job details
----------------------------------------------------------------
ID: 03c4fb7f-5de6-425b-bb63-0663180ae488
Description: DcsAdmin patching
Status: Success
Created: Jul 01, 2021 12:04:50 PM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Patch location validation Jul 01, 2021 12:04:51 PM CEST Jul 01, 2021 12:04:51 PM CEST Success
dcsadmin upgrade Jul 01, 2021 12:04:51 PM CEST Jul 01, 2021 12:04:52 PM CEST Success
Update System version Jul 01, 2021 12:04:57 PM CEST Jul 01, 2021 12:04:57 PM CEST Success
4. Update the DCS components
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.10.0.0.0
{
"jobId" : "672e3572-db10-48ea-b737-ae075793c3bb",
"status" : "Success",
"message" : "Update-dcscomponents is successful on all the node(s):DCS-Agent shutdown is successful. MySQL upgrade is successful. Timezone is set successfully. Metadata migration is successful. Agent rpm upgrade is successful. DCS-CLI rpm upgrade is successful. DCS-C",
"reports" : null,
"createTimestamp" : "Jul 01, 2021 12:07:17 PM CEST",
"description" : "Update-dcscomponents job completed and is not part of Agent job list",
"updatedTime" : "Jul 01, 2021 12:09:59 PM CEST"
}
root@oda-duts-01 /backups/patches #
5. Update the DCS agent
The command below may take some time, as specified in the documentation. So be patient and wait. This command updates the Zookeeper, installs MySQL, migrates metadata from Derby to MySQL, and updates other DCS components such as the DCS Agent, DCS CLI, and DCS Controller on Oracle Database Appliance.
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.10.0.0.0
{
"jobId" : "71637667-3dea-4ac4-a2dd-5d9e7726874a",
"status" : "Created",
"message": "Dcs agent will be restarted after the update. Please wait for 2-3 mins before executing the other commands",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 12:12:01 PM CEST",
"resourceList" : [ ],
"description" : "DcsAgent patching",
"updatedTime" : "Jul 01, 2021 12:12:01 PM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i "71637667-3dea-4ac4-a2dd-5d9e7726874a"
root@oda-duts-01 /backups/patches # odacli describe-job -i "71637667-3dea-4ac4-a2dd-5d9e7726874a"
Job details
----------------------------------------------------------------
ID: 71637667-3dea-4ac4-a2dd-5d9e7726874a
Description: DcsAgent patching
Status: Running
Created: Jul 01, 2021 12:12:01 PM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
dcs-agent upgrade to version 19.10.0.0.0 Jul 01, 2021 12:12:01 PM CEST Jul 01, 2021 12:12:01 PM CEST Running
root@oda-duts-01 /backups/patches # odacli describe-job -i "71637667-3dea-4ac4-a2dd-5d9e7726874a"
Job details
----------------------------------------------------------------
ID: 71637667-3dea-4ac4-a2dd-5d9e7726874a
Description: DcsAgent patching
Status: Success
Created: Jul 01, 2021 12:12:01 PM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
dcs-agent upgrade to version 19.10.0.0.0 Jul 01, 2021 12:12:01 PM CEST Jul 01, 2021 12:13:36 PM CEST Success
Update System version Jul 01, 2021 12:13:36 PM CEST Jul 01, 2021 12:13:36 PM CEST Success
6. Create a precheck report
Before updating the server, we run the prechecks
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli create-prepatchreport -s -v 19.10.0.0.0
Job details
----------------------------------------------------------------
ID: a3569c92-beef-46a6-b36d-d7d8c7fb6066
Description: Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER]
Status: Created
Created: Jul 01, 2021 12:15:39 PM CEST
Message: Use 'odacli describe-prepatchreport -i a3569c92-beef-46a6-b36d-d7d8c7fb6066' to check details of results
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
root@oda-duts-01 /backups/patches # odacli describe-prepatchreport -i 9d93bb8b-9ede-4deb-9f2d-7c16a2d5abfa
Patch pre-check report
------------------------------------------------------------------------
Job ID: 9d93bb8b-9ede-4deb-9f2d-7c16a2d5abfa
Description: Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER]
Status: FAILED
Created: Jul 01, 2021 1:11:54 PM CEST
Result: One or more pre-checks failed for [ORACHK]
Node Name
---------------
oda-duts-01
Pre-Check Status Comments
------------------------------ -------- --------------------------------------
__OS__
Validate supported versions Success Validated minimum supported versions.
Validate patching tag Success Validated patching tag: 19.10.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.10.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.10.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 GI patch metadata Success Validated patching tag: 19.10.0.0.0.
Is patch location available Success Patch location is available.
Patch location validation Success Successfully validated location
Patch verification Success Patches 32218454 not applied on GI
home /u01/app/19.0.0.0/grid on node
oda-duts-01
Validate Opatch update Success Successfully updated the opatch in
GiHome /u01/app/19.0.0.0/grid on node
oda-duts-01
Patch conflict check Success No patch conflicts found on GiHome
/u01/app/19.0.0.0/grid on node
oda-duts-01
Validate command execution Success Validated command execution
__ORACHK__
Running orachk Failed Orachk validation failed: .
Validate command execution Success Validated command execution
Verify the vm.min_free_kbytes Failed AHF-4819: The vm.min_free_kbytes
configuration configuration is not set as
recommended
Software home Failed Software home check failed
In the results, we can see that there are some errors due to orachk. Based on the following document:
https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.10/cmtrn/issues-with-oda-odacli.html#GUID-F2B10F21-3D1E-4328-8E9B-D75AD38D26A1
Oracle sends the information to ignore the errors and then continue with updating the server.
7. Apply the server update
As we ignore the error, we use the flag sko for the patching
root@oda-duts-01 /backups/patches # /opt/oracle/dcs/bin/odacli update-server -v 19.10.0.0.0 -sko
{
"jobId" : "59bbb6d2-bf6e-451a-8a4e-1de86c490d26",
"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" : "Jul 01, 2021 20:23:54 PM CEST",
"resourceList" : [ ],
"description" : "Server Patching",
"updatedTime" : "Jul 01, 2021 20:23:54 PM CEST"
}
root@oda-duts-01 ~ # odacli describe-job -i "59bbb6d2-bf6e-451a-8a4e-1de86c490d26"
Job details
----------------------------------------------------------------
ID: 59bbb6d2-bf6e-451a-8a4e-1de86c490d26
Description: Server Patching
Status: Success
Created: Jul 01, 2021 8:24:34 PM CEST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Patch location validation Jul 01, 2021 8:24:41 PM CEST Jul 01, 2021 8:24:41 PM CEST Success
dcs-controller upgrade Jul 01, 2021 8:24:42 PM CEST Jul 01, 2021 8:24:42 PM CEST Success
Creating repositories using yum Jul 01, 2021 8:24:43 PM CEST Jul 01, 2021 8:24:46 PM CEST Success
Updating YumPluginVersionLock rpm Jul 01, 2021 8:24:46 PM CEST Jul 01, 2021 8:24:46 PM CEST Success
Applying OS Patches Jul 01, 2021 8:24:46 PM CEST Jul 01, 2021 8:24:47 PM CEST Success
Creating repositories using yum Jul 01, 2021 8:24:47 PM CEST Jul 01, 2021 8:24:47 PM CEST Success
Applying HMP Patches Jul 01, 2021 8:24:47 PM CEST Jul 01, 2021 8:24:48 PM CEST Success
Client root Set up Jul 01, 2021 8:24:48 PM CEST Jul 01, 2021 8:24:48 PM CEST Success
Client grid Set up Jul 01, 2021 8:24:48 PM CEST Jul 01, 2021 8:24:48 PM CEST Success
Patch location validation Jul 01, 2021 8:24:48 PM CEST Jul 01, 2021 8:24:48 PM CEST Success
oda-hw-mgmt upgrade Jul 01, 2021 8:24:49 PM CEST Jul 01, 2021 8:24:49 PM CEST Success
OSS Patching Jul 01, 2021 8:24:50 PM CEST Jul 01, 2021 8:24:50 PM CEST Success
Applying Firmware Disk Patches Jul 01, 2021 8:24:50 PM CEST Jul 01, 2021 8:24:53 PM CEST Success
Applying Firmware Controller Patches Jul 01, 2021 8:24:53 PM CEST Jul 01, 2021 8:24:55 PM CEST Success
Checking Ilom patch Version Jul 01, 2021 8:24:55 PM CEST Jul 01, 2021 8:24:55 PM CEST Success
Patch location validation Jul 01, 2021 8:24:55 PM CEST Jul 01, 2021 8:24:56 PM CEST Success
Save password in Wallet Jul 01, 2021 8:24:56 PM CEST Jul 01, 2021 8:24:56 PM CEST Success
Apply Ilom patch Jul 01, 2021 8:24:56 PM CEST Jul 01, 2021 8:24:56 PM CEST Success
Copying Flash Bios to Temp location Jul 01, 2021 8:24:56 PM CEST Jul 01, 2021 8:24:56 PM CEST Success
Starting the clusterware Jul 01, 2021 8:24:59 PM CEST Jul 01, 2021 8:24:59 PM CEST Success
clusterware patch verification Jul 01, 2021 8:24:59 PM CEST Jul 01, 2021 8:25:01 PM CEST Success
Patch location validation Jul 01, 2021 8:25:01 PM CEST Jul 01, 2021 8:25:01 PM CEST Success
Opatch update Jul 01, 2021 8:26:32 PM CEST Jul 01, 2021 8:26:36 PM CEST Success
Patch conflict check Jul 01, 2021 8:26:36 PM CEST Jul 01, 2021 8:27:29 PM CEST Success
clusterware upgrade Jul 01, 2021 8:27:34 PM CEST Jul 01, 2021 9:04:18 PM CEST Success
Updating GiHome version Jul 01, 2021 9:04:18 PM CEST Jul 01, 2021 9:04:21 PM CEST Success
Starting the clusterware Jul 01, 2021 9:05:25 PM CEST Jul 01, 2021 9:05:25 PM CEST Success
remove network public interface Jul 01, 2021 9:05:25 PM CEST Jul 01, 2021 9:05:28 PM CEST Success
create bridge network Jul 01, 2021 9:05:28 PM CEST Jul 01, 2021 9:05:33 PM CEST Success
modify network public interface Jul 01, 2021 9:05:33 PM CEST Jul 01, 2021 9:05:34 PM CEST Success
Update System version Jul 01, 2021 9:05:35 PM CEST Jul 01, 2021 9:05:35 PM CEST Success
Cleanup JRE Home Jul 01, 2021 9:05:35 PM CEST Jul 01, 2021 9:05:35 PM CEST Success
Add SYSNAME in Env Jul 01, 2021 9:05:35 PM CEST Jul 01, 2021 9:05:35 PM CEST Success
Setting ACL for disk groups Jul 01, 2021 9:05:35 PM CEST Jul 01, 2021 9:05:38 PM CEST Success
preRebootNode Actions Jul 01, 2021 9:05:44 PM CEST Jul 01, 2021 9:06:30 PM CEST Success
Reboot Ilom Jul 01, 2021 9:06:30 PM CEST Jul 01, 2021 9:06:30 PM CEST Success
We can confirm this by running the following command
root@oda-duts-01 ~ # odacli describe-component
System Version
---------------
19.10.0.0.0
System node Name
---------------
oda-duts-01
Local System Version
---------------
19.10.0.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK 19.10.0.0.0 up-to-date
GI 19.10.0.0.210119 up-to-date
DB 11.2.0.4.200414 11.2.0.4.210119
DCSAGENT 19.10.0.0.0 up-to-date
OS 7.9 up-to-date
ILOM 5.0.1.21.a.r138015 up-to-date
BIOS 41080800 up-to-date
FIRMWARECONTROLLER QDV1RF30 up-to-date
FIRMWAREDISK 0121 up-to-date
HMP 2.4.7.0.1 up-to-date
8. Update the existing dbhomes
root@oda-duts-01 ~ # odacli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
7c724f57-a495-4db9-a88a-48323f3632c6 OraDB11204_home1 11.2.0.4.200414 /u01/app/oracle/product/11.2.0.4/dbhome_1 CONFIGURED
root@oda-duts-01 ~ # odacli create-prepatchreport --dbhome --dbhomeid 7c724f57-a495-4db9-a88a-48323f3632c6 -v 19.10.0.0.0
root@oda-duts-01 ~ # odacli update-dbhome --dbhomeid 7c724f57-a495-4db9-a88a-48323f3632c6 -v 19.10.0.0.0 -sko
{
"jobId" : "cf0d4064-1eb2-4b9a-8653-41fe1f06f98a",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 21:26:05 PM CEST",
"resourceList" : [ ],
"description" : "DB Home Patching: Home Id is 7c724f57-a495-4db9-a88a-48323f3632c6",
"updatedTime" : "Jul 01, 2021 21:26:05 PM CEST"
}
root@oda-duts-01 ~ #
root@oda-duts-01 ~ #
root@oda-duts-01 ~ # odacli describe-job -i "cf0d4064-1eb2-4b9a-8653-41fe1f06f98a"
Job details
----------------------------------------------------------------
ID: cf0d4064-1eb2-4b9a-8653-41fe1f06f98a
Description: DB Home Patching: Home Id is 7c724f57-a495-4db9-a88a-48323f3632c6
Status: Success
Created: Jul 01, 2021 9:26:05 PM CEST
Message: Success
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
clusterware patch verification Jul 01, 2021 9:26:19 PM CEST Jul 01, 2021 9:26:21 PM CEST Success
Patch conflict check Jul 01, 2021 9:26:21 PM CEST Jul 01, 2021 9:26:21 PM CEST Success
Patch location validation Jul 01, 2021 9:26:21 PM CEST Jul 01, 2021 9:26:21 PM CEST Success
Opatch update Jul 01, 2021 9:27:13 PM CEST Jul 01, 2021 9:27:17 PM CEST Success
Patch conflict check Jul 01, 2021 9:27:17 PM CEST Jul 01, 2021 9:27:30 PM CEST Success
Creating wallet for DB Client Jul 01, 2021 9:27:58 PM CEST Jul 01, 2021 9:28:03 PM CEST Success
db upgrade Jul 01, 2021 9:28:03 PM CEST Jul 01, 2021 9:30:06 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:06 PM CEST Jul 01, 2021 9:30:07 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:07 PM CEST Jul 01, 2021 9:30:08 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:08 PM CEST Jul 01, 2021 9:30:09 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:09 PM CEST Jul 01, 2021 9:30:10 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:10 PM CEST Jul 01, 2021 9:30:11 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:11 PM CEST Jul 01, 2021 9:30:12 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:12 PM CEST Jul 01, 2021 9:30:13 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:13 PM CEST Jul 01, 2021 9:30:14 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:14 PM CEST Jul 01, 2021 9:30:15 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:15 PM CEST Jul 01, 2021 9:30:16 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:17 PM CEST Jul 01, 2021 9:30:18 PM CEST Success
SqlPatch upgrade Jul 01, 2021 9:30:18 PM CEST Jul 01, 2021 9:30:19 PM CEST Success
Update System version Jul 01, 2021 9:30:19 PM CEST Jul 01, 2021 9:30:19 PM CEST Success
updating the Database version Jul 01, 2021 9:30:21 PM CEST Jul 01, 2021 9:30:22 PM CEST Success
updating the Database version Jul 01, 2021 9:30:22 PM CEST Jul 01, 2021 9:30:24 PM CEST Success
updating the Database version Jul 01, 2021 9:30:24 PM CEST Jul 01, 2021 9:30:26 PM CEST Success
updating the Database version Jul 01, 2021 9:30:26 PM CEST Jul 01, 2021 9:30:28 PM CEST Success
updating the Database version Jul 01, 2021 9:30:28 PM CEST Jul 01, 2021 9:30:30 PM CEST Success
updating the Database version Jul 01, 2021 9:30:30 PM CEST Jul 01, 2021 9:30:32 PM CEST Success
updating the Database version Jul 01, 2021 9:30:32 PM CEST Jul 01, 2021 9:30:34 PM CEST Success
updating the Database version Jul 01, 2021 9:30:34 PM CEST Jul 01, 2021 9:30:36 PM CEST Success
updating the Database version Jul 01, 2021 9:30:36 PM CEST Jul 01, 2021 9:30:38 PM CEST Success
updating the Database version Jul 01, 2021 9:30:38 PM CEST Jul 01, 2021 9:30:40 PM CEST Success
updating the Database version Jul 01, 2021 9:30:40 PM CEST Jul 01, 2021 9:30:41 PM CEST Success
updating the Database version Jul 01, 2021 9:30:41 PM CEST Jul 01, 2021 9:30:43 PM CEST Success
You have new mail in /var/spool/mail/root
Now that the patch was successful, we can delete the snapshots we took with odabr
root@oda-duts-01 ~ # /opt/odabr/odabr delsnap
INFO: 2021-07-01 21:33:02: Please check the logfile '/opt/odabr/out/log/odabr_48818.log' for more details
INFO: 2021-07-01 21:33:02: Removing LVM snapshots
INFO: 2021-07-01 21:33:02: ...removing LVM snapshot for 'opt'
SUCCESS: 2021-07-01 21:33:03: ...snapshot for 'opt' removed successfully
INFO: 2021-07-01 21:33:03: ...removing LVM snapshot for 'u01'
SUCCESS: 2021-07-01 21:33:03: ...snapshot for 'u01' removed successfully
INFO: 2021-07-01 21:33:03: ...removing LVM snapshot for 'root'
SUCCESS: 2021-07-01 21:33:03: ...snapshot for 'root' removed successfully
SUCCESS: 2021-07-01 21:33:03: Remove LVM snapshots done successfully
root@oda-duts-01 ~ #
9. Update the repository with the RDBMS clone 19.10
The last step is to update the repository with the RDBMS clone 19.10. For this, download the patch p23494997_1910000_Linux-x86-64.zip. And then unpack the file and run the command
root@oda-duts-01 /backups/patches # odacli update-repository -f /backups/patches/odacli-dcs-19.10.0.0.0-210115-DB-11.2.0.4.zip
{
"jobId" : "9e5124ef-670a-41a5-9135-4f1688cad2b7",
"status" : "Created",
"message" : "/backups/patches/odacli-dcs-19.10.0.0.0-210115-DB-11.2.0.4.zip",
"reports" : [ ],
"createTimestamp" : "Jul 01, 2021 21:38:53 PM CEST",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "Jul 01, 2021 21:38:53 PM CEST"
}
root@oda-duts-01 /backups/patches # odacli describe-job -i "9e5124ef-670a-41a5-9135-4f1688cad2b7"
Job details
----------------------------------------------------------------
ID: 9e5124ef-670a-41a5-9135-4f1688cad2b7
Description: Repository Update
Status: Running
Created: Jul 01, 2021 9:38:53 PM CEST
Message: /backups/patches/odacli-dcs-19.10.0.0.0-210115-DB-11.2.0.4.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle Jul 01, 2021 9:38:53 PM CEST Jul 01, 2021 9:38:53 PM CEST Running
root@oda-duts-01 /backups/patches # odacli describe-job -i "9e5124ef-670a-41a5-9135-4f1688cad2b7"
Job details
----------------------------------------------------------------
ID: 9e5124ef-670a-41a5-9135-4f1688cad2b7
Description: Repository Update
Status: Success
Created: Jul 01, 2021 9:38:53 PM CEST
Message: /backups/patches/odacli-dcs-19.10.0.0.0-210115-DB-11.2.0.4.zip
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Unzip bundle Jul 01, 2021 9:38:53 PM CEST Jul 01, 2021 9:39:36 PM CEST Success
I hope this helps you!!!
Stay tuned, following on twitter @aontalba and on Linkedin
André Ontalba
Disclaimer: “The postings on this site are my own and don’t necessarily represent my actual employer positions, strategies or opinions. The information here was edited to be useful for general purposes. Specific data and identifications were removed to allow reach generic audience and be useful.”
