Dica - Executando upgrade do Grid 19.3 para 19.10


O Path 19.10 foi lançado no dia 19 de janeiro de 2021. Neste artigo, estaremos aplicando o patch em um ambiente Red Hat Enterprise Linux com Grid 19.3.

Para a aplicação do Patch é necessário que a versão do opatch esteja na versão 12.2.0.1.23 ou superior.

Antes de aplicar o patch, vamos validar a existência de conflitos para aplicação do Patch 19.10:

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32218454
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32222571
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32218663
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/29340594
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32240590
grid@lamimdb01 ~]$ cd /u03/midias/
[grid@lamimdb01 midias]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 32226239/32218454
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.9/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.9/grid/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.9/grid/cfgtoollogs/opatch/opatch2021-02-19_11-42-28AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@lamimdb01 midias]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 32226239/32222571
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.9/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.9/grid/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.9/grid/cfgtoollogs/opatch/opatch2021-02-19_11-42-40AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@lamimdb01 midias]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 32226239/32218663
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.9/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.9/grid/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.9/grid/cfgtoollogs/opatch/opatch2021-02-19_11-42-48AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@lamimdb01 midias]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 32226239/29340594
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.9/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.9/grid/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.9/grid/cfgtoollogs/opatch/opatch2021-02-19_11-42-55AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@lamimdb01 midias]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 32226239/32240590
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.9/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.9/grid/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.9/grid/cfgtoollogs/opatch/opatch2021-02-19_11-43-05AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@lamimdb01 midias]$

Para aplicar o patch:

# opatchauto apply <UNZIPPED_PATCH_LOCATION>/32226239 -oh <GI_HOM


[root@lamimdb01 midias]# export PATH=$PATH:$ORACLE_HOME/OPatch
[root@lamimdb01 midias]# opatchauto apply 32226239 -oh /u01/app/19.9/grid

OPatchauto session is initiated at Fri Feb 19 00:07:55 2021

System initialization log file is /u01/app/19.9/grid/cfgtoollogs/opatchautodb/systemconfig2021-02-19_12-07-58AM.log.

Session log file is /u01/app/19.9/grid/cfgtoollogs/opatchauto/opatchauto2021-02-19_12-08-48AM.log
The id for this session is E1L6

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.9/grid
Patch applicability verified successfully on home /u01/app/19.9/grid


Executing patch validation checks on home /u01/app/19.9/grid
Patch validation checks successfully completed on home /u01/app/19.9/grid


Bringing down CRS service on home /u01/app/19.9/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/lamimdb01/crsconfig/crs_prepatch_apply_inplace_lamimdb01_2021-02-19_00-09-13AM.log
CRS service brought down successfully on home /u01/app/19.9/grid


Start applying binary patch on home /u01/app/19.9/grid
Binary patch applied successfully on home /u01/app/19.9/grid


Starting CRS service on home /u01/app/19.9/grid
Postpatch operation log file location: /u01/app/oracle/crsdata/lamimdb01/crsconfig/crs_postpatch_apply_inplace_lamimdb01_2021-02-19_00-15-39AM.log
CRS service started successfully on home /u01/app/19.9/grid

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:lamimdb01
CRS Home:/u01/app/19.9/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u03/midias/32226239/29340594
Log: /u01/app/19.9/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-02-19_00-10-36AM_1.log

Patch: /u03/midias/32226239/32218454
Log: /u01/app/19.9/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-02-19_00-10-36AM_1.log

Patch: /u03/midias/32226239/32218663
Log: /u01/app/19.9/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-02-19_00-10-36AM_1.log

Patch: /u03/midias/32226239/32222571
Log: /u01/app/19.9/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-02-19_00-10-36AM_1.log

Patch: /u03/midias/32226239/32240590
Log: /u01/app/19.9/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-02-19_00-10-36AM_1.log



OPatchauto session completed at Fri Feb 19 00:20:53 2021
Time taken to complete the session 12 minutes, 58 seconds
[root@lamimdb01 midias]#

Comentários