How to upgrade ODA Patch: 18.8.0.0 for Virtualized System

Introduction

The goal of this document is to describe step by step how to upgrade ODA Virtualized System.

Prerequisites

For this Upgrade the ODA must be at version 18.3

Oracle Database Appliance Documentation (Check the last version of the patch)

Start Upgrade

1 – Backup of ODA_BASE (Both Nodes): It can take up to 2h00 hours.

From DOM0:
As root user:
Node 1:

oakcli stop oda_base

mkdir -p /backup/odax58duts1/odax58duts1_date +"%Y%m%d"

nohup tar -cvzf oakDom1.odax58duts1_dom0.tar.gz /OVS/Repositories/odabaseRepo/VirtualMachines/oakDom1 &

After complete the backup:

oakcli start oda_base

Node 2:

oakcli stop oda_base

mkdir -p /backup/odax58duts2/odax58duts2_date +"%Y%m%d"

nohup tar -cvzf oakDom1.odax58duts2_dom0.tar.gz /OVS/Repositories/odabaseRepo/VirtualMachines/oakDom1 &

After complete the backup:

oakcli start oda_base

2 – Download patch in a shared directory or separated directory in both ODA servers:

Os User: root

mkdir -p /backup/patchODA2020

Download all required files to this directory:

/backup/patchODA2020

There is 2 .zip files to be download patch (30518438):

p30518438_188000_Linux-x86-64_1of2.zip

p30518438_188000_Linux-x86-64_2of2.zip

Note: We must guarantee some minimum amount of free space (20GB) in the ODA BASE, file systems: “/” and “/u01
– Purge old logs from ODA, with root user:

oakcli manage cleanrepo --ver 18.3.0.0.0

oakcli manage cleanrepo --ver 18.6.0.0.0

/usr/local/bin/purgeODALog -orcl 20 -tfa 10 -osw 10 -oak 10

– Clean up old patches from GRID_HOME, affects “/u01“:

su - grid

. oraenv

+ASM1 or +ASM2

cd $ORACLE_HOME/OPatch

./opatch util cleanup

– Clean up old patches from ORACLE_HOME, affects “/u01“:

su - oracle

. oraenv <SID>

cd $ORACLE_HOME/OPatch

./opatch util cleanup

Note:
– It must be performed this clean in every ORACLE_HOME versions that exists in the server.
– Look at “/home/oracle“, “/home/grid” and “/tmp” to perform some clean up and release some space in the file system “/“.

3 – Unpack downloaded patch in both ODA nodes:

cd /backup/patchODA2020

oakcli unpack -package p30518438_188000_Linux-x86-64_1of2.zip

oakcli unpack -package p30518438_188000_Linux-x86-64_2of2.zip

4 – Verify and Validate Upgrade ODA components (S.O):

export EXTRA_OS_RPMS_LOC=/backup/patchODA2020

oakcli validate -c ospatch -ver 18.8.0.0.0

Note:
Solving rpm’s conflict for version 18.8.0.0.0.

e.g: With errors and conflicts

BEGIN OUTPUT:
NODE 1:

[root@odax58duts1 patchODA2020]# oakcli validate -c ospatch -ver 18.8.0.0.0

INFO: Validating the OS patch for the version 18.8.0.0.0

INFO: 2020-06-06 14:06:16: Performing a dry run for OS patching

ERROR: 2020-06-06 14:06:31: Unable to run the command : /usr/bin/yum --exclude=kmod-mpt2sas,ibutils-libs,dapl,libcxgb3,libipathverbs,libmthca,libnes,ofed-docs update --disablerepo=* --enablerepo=ODA_REPOS_LOC -y

ERROR: 2020-06-06 14:06:31: Loaded plugins: rhnplugin, ulninfo, versionlock

This system is not registered with ULN.

You can use uln_register to register.

ULN support will be disabled.

Repository ol6_latest is listed more than once in the configuration

Repository ol6_addons is listed more than once in the configuration

Repository ol6_UEK_latest is listed more than once in the configuration

Setting up Update Process

Resolving Dependencies

--> Running transaction check

---> Package cpupowerutils.x86_64 0:1.3-2.el6 will be updated

---> Package cpupowerutils.x86_64 0:1.3-2.0.1.el6 will be an update

---> Package cups-libs.x86_64 1:1.4.2-79.el6 will be updated

---> Package cups-libs.x86_64 1:1.4.2-81.el6_10 will be an update

---> Package dbus.x86_64 1:1.2.24-9.0.1.el6 will be updated

---> Package dbus.x86_64 1:1.2.24-11.0.1.el6_10 will be an update

---> Package dbus-libs.x86_64 1:1.2.24-9.0.1.el6 will be updated

---> Package dbus-libs.x86_64 1:1.2.24-11.0.1.el6_10 will be an update

---> Package dracut.noarch 0:004-411.0.3.el6 will be updated

---> Package dracut.noarch 0:004-411.0.4.el6 will be an update

---> Package dracut-kernel.noarch 0:004-411.0.3.el6 will be updated

---> Package dracut-kernel.noarch 0:004-411.0.4.el6 will be an update

---> Package glibc.x86_64 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc.x86_64 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package glibc-common.x86_64 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc-common.x86_64 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package glibc-devel.i686 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc-devel.x86_64 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc-devel.i686 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package glibc-devel.x86_64 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package glibc-headers.x86_64 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc-headers.x86_64 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package initscripts.x86_64 0:9.03.61-1.0.3.el6 will be updated

---> Package initscripts.x86_64 0:9.03.61-1.0.6.el6 will be an update

---> Package kernel-headers.x86_64 0:2.6.32-754.11.1.el6 will be updated

---> Package kernel-headers.x86_64 0:2.6.32-754.18.2.el6 will be an update

---> Package kernel-uek.x86_64 0:4.1.12-124.33.4.el6uek will be installed

---> Package kernel-uek-firmware.noarch 0:4.1.12-124.33.4.el6uek will be installed

---> Package kexec-tools.x86_64 0:2.0.7-1.0.27.el6 will be updated

---> Package kexec-tools.x86_64 0:2.0.7-1.0.28.el6 will be an update

---> Package ksplice.x86_64 0:1.0.38-1.el6 will be updated

---> Package ksplice.x86_64 0:1.0.43-1.el6 will be an update

---> Package ksplice-core0.x86_64 0:1.0.38-1.el6 will be updated

---> Package ksplice-core0.x86_64 0:1.0.43-1.el6 will be an update

---> Package ksplice-offline.x86_64 0:1.0.38-1.el6 will be updated

