Table of Contents

Overview

Patching the 2nd Node is as pretty straight forward, as the first:

Patch

[root@lparacb patch]# . oraenv
ORACLE_SID = [+ASM2] ?
[root@lparacb patch]# /u01/app/oracle/grid_12201/OPatch/opatchauto apply /home/oracle/patch/27100009/

OPatchauto session is initiated at Tue Jan 30 06:39:43 2018

System initialization log file is /u01/app/oracle/grid_12201/cfgtoollogs/opatchautodb/systemconfig2018-01-30_06-39-46AM.log.

Session log file is /u01/app/oracle/grid_12201/cfgtoollogs/opatchauto/opatchauto2018-01-30_06-40-09AM.log
The id for this session is VA7K

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/grid_12201

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0.1
Patch applicability verified successfully on home /u01/app/oracle/grid_12201

Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0.1


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0.1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0.1


Preparing to bring down database service on home /u01/app/oracle/product/12.2.0.1
Successfully prepared home /u01/app/oracle/product/12.2.0.1 to bring down database service


Bringing down CRS service on home /u01/app/oracle/grid_12201
Prepatch operation log file location: /u01/app/oracle/product/crsdata/lparacb/crsconfig/crspatch_lparacb_2018-01-30_06-46-25AM.log
CRS service brought down successfully on home /u01/app/oracle/grid_12201


Performing prepatch operation on home /u01/app/oracle/product/12.2.0.1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0.1


Start applying binary patch on home /u01/app/oracle/product/12.2.0.1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0.1


Performing postpatch operation on home /u01/app/oracle/product/12.2.0.1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0.1


Start applying binary patch on home /u01/app/oracle/grid_12201
Binary patch applied successfully on home /u01/app/oracle/grid_12201


Starting CRS service on home /u01/app/oracle/grid_12201
Postpatch operation log file location: /u01/app/oracle/product/crsdata/lparacb/crsconfig/crspatch_lparacb_2018-01-30_07-03-21AM.log
CRS service started successfully on home /u01/app/oracle/grid_12201


Preparing home /u01/app/oracle/product/12.2.0.1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0.1 successfully after database service restarted


Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0.1
SQL patch applied successfully on home /u01/app/oracle/product/12.2.0.1

OPatchAuto successful.

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

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

Host:lparacb
RAC Home:/u01/app/oracle/product/12.2.0.1
Summary:

==Following patches were SKIPPED:

Patch: /home/oracle/patch/27100009/27128906
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/patch/27100009/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/patch/27100009/27144050
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/patch/27100009/27105253
Log: /u01/app/oracle/product/12.2.0.1/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-30_06-48-17AM_1.log

Patch: /home/oracle/patch/27100009/27335416
Log: /u01/app/oracle/product/12.2.0.1/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-30_06-48-17AM_1.log


Host:lparacb
CRS Home:/u01/app/oracle/grid_12201
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/patch/27100009/26839277
Log: /u01/app/oracle/grid_12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-30_06-52-35AM_1.log

Patch: /home/oracle/patch/27100009/27105253
Log: /u01/app/oracle/grid_12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-30_06-52-35AM_1.log

Patch: /home/oracle/patch/27100009/27128906
Log: /u01/app/oracle/grid_12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-30_06-52-35AM_1.log

Patch: /home/oracle/patch/27100009/27144050
Log: /u01/app/oracle/grid_12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-30_06-52-35AM_1.log

Patch: /home/oracle/patch/27100009/27335416
Log: /u01/app/oracle/grid_12201/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-30_06-52-35AM_1.log



OPatchauto session completed at Tue Jan 30 07:12:24 2018
Time taken to complete the session 32 minutes, 41 seconds
[root@lparacb patch]#

During the patching, all the resources have moved to the 1st Node:

Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora.DATA.dg    ora....up.type ONLINE    ONLINE    lparaca
ora....ER.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N1.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N2.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N3.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    lparaca
ora.asm        ora.asm.type   ONLINE    ONLINE    lparaca
ora.cvu        ora.cvu.type   ONLINE    ONLINE    lparaca
ora....SM1.asm application    ONLINE    ONLINE    lparaca
ora....CA.lsnr application    ONLINE    ONLINE    lparaca
ora....aca.ons application    ONLINE    ONLINE    lparaca
ora....aca.vip ora....t1.type ONLINE    ONLINE    lparaca
ora....acb.vip ora....t1.type ONLINE    ONLINE    lparaca
ora....network ora....rk.type ONLINE    ONLINE    lparaca
ora.ons        ora.ons.type   ONLINE    ONLINE    lparaca
ora.orcl.db    ora....se.type ONLINE    ONLINE    lparaca
ora.qosmserver ora....er.type ONLINE    ONLINE    lparaca
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    lparaca
ora.scan2.vip  ora....ip.type ONLINE    ONLINE    lparaca
ora.scan3.vip  ora....ip.type ONLINE    ONLINE    lparaca
[root@lparaca grid]#

Check

The Grid Infra, has been put again back into NORMAL mode and redistributed between the nodes:

[root@lparacb patch]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora.DATA.dg    ora....up.type ONLINE    ONLINE    lparaca
ora....ER.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N1.lsnr ora....er.type ONLINE    ONLINE    lparacb
ora....N2.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N3.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    lparaca
ora.asm        ora.asm.type   ONLINE    ONLINE    lparaca
ora.cvu        ora.cvu.type   ONLINE    ONLINE    lparaca
ora....SM1.asm application    ONLINE    ONLINE    lparaca
ora....CA.lsnr application    ONLINE    ONLINE    lparaca
ora....aca.ons application    ONLINE    ONLINE    lparaca
ora....aca.vip ora....t1.type ONLINE    ONLINE    lparaca
ora....SM2.asm application    ONLINE    ONLINE    lparacb
ora....CB.lsnr application    ONLINE    ONLINE    lparacb
ora....acb.ons application    ONLINE    ONLINE    lparacb
ora....acb.vip ora....t1.type ONLINE    ONLINE    lparacb
ora....network ora....rk.type ONLINE    ONLINE    lparaca
ora.ons        ora.ons.type   ONLINE    ONLINE    lparaca
ora.orcl.db    ora....se.type ONLINE    ONLINE    lparacb
ora.qosmserver ora....er.type ONLINE    ONLINE    lparaca
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    lparacb
ora.scan2.vip  ora....ip.type ONLINE    ONLINE    lparaca
ora.scan3.vip  ora....ip.type ONLINE    ONLINE    lparaca
[root@lparacb patch]# crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [2960767134].