======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].