---> Package ksplice-offline.x86_64 0:1.0.43-1.el6 will be an update

---> Package ksplice-tools.x86_64 0:1.0.38-1.el6 will be updated

---> Package ksplice-tools.x86_64 0:1.0.43-1.el6 will be an update

---> Package libgudev1.x86_64 0:147-2.73.0.1.el6_8.2 will be updated

---> Package libgudev1.x86_64 0:147-2.73.0.2.el6_8.2 will be an update

---> Package libudev.x86_64 0:147-2.73.0.1.el6_8.2 will be updated

---> Package libudev.x86_64 0:147-2.73.0.2.el6_8.2 will be an update

---> Package mailx.x86_64 0:12.4-8.el6_6 will be updated

---> Package mailx.x86_64 0:12.4-10.el6_10 will be an update

---> Package openssl.x86_64 0:1.0.1e-57.0.6.el6 will be updated

---> Package openssl.x86_64 0:1.0.1e-58.0.1.el6_10 will be an update

---> Package oracle-ofed-release.x86_64 0:1.0.0-50.el6 will be updated

---> Package oracle-ofed-release.x86_64 0:1.0.0-51.el6 will be an update

---> Package perf.x86_64 0:2.6.32-754.11.1.el6 will be updated

---> Package perf.x86_64 0:2.6.32-754.18.2.el6 will be an update

---> Package python.x86_64 0:2.6.6-66.0.1.el6_8 will be updated

---> Package python.x86_64 0:2.6.6-68.0.1.el6_10 will be an update

---> Package python-libs.x86_64 0:2.6.6-66.0.1.el6_8 will be updated

---> Package python-libs.x86_64 0:2.6.6-68.0.1.el6_10 will be an update

---> Package rdma.noarch 2:3.10-3.0.40.el6 will be updated

---> Package rdma.noarch 2:3.10-3.0.41.el6 will be an update

---> Package samba.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package samba-client.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba-client.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package samba-common.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba-common.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package samba-winbind.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba-winbind.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package samba-winbind-clients.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba-winbind-clients.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package sudo.x86_64 0:1.8.6p3-29.el6_9 will be updated

---> Package sudo.x86_64 0:1.8.6p3-29.0.1.el6_10.2 will be an update

---> Package tzdata.noarch 0:2019a-1.el6 will be updated

---> Package tzdata.noarch 0:2019c-1.el6 will be an update

---> Package tzdata-java.noarch 0:2018e-3.el6 will be updated

---> Package tzdata-java.noarch 0:2019c-1.el6 will be an update

---> Package udev.x86_64 0:147-2.73.0.1.el6_8.2 will be updated

---> Package udev.x86_64 0:147-2.73.0.2.el6_8.2 will be an update

---> Package vim-common.x86_64 2:7.4.629-5.el6_8.1 will be updated

---> Package vim-common.x86_64 2:7.4.629-5.el6_10.2 will be an update

---> Package vim-enhanced.x86_64 2:7.4.629-5.el6_8.1 will be updated

---> Package vim-enhanced.x86_64 2:7.4.629-5.el6_10.2 will be an update

---> Package vim-minimal.x86_64 2:7.4.629-5.el6_8.1 will be updated

---> Package vim-minimal.x86_64 2:7.4.629-5.el6_10.2 will be an update

---> Package xorg-x11-server-Xorg.x86_64 0:1.17.4-17.0.1.el6 will be updated

---> Package xorg-x11-server-Xorg.x86_64 0:1.17.4-17.0.2.el6 will be an update

---> Package xorg-x11-server-common.x86_64 0:1.17.4-17.0.1.el6 will be updated

---> Package xorg-x11-server-common.x86_64 0:1.17.4-17.0.2.el6 will be an update

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================

 Package                 Arch    Version                   Repository      Size

================================================================================

Installing:

 kernel-uek              x86_64  4.1.12-124.33.4.el6uek    ODA_REPOS_LOC   42 M

 kernel-uek-firmware     noarch  4.1.12-124.33.4.el6uek    ODA_REPOS_LOC  2.6 M

Updating:

 cpupowerutils           x86_64  1.3-2.0.1.el6             ODA_REPOS_LOC   77 k

 cups-libs               x86_64  1:1.4.2-81.el6_10         ODA_REPOS_LOC  322 k

 dbus                    x86_64  1:1.2.24-11.0.1.el6_10    ODA_REPOS_LOC  211 k

 dbus-libs               x86_64  1:1.2.24-11.0.1.el6_10    ODA_REPOS_LOC  127 k

 dracut                  noarch  004-411.0.4.el6           ODA_REPOS_LOC  129 k

 dracut-kernel           noarch  004-411.0.4.el6           ODA_REPOS_LOC   29 k

 glibc                   x86_64  2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC  3.8 M

 glibc-common            x86_64  2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC   14 M

 glibc-devel             i686    2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC  992 k

 glibc-devel             x86_64  2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC  991 k

 glibc-headers           x86_64  2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC  620 k

 initscripts             x86_64  9.03.61-1.0.6.el6         ODA_REPOS_LOC  952 k

 kernel-headers          x86_64  2.6.32-754.18.2.el6       ODA_REPOS_LOC  4.6 M

 kexec-tools             x86_64  2.0.7-1.0.28.el6          ODA_REPOS_LOC  339 k

 ksplice                 x86_64  1.0.43-1.el6              ODA_REPOS_LOC  9.1 k

 ksplice-core0           x86_64  1.0.43-1.el6              ODA_REPOS_LOC  271 k

 ksplice-offline         x86_64  1.0.43-1.el6              ODA_REPOS_LOC  7.9 k

 ksplice-tools           x86_64  1.0.43-1.el6              ODA_REPOS_LOC   92 k

 libgudev1               x86_64  147-2.73.0.2.el6_8.2      ODA_REPOS_LOC   65 k

 libudev                 x86_64  147-2.73.0.2.el6_8.2      ODA_REPOS_LOC   78 k

 mailx                   x86_64  12.4-10.el6_10            ODA_REPOS_LOC  235 k

 openssl                 x86_64  1.0.1e-58.0.1.el6_10      ODA_REPOS_LOC  1.5 M

 oracle-ofed-release     x86_64  1.0.0-51.el6              ODA_REPOS_LOC   16 k

 perf                    x86_64  2.6.32-754.18.2.el6       ODA_REPOS_LOC  4.8 M

 python                  x86_64  2.6.6-68.0.1.el6_10       ODA_REPOS_LOC   76 k

 python-libs             x86_64  2.6.6-68.0.1.el6_10       ODA_REPOS_LOC  5.3 M

 rdma                    noarch  2:3.10-3.0.41.el6         ODA_REPOS_LOC   76 k

 samba                   x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC  5.1 M

 samba-client            x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC   11 M

 samba-common            x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC   10 M

 samba-winbind           x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC  2.2 M

 samba-winbind-clients   x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC  2.0 M

 sudo                    x86_64  1.8.6p3-29.0.1.el6_10.2   ODA_REPOS_LOC  712 k

 tzdata                  noarch  2019c-1.el6               ODA_REPOS_LOC  507 k

 tzdata-java             noarch  2019c-1.el6               ODA_REPOS_LOC  188 k

 udev                    x86_64  147-2.73.0.2.el6_8.2      ODA_REPOS_LOC  360 k

 vim-common              x86_64  2:7.4.629-5.el6_10.2      ODA_REPOS_LOC  6.7 M

 vim-enhanced            x86_64  2:7.4.629-5.el6_10.2      ODA_REPOS_LOC  1.0 M

 vim-minimal             x86_64  2:7.4.629-5.el6_10.2      ODA_REPOS_LOC  421 k

 xorg-x11-server-Xorg    x86_64  1.17.4-17.0.2.el6         ODA_REPOS_LOC  1.4 M

 xorg-x11-server-common  x86_64  1.17.4-17.0.2.el6         ODA_REPOS_LOC   51 k

