ODA Patching from version 19.21 to 19.23
This document will help you in ODA patching to upgrade from
version 19.21 to version 19.23
If we have ODA box with version 19.17 then we cannot
directly patch it to 19.23 version. We must patch the ODA box to version to
19.21 and then we can go on patch 19.23.
To perform ODA patching VM snapshots and RMAN backup is most
important; if anything fails then we can restore VMs from the snapshot.
1. Download 19.23 patches from Oracle site:
Patch list:
|
Oracle Database Appliance
Server Patch for the ODACLI/DCS stack (patch 36524605), |
||||
|
Oracle Grid Infrastructure
clone files (patch 30403673), |
||||
|
Oracle Database clone files
(patch 30403662) |
||||
2. Login to the Oda bare metal (BM) servers and note down the VMs and DB system details.
#virsh list >>> This command shows VM names
and we will be taking VM snapshots for the same before starting patching
#odacli list-vms >>> This command list VMs
information like VM names, they are active on which node,current state, target
state etc…
3.
Identify the
vdisk assosiated with the respective VM
#virsh domblklist <VM Name>
4. Here we are taking snapshot of vda and vdb disk so note down the size of the vdisk and here we will ignore hda as it is iso
Note: Bring down respective VM before taking snapshot.
5. Create VM snapshot for the both the vdisks
6.
Save the VM snapshot to some NFS location
Actual Patching process:
Before starting the patching process make sure DB and DB system and crs
cluster service should be running.
Run below commands
from BM server
1.
Update repository with server patch
#unzip p35938481_1923000_Linux-x86-64.zip
>>> The zip
file will contain oda-sm-19.23.0.0.0-date-server.zip and readme.html file
2.
Update the repository with the server software
file
# odacli update-repository -f /tmp/oda-sm-19.23.0.0.0-date-server.zip
3.
Confirm that the repository update is successful
# odacli describe-job -i <job_ID> >>> every odacli commands generate some job id
4. Update DCS admin/Components/Agents
4.1
Update DCS admin
# odacli update-dcsadmin -v 19.23.0.0.0
4.2
Update the DCS components
# odacli update-dcscomponents -v 19.23.0.0.0
4.3
Update the DCS agent
#odacli update-dcsagent -v 19.23.0.0.0
5.
Unzip below patches:
Oracle Grid Infrastructure clone files (patch
30403673),
Oracle Database clone files (patch 30403662)
6. Update the repository with the Oracle Grid Infrastructure clone file and the Oracle Database clone file:
# odacli update-repository -f /tmp/odacli-dcs-19.23.0.0.0-date-GI-19.23.0.0.zip
# odacli update-repository -f
/tmp/odacli-dcs-19.23.0.0.0-date-DB-19.23.0.0.zip
7. Create prepatch report for server
# odacli create-prepatchreport -s -v 19.23.0.0.0
8. Verify that the patching pre-checks ran successfully
# odacli describe-prepatchreport -i <job ID>
Note: Fix the warnings and errors mentioned in
the report and proceed with the server patching.
9.
Apply the server
update.
#
/opt/oracle/dcs/bin/odacli update-server -v 19.23.0.0.0
10.
Confirm that the
server update is successful
# /opt/oracle/dcs/bin/odacli
describe-job -i <job_ID>
Run below commands from DB server
11. Update DCS admin/Components/Agents
11.1
Update DCS admin
# odacli update-dcsadmin -v 19.23.0.0.0
11.2
Update the DCS components
# odacli update-dcscomponents -v 19.23.0.0.0
11.3
Update the DCS agent
#odacli update-dcsagent -v 19.23.0.0.0
12. Update the repository with the Oracle Grid Infrastructure clone file and the Oracle Database clone file:
# odacli update-repository -f /tmp/odacli-dcs-19.23.0.0.0-date-GI-19.23.0.0.zip
# odacli update-repository -f
/tmp/odacli-dcs-19.23.0.0.0-date-DB-19.23.0.0.zip
13.
Apply the server
update.
# /opt/oracle/dcs/bin/odacli update-server -v 19.23.0.0.0 >>> verify it by using command “#odacli describe-component”
14.
Create prepatch
report for DB home
# odacli create-prepatchreport --dbhome --dbhomeid
d8307f2e-c126-41da-ab6a-1a7f23c5c074 -v 19.23.0.0.0
We can get dbhome id by using command “#odacli
list-databases”
15.
Verify the pre-patch
report; it should be successful.
Note down the job id and run below command to
verify
#odacli describe-jobs -I <job-id>
16.
Update db_home
# odacli update-dbhome --id d8307f2e-c126-41da-ab6a-1a7f23c5c074 -v 19.23.0.0.0 -f
17. Note down the job id and observe the status; it should be successful.
18.
Verify patching by
using command:
# odacli describe-component >>> we can see here version
19.23
Regards,
Kiren Jadhav
