OCI OEM Installation – (Using Market Place Image)
Introduction Monitoring plays a major part in mission-critical environments. Most businesses depend on IT infrastructure. As the ... Read More
Virtualized ODA Upgrade 18.8.0.0 to 19.8.0.0 – Journey to 12.1.2.12 – 19.13.0.0 – Part 3
Hope previous blog posts were useful to address ODA (Oracle Database Appliance) upgrade issues for the virtualization platforms.
19.13 will be the last upgrade for the virtualized platform, After that oracle going to discontinue OVM and they are moving to KVM-based virtualization. This is going to game changer for ODA for performance.
In this article, I will cover the 19.8.0.0 upgrade steps. I will write another article to cover the issues we encountered during the 18.8.0.0 – 19.8.0.0. This is the major jump for ODA. This is going to be more challenging than other upgrades Mainly because previously we had to tackle mainly grid upgrades. Here we need to upgrade the operating system (OS) from oel6 to oel7. So we need to ensure the OS (Operating System) is stable before moving forward with any other component.
Two major upgrades are:
- OS upgrade OEL 6 to OEL 7.
- Grid update from 18c to 19c.
Journey to move virtualized ODA to 19.8.0.0. We found this below-mentioned plan from looking at the oracle documents link.
https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.8/cmtxn/patching-oda.html
Section 1: Gather ODA Server Information
Find the ODA hardware version.
######### Find ODA version:
[root@ecl-oda-DOM0-0 ~]# ipmitool sunoem cli 'show System' | grep model
model = ODA X5-2
component_model = ORACLE SERVER X5-2
[root@ecl-oda-DOM0-0 ~]#
[root@ecl-oda-DOM0-1 ~]# ps -ef | grep pmon
root 5577 4433 0 13:57 pts/2 00:00:00 grep pmon
[root@ecl-oda-DOM0-1 ~]# ipmitool sunoem cli 'show System' | grep model
model = ODA X5-2
component_model = ORACLE SERVER X5-2
[root@ecl-oda-DOM0-1 ~]
Find the server version:
[root@ecl-odabase-0 delshare]# oakcli show server
Power State : On
Open Problems : 0
Model : ODA X5-2
Type : Rack Mount
Part Number : 33765810+1+1
Serial Number : 1535NMF006
Primary OS : Not Available
ILOM Address : 10.11.99.202
ILOM MAC Address : 00:10:E0:8D:5E:AC
Description : Oracle Database Appliance X5-2 1535NMF006
Locator Light : Off
Actual Power Consumption : 288 watts
Ambient Temperature : 15.750 degree C
Open Problems Report : System is healthyFind hardware version:
[root@ecl-odabase-0 delshare]# oakcli show env_hw
VM-ODA_BASE ODA X5-2
[root@ecl-odabase-0 delshare]#
Check for running VMs and repositories :
If the environment is virtualized you will need to note down the VM names and repository names before patching. These repositories are ACFS mount points, which stores allocated to store the virtual machines and virtual disks.
=======================================
Check the running VMS and respository
=======================================
[root@ecl-odabase-0 PATCH]# oakcli show vm
NAME NODENUM MEMORY VCPU STATE REPOSITORY
kali_server 0 4196M 2 ONLINE kali_test
qualyssrv 0 4196M 2 ONLINE qualys
[root@ecl-odabase-0 PATCH]#
[root@ecl-odabase-0 PATCH]# oakcli show repo
NAME TYPE NODENUM FREE SPACE STATE SIZE
kali_test shared 0 94.78% ONLINE 512000.0M
kali_test shared 1 94.78% ONLINE 512000.0M
odarepo1 local 0 N/A N/A N/A
odarepo2 local 1 N/A N/A N/A
qualys shared 0 98.44% ONLINE 204800.0M
qualys shared 1 98.44% ONLINE 204800.0M
vmdata shared 0 99.99% ONLINE 4068352.0M
vmdata shared 1 N/A UNKNOWN N/A
vmsdev shared 0 99.99% ONLINE 1509376.0M
vmsdev shared 1 N/A UNKNOWN N/A
Find the current ODA version
[root@ecl-odabase-0 ~]# oakcli show version -detail
Reading the metadata. It takes a while...
System Version Component Name Installed Version Supported Version
-------------- --------------- ------------------ -----------------
18.8.0.0.0
Controller_INT 4.650.00-7176 Up-to-date
Controller_EXT 13.00.00.00 Up-to-date
Expander 001E Up-to-date
SSD_SHARED {
[ c1d20,c1d21,c1d22, A29A Up-to-date
c1d23,c1d44,c1d45,c1
d46,c1d47 ]
[ c1d16,c1d17,c1d18, A29A Up-to-date
c1d19,c1d40,c1d41,c1
d42,c1d43 ]
}
HDD_LOCAL A7E0 Up-to-date
HDD_SHARED {
[ c1d24,c1d25,c1d26, A3A0 Up-to-date
c1d27,c1d29,c1d30,c1
d31,c1d32,c1d33,c1d3
4,c1d35,c1d36,c1d37,
c1d38,c1d39 ]
[ c1d0,c1d1,c1d2,c1d PD51 Up-to-date
3,c1d4,c1d5,c1d6,c1d
7,c1d8,c1d9,c1d10,c1
d11,c1d12,c1d13,c1d1
4,c1d15,c1d28 ]
}
ILOM 4.0.4.52 r132805 Up-to-date
BIOS 30300200 Up-to-date
IPMI 1.8.15.0 Up-to-date
HMP 2.4.5.0.1 Up-to-date
OAK 18.8.0.0.0 Up-to-date
OL 6.10 Up-to-date
OVM 3.4.4 Up-to-date
GI_HOME 18.8.0.0.191015 Up-to-date
DB_HOME 12.1.0.2.191015 Up-to-date
[root@ecl-odabase-0 ~]#
Section 2: Pre-patching Preparation Steps
2.1 Space Check
First of all, we need to ensure we have enough space on /, /u01, and /opt file systems. At least 20 GB should be available. If not, we can do some cleaning or extend the LVM partitions.
Usage of below mentioned mount points :
- Unpacking is happening in /opt mount point
- Grid and DB patching and upgrades are happening in /u01 mount.
- OS upgrade is happening in / mount point.
Note: After unpacking the root “/” mount point we need 8GB free on both nodes. /u01 we need 15GB free on both nodes
Space Check
############# space check
[root@ecl-odabase-0 orapkgs]# df -h .
Filesystem Size Used Avail Use% Mounted on
/dev/xvda2 55G 42G 9.7G 82% /
[root@ecl-odabase-0 ~]# df -h / /u01 /opt
Filesystem Size Used Avail Use% Mounted on
/dev/xvda2 55G 42G 9.9G 81% /
/dev/xvdb1 92G 70G 18G 81% /u01
/dev/xvda2 55G 42G 9.9G 81% /
[root@ecl-odabase-0 ~]#
[root@ecl-odabase-1 ~]# df -h / /u01 /opt
Filesystem Size Used Avail Use% Mounted on
/dev/xvda2 55G 44G 8.3G 84% /
/dev/xvdb1 92G 71G 17G 82% /u01
/dev/xvda2 55G 44G 8.3G 84% /
[root@ecl-odabase-1 ~]#
2.2 Unpacking Patches and Upgrading Repository
In virtualized environments, copy the patch bundle to ODA_Base on both nodes. Use the below-mentioned commands to unpack 19.8.0.0 patches to /opt mount point.
oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_1of3.zip
oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_2of3.zip
oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_3of3.zip
Expected output:
-- node01
[root@ecl-odabase-0 19.8.0.0]# oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_1of3.zip
Unpacking will take some time, Please wait...
Successfully unpacked the files to repository.
[root@ecl-odabase-0 19.8.0.0]# oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_2of3.zip
Unpacking will take some time, Please wait...
Successfully unpacked the files to repository.
[root@ecl-odabase-0 19.8.0.0]#
[root@ecl-odabase-0 19.8.0.0]# oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_3of3.zip
Unpacking will take some time, Please wait...
Successfully unpacked the files to repository.
-- node02
[root@ecl-odabase-1 oak]# oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_1of3.zip
Unpacking will take some time, Please wait...
Successfully unpacked the files to repository.
[root@ecl-odabase-1 oak]# oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_2of3.zip
Unpacking will take some time, Please wait...
Successfully unpacked the files to repository.
[root@ecl-odabase-1 ~]# oakcli unpack -package /db_backup/19.8.0.0/p31481822_198000_Linux-x86-64_3of3.zip
Unpacking will take some time, Please wait...
Successfully unpacked the files to repository.
You have new mail in /var/spool/mail/root
Update the repository with the latest patches.
Once the unpacking is successful update the repository with latest patches.
oakcli update -patch 19.8.0.0.0 --verify
[root@ecl-odabase-0 oak]# oakcli update -patch 19.8.0.0.0 --verify
INFO: 2022-05-17 15:16:30: Reading the metadata file now...
Component Name Installed Version Proposed Patch Version
--------------- ------------------ -----------------
Controller_INT 4.650.00-7176 Up-to-date
Controller_EXT 13.00.00.00 16.00.08.00
Expander 001E Up-to-date
SSD_SHARED {
[ c1d20,c1d21,c1d22, A29A Up-to-date
c1d23,c1d44,c1d45,c1
d46,c1d47 ]
[ c1d16,c1d17,c1d18, A29A Up-to-date
c1d19,c1d40,c1d41,c1
d42,c1d43 ]
}
HDD_LOCAL A7E0 Up-to-date
HDD_SHARED {
[ c1d24,c1d25,c1d26, A3A0 Up-to-date
c1d27,c1d29,c1d30,c1
d31,c1d32,c1d33,c1d3
4,c1d35,c1d36,c1d37,
c1d38,c1d39 ]
[ c1d0,c1d1,c1d2,c1d PD51 Up-to-date
3,c1d4,c1d5,c1d6,c1d
7,c1d8,c1d9,c1d10,c1
d11,c1d12,c1d13,c1d1
4,c1d15,c1d28 ]
}
ILOM 4.0.4.52 r132805 Up-to-date
BIOS 30300200 Up-to-date
IPMI 1.8.15.0 Up-to-date
HMP 2.4.5.0.1 Up-to-date
OAK 18.8.0.0.0 19.8.0.0.0
OL 6.10 7.8
OVM 3.4.4 Up-to-date
GI_HOME 18.8.0.0.191015 19.8.0.0.200714
DB_HOME 12.1.0.2.191015 12.1.0.2.200714
AHF 213400 202100
[root@ecl-odabase-0 oak]#
-- node02
[root@ecl-odabase-1 oak]# oakcli update -patch 19.8.0.0 --verify
INFO: 2022-05-17 15:20:48: Reading the metadata file now...
Component Name Installed Version Proposed Patch Version
--------------- ------------------ -----------------
Controller_INT 4.650.00-7176 Up-to-date
Controller_EXT 13.00.00.00 16.00.08.00
Expander 001E Up-to-date
SSD_SHARED {
[ c1d20,c1d21,c1d22, A29A Up-to-date
c1d23,c1d44,c1d45,c1
d46,c1d47 ]
[ c1d16,c1d17,c1d18, A29A Up-to-date
c1d19,c1d40,c1d41,c1
d42,c1d43 ]
}
HDD_LOCAL A7E0 Up-to-date
HDD_SHARED {
[ c1d0,c1d1,c1d2,c1d A3A0 Up-to-date
3,c1d5,c1d6,c1d7,c1d
8,c1d9,c1d10,c1d11,c
1d12,c1d13,c1d14,c1d
15 ]
[ c1d4,c1d24,c1d25,c PD51 Up-to-date
1d26,c1d27,c1d28,c1d
29,c1d30,c1d31,c1d32
,c1d33,c1d34,c1d35,c
1d36,c1d37,c1d38,c1d
39 ]
}
ILOM 4.0.4.52 r132805 Up-to-date
BIOS 30300200 Up-to-date
IPMI 1.8.15.0 Up-to-date
HMP 2.4.5.0.1 Up-to-date
OAK 18.8.0.0.0 19.8.0.0.0
OL 6.10 7.8
OVM 3.4.4 Up-to-date
GI_HOME 18.8.0.0.191015 19.8.0.0.200714
DB_HOME 12.1.0.2.191015 12.1.0.2.200714
AHF 213400 202100
[root@ecl-odabase-1 oak]#
2.3 Health Check Report
I would recommend performing a health check on the system before proceeding with patching. For health checks reports can be obtained by “oakcli validate -d “, There are many other options for validating the command. I normally do this when planning for Exadata patching.
Execute Validate command, check the health status
################## validate the ODA environment
https://docs.oracle.com/cd/E68623_01/doc.121/e68637/GUID-0B61366B-720E-4DBC-A805-20435EB5E9CF.htm#:~:text=oakcli%20validate%20%2Dl,sensor%0A%20%20%20%20%20%20%20%20%20data%20readings
oakcli validate -l
Checkname -- Description
========= ===========
*SystemComponents -- Validate system components based on ilom sensor data
readings
*OSDiskStorage -- Validate OS disks and filesystem information
*SharedStorage -- Validate Shared storage and multipathing information
DiskCalibration -- Check disk performance with orion
*NetworkComponents -- Validate public and private network components
*StorageTopology -- Validate external JBOD connectivity
asr -- Validate asr components based on asr config file and ilom sensor
data readings
oakcli validate -a -- Validate all the components
===================================================================================================
======================================== OS Upgrade
Pre-Patching There are two main pre-patching steps are there for 19.8.0.0
- Main Pre-patching to validate os and components
- OS Pre-patching – Need to execute during downtime
Main Pre-patching to validate OS and components
################# Pre-Patching steps OS
oakcli update -patch 19.8.0.0.0 --pre-patchreport --local - FirstNote: Patching only can run after everything looks clean on pre-check reports.
Please find the Sample pre-patching report, This report has failed due to unallocated ASM disks to DATA and RECO.
Note: 1st attempt failed with ASM disk failure.
############ Log
#### Node01
[root@ecl-odabase-0 oak]# oakcli update -patch 19.8.0.0.0 --pre-patchreport --local
INFO: Running OS prepatch checks ...
INFO: Validate supported versions
SUCCESS: Validated minimum supported versions.
INFO: Validate patching tag
SUCCESS: Validated patching tag: 19.8.0.0.0
INFO: Is patch location available
SUCCESS: Patch location is available.
INFO: Space checks for OS upgrade
ERROR: Minimum 7 GB free space required under "/root"
INFO: Validate custom rpms installed
ERROR: The custom RPM checks may not have run
ERROR: Some of the OS prepatch tasks went wrong
INFO: Running Storage prepatch checks ...
INFO: Validate patching tag
SUCCESS: Validated patching tag: 19.8.0.0.0
INFO: Patch location validation
SUCCESS: Verified patch location.
INFO: Patch tag validation
SUCCESS: Verified patching tag.
INFO: Verify ASM disks status
ERROR: One or more ASM disk are not online. Rolling storage update cannot proceed.
ERROR: Some of the Storage prepatch tasks went wrong
ERROR: Pre patch report ended with errors
You have new mail in /var/spool/mail/root
#####
Solution: Fix the ASM issue
############# ASM disk work around.
SQL> alter diskgroup /*+ _OAK_AsmCookie */ reco add disk '/dev/mapper/HDD_E1_S08_1931561940p2' name HDD_E1_S08_1931561940p2 force;2nd attempt: After allocating the ASM disk to DATA and RECO disk groups.
Note: Make sure you have enough space on the root “/” mount point.
[root@ecl-odabase-0 ~]# oakcli update -patch 19.8.0.0.0 --pre-patchreport --local
INFO: Running OS prepatch checks ...
INFO: Validate supported versions
SUCCESS: Validated minimum supported versions.
INFO: Validate patching tag
SUCCESS: Validated patching tag: 19.8.0.0.0
INFO: Is patch location available
SUCCESS: Patch location is available.
INFO: Space checks for OS upgrade
SUCCESS: Validated space checks.
INFO: Install OS upgrade software
INFO: This action might take a while if packages need to be uncompressed
SUCCESS: Extracted OS upgrade patches into /root/oda-upgrade.
Do not remove this directory until OS upgrade completes.
INFO: Verify OS upgrade by running preupgrade checks
INFO: This operation will take long, please wait
SUCCESS: Results stored in: '/root/preupgrade-results/preupg_results-220520152633.tar.gz' .
Read complete report file '/root/preupgrade/result.html' before attempting OS upgrade.
INFO: Validate custom rpms installed
WARNING: Found additional RPMs installed
Warning: user is responsible for updating custom RPM files
SUCCESS: All OS prepatch tasks ran correctly
INFO: Running Storage prepatch checks ...
INFO: Validate patching tag
SUCCESS: Validated patching tag: 19.8.0.0.0
INFO: Patch location validation
SUCCESS: Verified patch location.
INFO: Patch tag validation
SUCCESS: Verified patching tag.
INFO: Verify ASM disks status
SUCCESS: ASM disk are online.
SUCCESS: All Storage prepatch tasks ran correctly
SUCCESS: Pre patch report ended successfully
You have new mail in /var/spool/mail/root-– downtime
Patching
OS Pre-patching
################ Note
This will stop the local node, run the oakcli update -patch with the pre-osupgrade option to stop the Virtual Machines, shared repositories, Oracle Clusterware, and databases:
oakcli update -patch 19.8.0.0.0 --pre-osupgrade --local - Second
3rd party rpm list pre-patching will create a directory in “/root/oda-upgrade” this has information about the 3rd party rpm list.
########## Validate 3rd party rpms
cd /root/oda-upgrade
[root@ecl-odabase-0 oda-upgrade]# cat rpms-added-from-ThirdParty
perl-Expect
perl-IO-Stty
perl-Net-OpenSSH
perl-RPC-XML
socat
[root@ecl-odabase-0 oda-upgrade]#
Sample output for OS Pre-Patching on node 01.
OS pre-patching needs to be executed on both nodes in a sequential manner.
Note: On the local node, run the oakcli update -patch with the pre-osupgrade option to stop the Virtual Machines, shared repositories, Oracle Clusterware, and databases.
############# OS-Pre-Patch
[root@ecl-odabase-0 ~]# oakcli update -patch 19.8.0.0.0 --pre-osupgrade --local
INFO: Trying to ping dom0 agent
INFO: dom0 agent is live
INFO: dom0 agent is not updated.
INFO: Updating dom0 agent, this will take a while...
SUCCESS: dom0 agent updated
INFO: Stopping Vms and Repos on both nodes. This may take a while...
SUCCESS: Repos and vms stopped
INFO: Disabling start repo
Start repo operation is now DISABLED on node 0
Start repo operation is now DISABLED on node 1
SUCCESS: Start repo disabled
INFO: Stopping CRS in local node
INFO: 2022-05-20 16:44:47: Clusterware is running on local node
INFO: 2022-05-20 16:44:47: Attempting to stop clusterware and its resources locally
SUCCESS: 2022-05-20 16:46:32: Successfully stopped the clusterware on local node
SUCCESS: CRS stopped in local node
SUCCESS: Loop devices check passed
INFO: Checking network script file (ifcfg-eth0)
INFO: Network script file (ifcfg-eth0) check finished
INFO: Updating ovsvf-config RPM on DOM0
SUCCESS: Upgrade DOM0 ovsvf-config RPM succeeded
SUCCESS: Pre-OSupgrade finished successfully
You have new mail in /var/spool/mail/root
Patching Operating System
Make sure to stop all the database and other application services before starting the work and back up the ODA_BASE in case you need to restore the backup to 18.8.
- Stop database services and other application services.
- Backup ODA_BASE
- Stop the OEM Agent
- Stop Virtual Machine and Repo
- Stop Cluster on Patching Node
####################### stop emagent - both nodes
/u01/agent13.3/agent_13.3.0.0.0/bin/emctl stop agent
####################### Stop Servers
####################### VM stop commands
oakcli show vm - note down the running vm's
oakcli stop vm dns_10_7 -node 1 -- example
oakcli stop vm dns_10_7
###################### Repo stop commands
[root@ecl-odabase-0 ~]# oakcli stop repo vmstor1 -node 0
[root@ecl-odabase-0 ~]# oakcli stop repo vmstor1 -node 1
Note: OS patching can be executed using option –local. Make sure to run on one node at a time as this is a risk involved in the upgrade.
Note : OS Path needs to be complete on both nodes , move the server patching.
########### Before OS upgrade
1. stop vm
2. stop repo
3. stop cluster : /u01/app/18.0.0.0/grid/bin/crsctl stop crs -f
###### 30 min - 45 min
script /root/19.8_UPGRADE/output_os_upgrade_07june2022.txt
oakcli update -patch 19.8.0.0.0 --osupgrade --local
Once completes the os-upgrade run the post-upgrade as the last step to validate all the components.
### post os patch
[root@hostname ~]# /opt/oracle/oak/bin/oakcli update -patch 19.8.0.0.0 --post-osupgrade --local
screen -ls
script /root/19.8_UPGRADE/output_os_post_07june2022.txt
oakcli update -patch 19.8.0.0.0 --post-osupgrade --local
Sample output for post-osupgrade
############## post upgrade
### node01
[root@ecl-odabase-0 ~]# script /root/19.8_UPGRADE/output_os_post_07june2022.txt
Script started, file is /root/19.8_UPGRADE/output_os_post_07june2022.txt
[root@ecl-odabase-0 ~]# oakcli update -patch 19.8.0.0.0 --post-osupgrade --local
INFO: Validating OS version
SUCCESS: OS has been upgraded to 4.14.35-1902.303.4.1.el7uek successfully.
INFO: Validating OAK version
SUCCESS: ODA software has been upgraded to 19.8.0.0.0 successfully.
INFO: Validating GI version
SUCCESS: GI software is running at correct version: 18.8.0.0.191015(30112122,30581079).
INFO: Starting CRS
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
WARNING: There are additional RPMs installed on the system.
WARNING: Please upgrade these RPMs.
INFO: Starting NFS service
SUCCESS: NFS service has been started successfully.
INFO: Removing ODA OS patching software
SUCCESS: ODA OS patching software has been removed
INFO: Updating system inventory
SUCCESS: System inventory updated
SUCCESS: Patching post-osupgrade command finished successfully
[root@ecl-odabase-0 ~]#
Validate after OS upgrade
########### Verification
oakcli update -patch 19.8.0.0.0 --verify
Expected output
-- node01
[root@ecl-odabase-0 oda-upgrade]# oakcli update -patch 19.8.0.0 --verify
INFO: 2022-06-07 15:44:55: Reading the metadata file now...
Component Name Installed Version Proposed Patch Version
--------------- ------------------ -----------------
Controller_INT 4.650.00-7176 Up-to-date
Controller_EXT 13.00.00.00 16.00.08.00
Expander 001E Up-to-date
SSD_SHARED {
[ c1d20,c1d21,c1d22, A29A Up-to-date
c1d23,c1d44,c1d45,c1
d46,c1d47 ]
[ c1d16,c1d17,c1d18, A29A Up-to-date
c1d19,c1d40,c1d41,c1
d42,c1d43 ]
}
HDD_LOCAL A7E0 Up-to-date
HDD_SHARED {
[ c1d24,c1d25,c1d26, A3A0 Up-to-date
c1d27,c1d29,c1d30,c1
d31,c1d32,c1d33,c1d3
4,c1d35,c1d36,c1d37,
c1d38,c1d39 ]
[ c1d0,c1d1,c1d2,c1d PD51 Up-to-date
3,c1d4,c1d5,c1d6,c1d
7,c1d8,c1d9,c1d10,c1
d11,c1d12,c1d13,c1d1
4,c1d15,c1d28 ]
}
ILOM 4.0.4.52 r132805 Up-to-date
BIOS 30300200 Up-to-date
IPMI 1.8.15.0 Up-to-date
HMP 2.4.5.0.1 Up-to-date
OAK 19.8.0.0.0 Up-to-date
OL 7.8 Up-to-date
OVM 3.4.4 Up-to-date
GI_HOME 18.8.0.0.191015 19.8.0.0.200714
DB_HOME 12.1.0.2.191015 12.1.0.2.200714
AHF 213400 202100
[root@ecl-odabase-0 oda-upgrade]#
--node02
[root@ecl-odabase-1 ~]# oakcli update -patch 19.8.0.0 --verify
INFO: 2022-06-07 16:07:19: Reading the metadata file now...
Component Name Installed Version Proposed Patch Version
--------------- ------------------ -----------------
Controller_INT 4.650.00-7176 Up-to-date
Controller_EXT 13.00.00.00 16.00.08.00
Expander 001E Up-to-date
SSD_SHARED {
[ c1d20,c1d21,c1d22, A29A Up-to-date
c1d23,c1d44,c1d45,c1
d46,c1d47 ]
[ c1d16,c1d17,c1d18, A29A Up-to-date
c1d19,c1d40,c1d41,c1
d42,c1d43 ]
}
HDD_LOCAL A7E0 Up-to-date
HDD_SHARED {
[ c1d0,c1d1,c1d2,c1d A3A0 Up-to-date
3,c1d5,c1d6,c1d7,c1d
8,c1d9,c1d10,c1d11,c
1d12,c1d13,c1d14,c1d
15 ]
[ c1d4,c1d24,c1d25,c PD51 Up-to-date
1d26,c1d27,c1d28,c1d
29,c1d30,c1d31,c1d32
,c1d33,c1d34,c1d35,c
1d36,c1d37,c1d38,c1d
39 ]
}
ILOM 4.0.4.52 r132805 Up-to-date
BIOS 30300200 Up-to-date
IPMI 1.8.15.0 Up-to-date
HMP 2.4.5.0.1 Up-to-date
OAK 19.8.0.0.0 Up-to-date
OL 7.8 Up-to-date
OVM 3.4.4 Up-to-date
GI_HOME 18.8.0.0.191015 19.8.0.0.200714
DB_HOME 12.1.0.2.191015 12.1.0.2.200714
AHF 213400 202100
[root@ecl-odabase-1 ~]#
Patching Server
This includes server patching includes upgrading the grid to 19c.
Note: /u01 needs more than 12GB, Safe side we need 25GB
######################################################################
############################ Server Patching
Note: /u01 needs more than 12GB , Safe side we need 25GB
Sample : /opt/oracle/oak/bin/oakcli update -patch 19.8.0.0.0 --server
screen -ls
script /root/19.8_UPGRADE/output_server_08june2022.txt
oakcli update -patch 19.8.0.0.0 --server
Patching Storage
screen
screen -ls
script /root/19.8_UPGRADE/script_Storage_10June2022.txt - record all the steps
oakcli update -patch 19.8.0.0.0 --storage
Conclusion
Moving to 18.8.0.0 – 19.8.0.0 is a really critical upgrade Because this upgrade includes the os component. Make sure you are a consistent backup to recover in case of failure. As a best practice create a proactive SR with an Oracle. Also, validate OS precheck before proceeding further on the upgrade. Virtualized ODA is very stable after moving to 19.8.0.0.
Next article I will cover the 19.13.0.0 upgrade.
More from this Author
OCI Tablespace Creation Error – ORA-28361: Master Key not yet set for CREATE TABLESPACE in OCI DBCS
Introduction We are living in a data era. Every organization invests in a colossal sum of money to secure its IT infrastructure environment. ... Read More