Transaction Summary

================================================================================

Install       2 Package(s)

Upgrade      41 Package(s)

Total download size: 126 M

Downloading Packages:

--------------------------------------------------------------------------------

Total                                           190 MB/s | 126 MB     00:00

Running rpm_check_debug

Running Transaction Test

Transaction Check Error:

  file /usr/bin/ldd from install of glibc-common-2.12-1.212.0.3.el6_10.3.x86_64 conflicts with file from package glibc-common-2.12-1.212.0.3.el6_10.3.i686

  file /usr/lib/locale/locale-archive.tmpl from install of glibc-common-2.12-1.212.0.3.el6_10.3.x86_64 conflicts with file from package glibc-common-2.12-1.212.0.3.el6_10.3.i686

Error Summary

-------------

WARNING: 2020-06-06 14:06:31: OS Upgrade is not successful. Need to resolve conflicts

INFO: 2020-06-06 14:06:31: Copy the required RPMs to a location and set EXTRA_OS_RPMS_LOC to that location

Here we need to solve the dependency problem, in this case we will remove the package

[root@odax58duts1 patchODA2020]# rpm -e glibc-common-2.12-1.212.0.3.el6_10.3.i686 --nodeps

You have new mail in /var/spool/mail/root

[root@odax58duts1 patchODA2020]# oakcli validate -c ospatch -ver 18.8.0.0.0

INFO: Validating the OS patch for the version 18.8.0.0.0

INFO: 2020-06-06 14:09:51: Performing a dry run for OS patching

INFO: 2020-06-06 14:10:09: No conflict detected during the OS update, dry run check.

NODE 2:

[root@odax58duts2 patchODA2020]# oakcli validate -c ospatch -ver 18.8.0.0.0

INFO: Validating the OS patch for the version 18.8.0.0.0

INFO: 2020-06-06 14:15:59: Performing a dry run for OS patching

ERROR: 2020-06-06 14:16:18: Unable to run the command : /usr/bin/yum --exclude=kmod-mpt2sas,ibutils-libs,dapl,libcxgb3,libipathverbs,libmthca,libnes,ofed-docs update --disablerepo=* --enablerepo=ODA_REPOS_LOC -y

ERROR: 2020-06-06 14:16:18: Loaded plugins: rhnplugin, ulninfo, versionlock

This system is not registered with ULN.

You can use uln_register to register.

ULN support will be disabled.

Repository ol6_latest is listed more than once in the configuration

Repository ol6_addons is listed more than once in the configuration

Repository ol6_UEK_latest is listed more than once in the configuration

Setting up Update Process

Resolving Dependencies

--> Running transaction check

---> Package cpupowerutils.x86_64 0:1.3-2.el6 will be updated

---> Package cpupowerutils.x86_64 0:1.3-2.0.1.el6 will be an update

---> Package cups-libs.x86_64 1:1.4.2-79.el6 will be updated

---> Package cups-libs.x86_64 1:1.4.2-81.el6_10 will be an update

---> Package dbus.x86_64 1:1.2.24-9.0.1.el6 will be updated

---> Package dbus.x86_64 1:1.2.24-11.0.1.el6_10 will be an update

---> Package dbus-libs.x86_64 1:1.2.24-9.0.1.el6 will be updated

---> Package dbus-libs.x86_64 1:1.2.24-11.0.1.el6_10 will be an update

---> Package dracut.noarch 0:004-411.0.3.el6 will be updated

---> Package dracut.noarch 0:004-411.0.4.el6 will be an update

---> Package dracut-kernel.noarch 0:004-411.0.3.el6 will be updated

---> Package dracut-kernel.noarch 0:004-411.0.4.el6 will be an update

---> Package glibc.x86_64 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc.x86_64 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package glibc-devel.i686 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc-devel.x86_64 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc-devel.i686 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package glibc-devel.x86_64 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package glibc-headers.x86_64 0:2.12-1.212.0.2.el6 will be updated

---> Package glibc-headers.x86_64 0:2.12-1.212.0.3.el6_10.3 will be an update

---> Package initscripts.x86_64 0:9.03.61-1.0.3.el6 will be updated

---> Package initscripts.x86_64 0:9.03.61-1.0.6.el6 will be an update

---> Package kernel-headers.x86_64 0:2.6.32-754.11.1.el6 will be updated

---> Package kernel-headers.x86_64 0:2.6.32-754.18.2.el6 will be an update

---> Package kernel-uek.x86_64 0:4.1.12-124.33.4.el6uek will be installed

---> Package kernel-uek-firmware.noarch 0:4.1.12-124.33.4.el6uek will be installed

---> Package kexec-tools.x86_64 0:2.0.7-1.0.27.el6 will be updated

---> Package kexec-tools.x86_64 0:2.0.7-1.0.28.el6 will be an update

---> Package ksplice.x86_64 0:1.0.38-1.el6 will be updated

---> Package ksplice.x86_64 0:1.0.43-1.el6 will be an update

---> Package ksplice-core0.x86_64 0:1.0.38-1.el6 will be updated

