Introdução
O objetivo deste documento é descrever passo a passo como atualizar ODA com a configuração de ambiente virtualizado.
Pré-requisitos
Para este Upgrade do ODA você deve está no mínimo na versão 18.3
Oracle Database Appliance Documentation (Check the last version of the patch)
Iniciando o Upgrade
1 – Backup do ODA_BASE (ambos Nodes): Pode levar até 2h00 horas.
No DOM0:
Com o user root:
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 &
Após completar o 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 &
Após completar o backup:
oakcli start oda_base
2 – Baixe patch em um diretório compartilhado ou diretório separado em ambos os servidores ODA:
Com o user: root
mkdir -p /backup/patchODA2020
Baixe todos os arquivos necessários para este diretório:
/backup/patchODA2020
Há 2 arquivos .zip para ser feito download (30518438):
p30518438_188000_Linux-x86-64_1of2.zip p30518438_188000_Linux-x86-64_2of2.zip
Nota: Devemos garantir uma quantidade mínima de espaço livre (20GB) na ODA BASE, sistemas de arquivos: “/ ” e “/u01”
– Purge logs antigo do ODA, com usuário root:
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
– Limpe os patches antigos do GRID_HOME, “/u01“:
su -grid . oraenv +ASM1 or +ASM2 cd $ORACLE_HOME/OPatch ./opatch util cleanup
– Limpe os patches antigos do ORACLE_HOME, “/u01“:
su - oracle . oraenv <SID> cd $ORACLE_HOME/OPatch ./opatch util cleanup
Nota:
– Deve ser realizado a limpeza em todas as versões ORACLE_HOME existentes no servidor.
– Veja o “/home/oracle”, “/home/grid” e “/tmp” para realizar alguma limpeza e liberar algum espaço no sistema de arquivos “/”.
3 – Unpack do patch baixado em ambos os nós ODA:
Node 1:
cd /backup/patchODA2020 [root@odax58duts1 patchODA2020]# oakcli unpack -package p30518438_188000_Linux-x86-64_1of2.zip [root@odax58duts1 patchODA2020]# oakcli unpack -package p30518438_188000_Linux-x86-64_2of2.zip
Node 2:
cd /backup/patchODA2020 [root@odax58duts2 patchODA2020]# oakcli unpack -package p30518438_188000_Linux-x86-64_1of2.zip [root@odax58duts2 patchODA2020]# oakcli unpack -package p30518438_188000_Linux-x86-64_2of2.zip
4 – Verificar e validar componentes ODA para atualização (S.O):
export EXTRA_OS_RPMS_LOC=/backup/patchODA2020 oakcli validate -c ospatch -ver 18.8.0.0.0
e.g: Com erros e conflitos
Inicio do 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
Aqui precisamos resolver o problema de dependência, neste caso vamos remover o pacote
[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
Aqui precisamos resolver o problema de dependência, neste caso vamos remover o pacote
[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.
Agora temos o ambiente validado para atualização do sistema operacional.
5 – Verifique quais componentes serão necessário para atualizar:
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
Nota:
– Pare todos os bancos de dados e recursos de clusterware antes de atualizar o ILOM em ambos os servidores
6 – Update ILOM
Prefiro primeiro atualizar o ILOM caso haja um problema durante o patch, para que eu possa acessar o ambiente via ILOM.
Se você quiser atualizar o ILOM com o patch, pode ser sua escolha também.
Nota: Upgrade ILOM: Ambos os nós do ILOM, mas não ao mesmo tempo.
Baixe o ILOM Patch separadamente: Sun Server X5-8 (ILOM 5.0.0.20 133445)
File Name: p30802633_300_Generic.zip
O firmware está dentro deste arquivo .zip no seguinte caminho:
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
Você deve copiar este arquivo para o seguinte diretório abaixo no servidor para um servidor, para ser usado no Upgrade. No meu caso dutsLinux1.
/patch/ILOM
Este arquivo deve ser propriedade de “oracle” usuário e grupo “oinstall”
Conecte-se à máquina de gateway:dutsLinux1
ssh xxxx@dutsLinux1
Conecte-se ao primeiro ILOM a partir da máquina gateway
ssh root@odax58duts1-ilom Enter remote user password: **********
Confira a versão atual:
e.g:
Digite
-> 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
Pare a DOM0 e ODA_BASE: (Conectado na ILOM):
stop /SYS
Verifique o status:
show /SYS
e.g: Seção “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
Carregar nova imagem do ILOM:
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 ...
Após a reinicialização automática realizada no ILOM, você pode validar o novo firmware e a versão BIOS:
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 Targets: Properties: type = BIOS ipmi_name = MB/BIOS fru_name = SYSTEM BIOS fru_manufacturer = AMERICAN MEGATRENDS fru_version = 25080100 fru_part_number = APTIO
Inicie a DOM0 e o ODA_BASE depois do upgrade ILOM:
start /SYS exit
Nota: Repita este procedimento no segundo nó
7 – Atualize servidores ODA
Nota: Execute somente a partir do primeiro servidor e certifique-se de que é o nó mestre: 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
Este procedimento pode levar entre 2 a 3 horas para ser executado em ambos os nós.
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
Para poder monitorar a aplicação do patch podemos ver os logs nos diretórios abaixo
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/
Vamos verificar como está a atualização do servidor
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: Binários de banco de dados
Agora é hora de aplicar patch nos Binários de Banco de Dados Oracle (11.2.0.4,12.1,12.2,18.).
Obtenha a lista de banco de dados e o Oracle Home antes do patch:
oakcli show databases
O primeiro passo é parar o TFA (Ambos os nós com user root)
tfactl stop
Para aplicar o patch nos Binários Oracle: (Execute somente do primeiro nó)
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]#
Vamos verificar como está a atualização do banco de dados
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- Aplicar DATAPATCH/CATBUNDLE em bancos de dados 11.2 / 12.1 / 12.2 e 18.8
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 $ORACLE_HOME/OPatch/datapatch -verbose
Nota: É necessário configurar o NLS_LANG para “AMERICAN_AMERICA. VARIÁVEL AL32UTF8” para evitar um BUG durante o DATAPATCH no Banco de Dados Oracle 12.1
Documentos de referência:
Espero ter ajudado com este procedimento de atualização da ODA