---> Package ksplice-core0.x86_64 0:1.0.43-1.el6 will be an update

---> Package ksplice-offline.x86_64 0:1.0.38-1.el6 will be updated

---> Package ksplice-offline.x86_64 0:1.0.43-1.el6 will be an update

---> Package ksplice-tools.x86_64 0:1.0.38-1.el6 will be updated

---> Package ksplice-tools.x86_64 0:1.0.43-1.el6 will be an update

---> Package libgudev1.x86_64 0:147-2.73.0.1.el6_8.2 will be updated

---> Package libgudev1.x86_64 0:147-2.73.0.2.el6_8.2 will be an update

---> Package libudev.x86_64 0:147-2.73.0.1.el6_8.2 will be updated

---> Package libudev.x86_64 0:147-2.73.0.2.el6_8.2 will be an update

---> Package mailx.x86_64 0:12.4-8.el6_6 will be updated

---> Package mailx.x86_64 0:12.4-10.el6_10 will be an update

---> Package openssl.x86_64 0:1.0.1e-57.0.6.el6 will be updated

---> Package openssl.x86_64 0:1.0.1e-58.0.1.el6_10 will be an update

---> Package oracle-ofed-release.x86_64 0:1.0.0-50.el6 will be updated

---> Package oracle-ofed-release.x86_64 0:1.0.0-51.el6 will be an update

---> Package perf.x86_64 0:2.6.32-754.11.1.el6 will be updated

---> Package perf.x86_64 0:2.6.32-754.18.2.el6 will be an update

---> Package python.x86_64 0:2.6.6-66.0.1.el6_8 will be updated

---> Package python.x86_64 0:2.6.6-68.0.1.el6_10 will be an update

---> Package python-libs.x86_64 0:2.6.6-66.0.1.el6_8 will be updated

---> Package python-libs.x86_64 0:2.6.6-68.0.1.el6_10 will be an update

---> Package rdma.noarch 2:3.10-3.0.40.el6 will be updated

---> Package rdma.noarch 2:3.10-3.0.41.el6 will be an update

---> Package samba.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package samba-client.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba-client.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package samba-common.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba-common.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package samba-winbind.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba-winbind.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package samba-winbind-clients.x86_64 0:3.6.23-51.0.1.el6 will be updated

---> Package samba-winbind-clients.x86_64 0:3.6.23-52.0.1.el6_10 will be an update

---> Package sudo.x86_64 0:1.8.6p3-29.el6_9 will be updated

---> Package sudo.x86_64 0:1.8.6p3-29.0.1.el6_10.2 will be an update

---> Package tzdata.noarch 0:2019a-1.el6 will be updated

---> Package tzdata.noarch 0:2019c-1.el6 will be an update

---> Package tzdata-java.noarch 0:2018e-3.el6 will be updated

---> Package tzdata-java.noarch 0:2019c-1.el6 will be an update

---> Package udev.x86_64 0:147-2.73.0.1.el6_8.2 will be updated

---> Package udev.x86_64 0:147-2.73.0.2.el6_8.2 will be an update

---> Package vim-common.x86_64 2:7.4.629-5.el6_8.1 will be updated

---> Package vim-common.x86_64 2:7.4.629-5.el6_10.2 will be an update

---> Package vim-enhanced.x86_64 2:7.4.629-5.el6_8.1 will be updated

---> Package vim-enhanced.x86_64 2:7.4.629-5.el6_10.2 will be an update

---> Package vim-minimal.x86_64 2:7.4.629-5.el6_8.1 will be updated

---> Package vim-minimal.x86_64 2:7.4.629-5.el6_10.2 will be an update

---> Package xorg-x11-server-Xorg.x86_64 0:1.17.4-17.0.1.el6 will be updated

---> Package xorg-x11-server-Xorg.x86_64 0:1.17.4-17.0.2.el6 will be an update

---> Package xorg-x11-server-common.x86_64 0:1.17.4-17.0.1.el6 will be updated

---> Package xorg-x11-server-common.x86_64 0:1.17.4-17.0.2.el6 will be an update

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================

 Package                 Arch    Version                   Repository      Size

================================================================================

Installing:

 kernel-uek              x86_64  4.1.12-124.33.4.el6uek    ODA_REPOS_LOC   42 M

 kernel-uek-firmware     noarch  4.1.12-124.33.4.el6uek    ODA_REPOS_LOC  2.6 M

Updating:

 cpupowerutils           x86_64  1.3-2.0.1.el6             ODA_REPOS_LOC   77 k

 cups-libs               x86_64  1:1.4.2-81.el6_10         ODA_REPOS_LOC  322 k

 dbus                    x86_64  1:1.2.24-11.0.1.el6_10    ODA_REPOS_LOC  211 k

 dbus-libs               x86_64  1:1.2.24-11.0.1.el6_10    ODA_REPOS_LOC  127 k

 dracut                  noarch  004-411.0.4.el6           ODA_REPOS_LOC  129 k

 dracut-kernel           noarch  004-411.0.4.el6           ODA_REPOS_LOC   29 k

 glibc                   x86_64  2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC  3.8 M

 glibc-devel             i686    2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC  992 k

 glibc-devel             x86_64  2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC  991 k

 glibc-headers           x86_64  2.12-1.212.0.3.el6_10.3   ODA_REPOS_LOC  620 k

 initscripts             x86_64  9.03.61-1.0.6.el6         ODA_REPOS_LOC  952 k

 kernel-headers          x86_64  2.6.32-754.18.2.el6       ODA_REPOS_LOC  4.6 M

 kexec-tools             x86_64  2.0.7-1.0.28.el6          ODA_REPOS_LOC  339 k

 ksplice                 x86_64  1.0.43-1.el6              ODA_REPOS_LOC  9.1 k

 ksplice-core0           x86_64  1.0.43-1.el6              ODA_REPOS_LOC  271 k

 ksplice-offline         x86_64  1.0.43-1.el6              ODA_REPOS_LOC  7.9 k

 ksplice-tools           x86_64  1.0.43-1.el6              ODA_REPOS_LOC   92 k

 libgudev1               x86_64  147-2.73.0.2.el6_8.2      ODA_REPOS_LOC   65 k

 libudev                 x86_64  147-2.73.0.2.el6_8.2      ODA_REPOS_LOC   78 k

 mailx                   x86_64  12.4-10.el6_10            ODA_REPOS_LOC  235 k

 openssl                 x86_64  1.0.1e-58.0.1.el6_10      ODA_REPOS_LOC  1.5 M

 oracle-ofed-release     x86_64  1.0.0-51.el6              ODA_REPOS_LOC   16 k

 perf                    x86_64  2.6.32-754.18.2.el6       ODA_REPOS_LOC  4.8 M

 python                  x86_64  2.6.6-68.0.1.el6_10       ODA_REPOS_LOC   76 k

 python-libs             x86_64  2.6.6-68.0.1.el6_10       ODA_REPOS_LOC  5.3 M

 rdma                    noarch  2:3.10-3.0.41.el6         ODA_REPOS_LOC   76 k

 samba                   x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC  5.1 M

 samba-client            x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC   11 M

 samba-common            x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC   10 M

 samba-winbind           x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC  2.2 M

 samba-winbind-clients   x86_64  3.6.23-52.0.1.el6_10      ODA_REPOS_LOC  2.0 M

 sudo                    x86_64  1.8.6p3-29.0.1.el6_10.2   ODA_REPOS_LOC  712 k

 tzdata                  noarch  2019c-1.el6               ODA_REPOS_LOC  507 k

 tzdata-java             noarch  2019c-1.el6               ODA_REPOS_LOC  188 k

 udev                    x86_64  147-2.73.0.2.el6_8.2      ODA_REPOS_LOC  360 k

 vim-common              x86_64  2:7.4.629-5.el6_10.2      ODA_REPOS_LOC  6.7 M

 vim-enhanced            x86_64  2:7.4.629-5.el6_10.2      ODA_REPOS_LOC  1.0 M

 vim-minimal             x86_64  2:7.4.629-5.el6_10.2      ODA_REPOS_LOC  421 k

 xorg-x11-server-Xorg    x86_64  1.17.4-17.0.2.el6         ODA_REPOS_LOC  1.4 M

 xorg-x11-server-common  x86_64  1.17.4-17.0.2.el6         ODA_REPOS_LOC   51 k

Transaction Summary

================================================================================

Install       2 Package(s)

Upgrade      40 Package(s)

Total download size: 112 M

Downloading Packages:

--------------------------------------------------------------------------------

Total                                           187 MB/s | 112 MB     00:00

Running rpm_check_debug

ERROR with rpm_check_debug vs depsolve:

glibc = 2.12-1.212.0.1.el6 is needed by (installed) nscd-2.12-1.212.0.1.el6.x86_64

** Found 11 pre-existing rpmdb problem(s), 'yum check' output follows:

glibc-2.12-1.212.0.2.el6.x86_64 has missing requires of glibc-common = ('0', '2.12', '1.212.0.2.el6')

glibc-2.12-1.212.0.3.el6_10.3.i686 is a duplicate with glibc-2.12-1.212.0.2.el6.x86_64

libgcc-4.4.7-23.0.1.el6.x86_64 is a duplicate with libgcc-4.4.7-18.el6.i686

nscd-2.12-1.212.0.1.el6.x86_64 has missing requires of glibc = ('0', '2.12', '1.212.0.1.el6')

oak-18.7.0.0.0_LINUX.X64_190915-1.x86_64 has missing requires of libnfsodm18.so()(64bit)

oak-18.7.0.0.0_LINUX.X64_190915-1.x86_64 has missing requires of perl(GridDefParams)

oak-18.7.0.0.0_LINUX.X64_190915-1.x86_64 has missing requires of perl(oakosdiskinfo)

oak-18.7.0.0.0_LINUX.X64_190915-1.x86_64 has missing requires of perl(oaksharedstorageinfo)

oak-18.7.0.0.0_LINUX.X64_190915-1.x86_64 has missing requires of perl(oakstoragetopology)

oak-18.7.0.0.0_LINUX.X64_190915-1.x86_64 has missing requires of perl(ol5_to_ol6_upgrade)

oak-18.7.0.0.0_LINUX.X64_190915-1.x86_64 has missing requires of perl(s_GridSteps)

Your transaction was saved, rerun it with:

 yum load-transaction /tmp/yum_save_tx-2020-06-06-14-16PkHNuJ.yumtx

WARNING: 2020-06-06 14:16:18: OS Upgrade is not successful. Need to resolve conflicts

INFO: 2020-06-06 14:16:18: Copy the required RPMs to a location and set EXTRA_OS_RPMS_LOC to that location

Here we need to solve the dependency problem, in this case we will remove the package

[root@odax58duts2 patchODA2020]# rpm -e nscd-2.12-1.212.0.1.el6 --nodeps

[root@odax58duts2 patchODA2020]# oakcli validate -c ospatch -ver 18.8.0.0.0

INFO: Validating the OS patch for the version 18.8.0.0.0

INFO: 2020-06-06 14:16:38: Performing a dry run for OS patching

INFO: 2020-06-06 14:16:55: No conflict detected during the OS update, dry run check.

Now we have the environment validated for updating the operating system

5 – Verify which components it will be required to update:

oakcli update -patch 18.8.0.0.0 --verify

e.g:

[root@odax58duts1 patchODA2020]#   oakcli update -patch 18.8.0.0.0 --verify

INFO: 2020-06-06 14:27:34: Reading the metadata file now...

                Component Name            Installed Version         Proposed Patch Version

                ---------------           ------------------        -----------------

                Controller_INT            11.05.03.00               Up-to-date

                Controller_EXT            11.05.03.00               Up-to-date

                Expander                  001E                      Up-to-date

                SSD_SHARED                944A                      Up-to-date

                HDD_LOCAL                 A7E0                      Up-to-date

                HDD_SHARED                A7E0                      Up-to-date

                ILOM                      4.0.4.40 r130079          5.0.0.20 r133445

                BIOS                      25080100                  Up-to-date

                IPMI                      1.8.15.0                  Up-to-date

                HMP                       2.4.5.0.1                 Up-to-date

                OAK                       18.7.0.0.0                18.8.0.0.0

                OL                        6.10                      Up-to-date

                OVM                       3.4.4                     Up-to-date

                GI_HOME                   18.7.0.0.190716           18.8.0.0.191015

                DB_HOME {

                [ OraDb12102_home1 ]      12.1.0.2.190716           12.1.0.2.191015

                [ OraDb11204_home1 ]      11.2.0.4.190716           11.2.0.4.191015

                [ OraDB18Home1 ]          18.7.1.0.191015           18.8.0.0.191015

                [ OraDb11203_home2 ]      11.2.0.3.15               No-update

                             }

[root@odax58duts2 patchODA2020]#   oakcli update -patch 18.8.0.0.0 --verify

INFO: 2020-06-06 14:27:39: Reading the metadata file now...

                Component Name            Installed Version         Proposed Patch Version

                ---------------           ------------------        -----------------

                Controller_INT            11.05.03.00               Up-to-date

                Controller_EXT            11.05.03.00               Up-to-date

                Expander                  001E                      Up-to-date

                SSD_SHARED                944A                      Up-to-date

                HDD_LOCAL                 A7E0                      Up-to-date

                HDD_SHARED                A7E0                      Up-to-date

                ILOM                      4.0.4.40 r130079          5.0.0.20 r133445

                BIOS                      25080100                  Up-to-date

                IPMI                      1.8.15.0                  Up-to-date

                HMP                       2.4.5.0.1                 Up-to-date

                OAK                       18.7.0.0.0                18.8.0.0.0

                OL                        6.10                      Up-to-date

                OVM                       3.4.4                     Up-to-date

                GI_HOME                   18.7.0.0.190716           18.8.0.0.191015

                DB_HOME {

                [ OraDb12102_home1 ]      12.1.0.2.190716           12.1.0.2.191015

                [ OraDb11204_home1 ]      11.2.0.4.190716           11.2.0.4.191015

                [ OraDB18Home1 ]          18.7.1.0.191015           18.8.0.0.191015

                [ OraDb11203_home2 ]      11.2.0.3.15               No-update

Note:

– Stop all databases and clusterware resource before patch ILOM in both servers

6 – Update ILOM

I prefer to first update ILOM in case there is a problem during the patch I can access the environment via ILOM.
 
If you want to update ILOM with the patch, it may be your choice as well.
 
 
Note:  Upgrade ILOM: Both ILOM nodes, but not in the same time.
 
Download ILOM Patch separately: Sun Server X5-8 (ILOM 5.0.0.20 133445)
Custom File Name: p30802633_300_Generic.zip
The firmware are inside of this .zip file in the following path:
C:\Users\andre.ontalba\Downloads\p30802633_300_Generic\Oracle_Server_X5-8-3.0.0.91223-FIRMWARE_PACK\Firmware\service-processor\ILOM-5_0_0_20_r133445-Oracle_Server_X5-4_X5-8.pkg
You must copy this file to the following directory in the server to use for transfer this package. In my case dutsLinux1.

/patch/ILOM

This file must be owned by “oracle” user and group “oinstall
Connect to the gateway machine: dutsLinux1

ssh xxxx@dutsLinux1

Connect to the first ILOM from the gateway machine:

ssh root@odax58duts1-ilom

Enter remote user password: **********

Check current version:
e.g:
Type:

  -> version

SP firmware 4.0.4.40

SP firmware build number: 130079

SP firmware date: Thu May 07 09:54:31 CST 2019

SP filesystem version: 0.2.10

Stopping DOM0 and ODA_BASE: (Connect to the ILOM):

stop /SYS

Check status:

show /SYS

e.g: Section “Properties –> power_state = Off”

  Properties:

      type = Host System

      ipmi_name = /SYS

      product_name = SUN SERVER X5-8

      product_part_number = XXXXXXXXXXXXXXX

      product_serial_number = XXXXXXXXXXXXXXX

      product_manufacturer = Oracle Corporation

      fault_state = OK

      clear_fault_action = (none)

      power_state = Off

Load new ILOM image:

load -source scp://xxxx@dutsLinux1/ILOM/ ILOM-5_0_0_20_r133445-Oracle_Server_X5-4_X5-8.pkg

e.g:

load -source scp://root@dutsLinux1/ILOM/ ILOM-5_0_0_20_r133445-Oracle_Server_X5-4_X5-8.pkg

Enter remote user password: **********

NOTE: An upgrade takes several minutes to complete. ILOM

      will enter a special mode to load new firmware. No

      other tasks can be performed in ILOM until the

      firmware upgrade is complete and ILOM is reset.

    You can choose to postpone the server BIOS upgrade until the

    next server poweroff. If you do not do that, you should

    perform a clean shutdown of the server before continuing.

Are you sure you want to load the specified file (y/n)? y

Preserve existing SP configuration (y/n)? y

Preserve existing BIOS configuration (y/n)? y

Delay BIOS upgrade until next server poweroff or reset (y/n)? n

...

After the automatic reboot performed in the ILOM, you can validate the new firmware and BIOS version:

version

Hostname: odax58duts1-ilom

-> version

SP firmware 5.0.0.20

SP firmware build number: 133445

SP firmware date: Thr Feb 06 09:54:31 CST 2020

SP filesystem version: 0.2.10

show /SYS/MB/BIOS

/SYS/MB/BIOS

  Targets:

  Properties:

      type = BIOS

      ipmi_name = MB/BIOS

      fru_name = SYSTEM BIOS

      fru_manufacturer = AMERICAN MEGATRENDS

      fru_version = 25080100

      fru_part_number = APTIO

Start the DOM0 and ODA_BASE after upgrade ILOM:

start /SYS

exit

Note:  Repeat this procedure on the second node

7 – Upgrade ODA Servers

Note: Run only from first server and make sure that is the master node: oakcli show ismaster ⇒ “OAKD is in Master Mode”

oakcli update -patch 18.8.0.0.0 –server

e.g:

[root@odax58duts2 patchODA2020]# oakcli update -patch 18.8.0.0.0 –server

This procedure can take between 2 to 3 hours to execute on both nodes.

INFO: DB, ASM, Clusterware may be stopped during the patch if required

INFO: Both Nodes may get rebooted automatically during the patch if required

Do you want to continue: [Y/N]?: y

INFO: User has confirmed for the reboot

INFO: Patch bundle must be unpacked on the second Node also before applying the patch

Did you unpack the patch bundle on the second Node? : [Y/N]? : y

INFO: All the VMs except the ODABASE will be shutdown forcefully if needed

Do you want to continue : [Y/N]? : y

To be able to monitor the application of the patch we can see the logs in the directories below
Log file directory node 1:   /opt/oracle/oak/log/odax58duts1/patch/18.8.0.0.0/
Log file directory node 2:   /opt/oracle/oak/log/odax58duts2/patch/18.8.0.0.0/

Let’s check how is the server update
Node 1

[root@odax58duts1 patchODA2020]# oakcli show version -detail

INFO: 2020-06-06 17:17:34: Reading the metadata file now...

                Component Name            Installed Version         Proposed Patch Version

                ---------------           ------------------        -----------------

                Controller_INT            11.05.03.00               Up-to-date

                Controller_EXT            11.05.03.00               Up-to-date

                Expander                  001E                      Up-to-date

                SSD_SHARED                944A                      Up-to-date

                HDD_LOCAL                 A7E0                      Up-to-date

                HDD_SHARED                A7E0                      Up-to-date

                ILOM                      5.0.0.20 r133445          Up-to-date

                BIOS                      25080100                  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 {

                [ OraDb12102_home1 ]      12.1.0.2.190716           12.1.0.2.191015

                [ OraDb11204_home1 ]      11.2.0.4.190716           11.2.0.4.191015

                [ OraDB18Home1 ]          18.7.1.0.191015           18.8.0.0.191015

                [ OraDb11203_home2 ]      11.2.0.3.15               No-update

Node 2

[root@odax58duts2 patchODA2020]#   oakcli show version -detail

INFO: 2020-06-06 17:18:39: Reading the metadata file now...

                Component Name            Installed Version         Proposed Patch Version

                ---------------           ------------------        -----------------

                Controller_INT            11.05.03.00               Up-to-date

                Controller_EXT            11.05.03.00               Up-to-date

                Expander                  001E                      Up-to-date

                SSD_SHARED                944A                      Up-to-date

                HDD_LOCAL                 A7E0                      Up-to-date

                HDD_SHARED                A7E0                      Up-to-date

                ILOM                      5.0.0.20 r133445          Up-to-date

                BIOS                      25080100                  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 {

                [ OraDb12102_home1 ]      12.1.0.2.190716           12.1.0.2.191015

                [ OraDb11204_home1 ]      11.2.0.4.190716           11.2.0.4.191015

                [ OraDB18Home1 ]          18.7.1.0.191015           18.8.0.0.191015

                [ OraDb11203_home2 ]      11.2.0.3.15               No-update

8 – ODA Patch: Database Binaries

Now is time to apply patch on the Oracle Database Binaries (11.2.0.4,12.1,12.2,18.).
Get the database list and Oracle Home before patch:

oakcli show databases

First step is stop TFA (Both Nodes with root)

tfactl stop

To apply the patch in the Oracle Binaries: (Execute Only From First Node)

oakcli update -patch 18.8.0.0.0 --database

[root@odax58duts1 18.8.0.0.0]# oakcli update -patch 18.8.0.0.0 --database

INFO: Running pre-install scripts

INFO: Running  prepatching on node 0

INFO: Running  prepatching on node 1

INFO: Completed pre-install scripts

...

...

INFO: 2020-06-06 18:51:24: ------------------Patching DB-------------------------

INFO: 2020-06-06 18:51:24: Getting all the possible Database Homes for patching

...

INFO: 2020-06-06 18:52:03: Patching 11.2.0.4 Database Homes on the Node odax58duts1

Found the following 11.2.0.4 homes possible for patching:

HOME_NAME                      HOME_LOCATION

---------                      -------------

OraDb11204_home1               /u01/app/oracle/product/11.2.0.4/dbhome_1

[Please note that few of the above Database Homes may be already up-to-date. They will be automatically ignored]

Would you like to patch all the above homes: Y | N ? : Y

INFO: 2020-06-06 18:52:15: Updating OPATCH

Verifying Opatch version for home:</u01/app/oracle/product/11.2.0.4/dbhome_1>.

Expecting version:<11.2.0.3.22>

Opatch version on node <odax58duts1> is <11.2.0.3.22>

Opatch version on node <odax58duts2> is <11.2.0.3.22>

INFO: 2020-06-06 18:53:41: Performing the conflict checks...

SUCCESS: 2020-06-06 18:53:53: Conflict checks passed for all the Homes

INFO: 2020-06-06 18:53:53: Checking if the patch is already applied on any of the Homes

INFO: 2020-06-06 18:53:58: Home is not Up-to-date

SUCCESS: 2020-06-06 18:53:59: Successfully stopped the Database consoles

SUCCESS: 2020-06-06 18:54:06: Successfully stopped the EM agents

INFO: 2020-06-06 18:54:11: Applying the patch on oracle home : /u01/app/oracle/product/11.2.0.4/dbhome_1 ...

SUCCESS: 2020-06-06 18:56:20: Successfully applied the patch on the Home : /u01/app/oracle/product/11.2.0.4/dbhome_1

SUCCESS: 2020-06-06 18:56:20: Successfully started the Database consoles

SUCCESS: 2020-06-06 18:56:20: Successfully started the EM Agents

INFO: 2020-06-06 18:56:23: Patching 11.2.0.4 Database Homes on the Node odax58duts2

...

INFO: 2020-06-06 19:00:02: Patching 12.1.0.2 Database Homes on the Node odax58duts1

Found the following 12.1.0.2 homes possible for patching:

HOME_NAME                      HOME_LOCATION

---------                      -------------

OraDb12102_home1               /u01/app/oracle/product/12.1.0.2/dbhome_1

[Please note that few of the above Database Homes may be already up-to-date. They will be automatically ignored]

Would you like to patch all the above homes: Y | N ? : Y

INFO: 2020-06-06 19:06:38: Updating OPATCH

Verifying Opatch version for home:</u01/app/oracle/product/12.1.0.2/dbhome_1>.

Expecting version:<12.2.0.1.18>

Opatch version on node <odax58duts1> is <12.2.0.1.18>

Opatch version on node <odax58duts2> is <12.2.0.1.18>

INFO: 2020-06-06 19:07:37: Rolling back patches on 12.1.0.2.x home if required...

INFO: 2020-06-06 19:07:43: Checking if any patches need to be rolled back on </u01/app/oracle/product/12.1.0.2/dbhome_1>

INFO: 2020-06-06 19:11:35: Performing the conflict checks...

SUCCESS: 2020-06-06 19:11:59: Conflict checks passed for all the Homes

INFO: 2020-06-06 19:11:59: Checking if the patch is already applied on any of the Homes

INFO: 2020-06-06 19:12:11: Home is not Up-to-date

SUCCESS: 2020-06-06 19:12:13: Successfully stopped the Database consoles

SUCCESS: 2020-06-06 19:12:19: Successfully stopped the EM agents

INFO: 2020-06-06 19:12:25: Applying patch on /u01/app/oracle/product/12.1.0.2/dbhome_1 Homes

INFO: 2020-06-06 19:12:25: It may take upto 15 mins. Please wait...

SUCCESS: 2020-06-06 19:17:19: Successfully applied the patch on the Home : /u01/app/oracle/product/12.1.0.2/dbhome_1

SUCCESS: 2020-06-06 19:17:19: Successfully started the Database consoles

SUCCESS: 2020-06-06 19:17:19: Successfully started the EM Agents

INFO: 2020-06-06 19:17:23: Patching 12.1.0.2 Database Homes on the Node odax58duts2

...

INFO: 2020-06-06 19:27:08: Patching 18.0.0.0 Database Homes on the Node odax58duts1

Found the following 18.0.0.0 homes possible for patching:

HOME_NAME                      HOME_LOCATION

---------                      -------------

OraDB18Home1                   /u01/app/oracle/product/18.0.0.0

[Please note that few of the above Database Homes may be already up-to-date. They will be automatically ignored]

Would you like to patch all the above homes: Y | N ? : Y

INFO: 2020-06-06 19:27:15: Updating OPATCH

Verifying Opatch version for home:</u01/app/oracle/product/18.0.0.0>.

Expecting version:<12.2.0.1.18>

Opatch version on node <odax58duts1> is <12.2.0.1.18>

Opatch version on node <odax58duts2> is <12.2.0.1.18>

INFO: 2020-06-06 19:27:26: Rolling back patches on 18.x home if required...

INFO: 2020-06-06 19:27:33: Checking if any patches need to be rolled back on </u01/app/oracle/product/18.0.0.0>

INFO: 2020-06-06 19:28:57: Performing the conflict checks...

SUCCESS: 2020-06-06 19:29:57: Conflict checks passed for all the Homes

INFO: 2020-06-06 19:29:57: Checking if the patch is already applied on any of the Homes

INFO: 2020-06-06 19:30:36: Home is not Up-to-date

SUCCESS: 2020-06-06 19:30:38: Successfully stopped the Database consoles

SUCCESS: 2020-06-06 19:30:44: Successfully stopped the EM agents

INFO: 2020-06-06 19:30:49: Applying patch on /u01/app/oracle/product/18.0.0.0 Homes

INFO: 2020-06-06 19:30:49: It may take up to 15 mins. Please wait...

SUCCESS: 2020-06-06 19:40:34: Successfully applied the patch on the Home : /u01/app/oracle/product/18.0.0.0

SUCCESS: 2020-06-06 19:40:34: Successfully started the Database consoles

SUCCESS: 2020-06-06 19:40:34: Successfully started the EM Agents

INFO: 2020-06-06 19:40:37: Patching 18.0.0.0 Database Homes on the Node odax58duts2

INFO: DB patching summary on node: odax58duts1

SUCCESS: 2020-06-06 19:52:28:  Successfully applied the patch on the Home /u01/app/oracle/product/11.2.0.4/dbhome_1

SUCCESS: 2020-06-06 19:52:28:  Successfully applied the patch on the Home /u01/app/oracle/product/12.1.0.2/dbhome_1

SUCCESS: 2020-06-06 19:52:28:  Successfully applied the patch on the Home /u01/app/oracle/product/18.0.0.0

INFO: DB patching summary on node: odax58duts2

SUCCESS: 2020-06-06 19:52:28:  Successfully applied the patch on the Home /u01/app/oracle/product/11.2.0.4/dbhome_1

SUCCESS: 2020-06-06 19:52:28:  Successfully applied the patch on the Home /u01/app/oracle/product/12.1.0.2/dbhome_1

SUCCESS: 2020-06-06 19:52:28:  Successfully applied the patch on the Home /u01/app/oracle/product/18.0.0.0

INFO: Executing /tmp/pending_actions on both nodes

You have new mail in /var/spool/mail/root

[root@odax58duts1 18.8.0.0.0]#

Let’s check how is the database update
Node 1

[root@odax58duts1 patchODA2020]# oakcli show version -detail

INFO: 2020-06-06 19:55:34: Reading the metadata file now...

                Component Name            Installed Version         Proposed Patch Version

                ---------------           ------------------        -----------------

                Controller_INT            11.05.03.00               Up-to-date

                Controller_EXT            11.05.03.00               Up-to-date

                Expander                  001E                      Up-to-date

                SSD_SHARED                944A                      Up-to-date

                HDD_LOCAL                 A7E0                      Up-to-date

                HDD_SHARED                A7E0                      Up-to-date

                ILOM                      5.0.0.20 r133445          Up-to-date

                BIOS                      25080100                  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 {

                [ OraDb12102_home1 ]      12.1.0.2.191015           Up-to-date

                [ OraDb11204_home1 ]      11.2.0.4.191015           Up-to-date

                [ OraDB18Home1 ]          18.8.0.0.191015           Up-to-date

                [ OraDb11203_home2 ]      11.2.0.3.15               No-update

                             }

Node 2

[root@odax58duts2 patchODA2020]#   oakcli show version -detail

INFO: 2020-06-06 19:56:39: Reading the metadata file now...

                Component Name            Installed Version         Proposed Patch Version

                ---------------           ------------------        -----------------

                Controller_INT            11.05.03.00               Up-to-date

                Controller_EXT            11.05.03.00               Up-to-date

                Expander                  001E                      Up-to-date

                SSD_SHARED                944A                      Up-to-date

                HDD_LOCAL                 A7E0                      Up-to-date

                HDD_SHARED                A7E0                      Up-to-date

                ILOM                      5.0.0.20 r133445          Up-to-date

                BIOS                      25080100                  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 {

                [ OraDb12102_home1 ]      12.1.0.2.191015           Up-to-date

                [ OraDb11204_home1 ]      11.2.0.4.191015           Up-to-date

                [ OraDB18Home1 ]          18.8.0.0.191015           Up-to-date

                [ OraDb11203_home2 ]      11.2.0.3.15               No-update

9- Apply DATAPATCH/CATBUNDLE in databases 11.2 / 12.1 / 12.2 and 18.8

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

$ORACLE_HOME/OPatch/datapatch -verbose

Note: It is required set up the NLS_LANG to “AMERICAN_AMERICA.AL32UTF8” variable in order to avoid a BUG during the DATAPATCH in the Oracle Database 12.1

Reference Documents:

Oracle Database Appliance – 18.2, 12.X, and 2.X Supported ODA Versions & Known Issues (Doc ID 888888.1)
https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/18.8/cmtxn/patching-oda.html#GUID-49F5F510-3A38-4E6A-B915-FCBCD36CDDDB

I hope I helped with this ODA upgrade procedure
Andre Ontalba

Disclaimer: “The postings on this site are my own and don’t necessarily represent may actual employer positions, strategies or opinions. The information here was edited  to be useful for general purpose, specific data and identifications was removed to allow reach generic audience and to be useful.