Here's the steps that I went thru to apply the Grid Infrastructure Jul2017 Release Update 12.2.0.1.170718, Patch 26133434 Configuration: 2 Node RAC cluster on Kaminario K2 AFA The Grid Infrastructure Jul2017 Release Update (RU) 12.2.0.1.170718 includes updates for both the Clusterware home and Database home that can be applied in a rolling fashion. In this blog post we have updated both nodes GI and DB stack. The details and execution for Node1 are repeated and presented here for Node2 as well Big thanks to Mike Dietrich for some insight !
Step 1) Upgrade the Opatch version to atleast (12.2.0.1.7). We need to upgrade the OPatch version at GI and DB Homes on all the nodes. [root@vna02 grid]# cd OPatch [root@vna02 OPatch]# ./opatch version OPatch Version: 12.2.0.1.9 è Grid Home OPatch succeeded. [oracle @vna01 dbhome_1]$ opatch version OPatch Version: 12.2.0.1.9 è Database Home Step 2) Patch conflict check: Node 1 : [oracle@vna01 GI]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_18-43-33PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@vna01 GI]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_19-01-04PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. From the Database Home : [oracle@vna01 GI]$ . oraenv ORACLE_SID = [VNADB1] ? VNADB1 The Oracle base remains unchanged with value /u01/app/oracle [oracle@vna01 GI]$ cd $ORACLE_HOME/OPatch [oracle@vna01 OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_19-03-12PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@vna01 OPatch]$ [oracle@vna01 OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_19-03-25PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. One-off Patch Conflict Detection and Resolution [root@vna01 OPatch]# $ORACLE_HOME/OPatch/opatchauto apply /home/oracle/software/patches/DB-GI-RU/GI/26133434 -analyze OPatchauto session is initiated at Wed Sep 20 19:53:25 2017 System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-09-20_07-53-27PM.log. Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-09-20_07-53-48PM.log The id for this session is QWPL Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Patch applicability verified successfully on home /u01/app/12.2.0/grid Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 Following step failed during analysis: /bin/sh -c 'ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 ORACLE_SID=VNADB1 /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/datapatch -prereq' SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:vna01 RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1 ==Following patches were SKIPPED: Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/25586399 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log Host:vna01 CRS Home:/u01/app/12.2.0/grid ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/25586399 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log OPatchauto session completed at Wed Sep 20 19:57:09 2017 Time taken to complete the session 3 minutes, 44 seconds Now OPatchauto Apply process: [root@vna01 OPatch]# $ORACLE_HOME/OPatch/opatchauto apply /home/oracle/software/patches/DB-GI-RU/GI/26133434 OPatchauto session is initiated at Wed Sep 20 20:18:27 2017 System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-09-20_08-18-28PM.log. Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-09-20_08-18-50PM.log The id for this session is CNCU Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Patch applicability verified successfully on home /u01/app/12.2.0/grid Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 "/bin/sh -c 'ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 ORACLE_SID=VNADB1 /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/datapatch -prereq'" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be analyzed by manually retrying the same command. SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/dbhome_1 Successfully prepared home /u01/app/oracle/product/12.2.0/dbhome_1 to bring down database service Bringing down CRS service on home /u01/app/12.2.0/grid Prepatch operation log file location: /u01/app/oracle/crsdata/vna01/crsconfig/crspatch_vna01_2017-09-20_08-22-15PM.log CRS service brought down successfully on home /u01/app/12.2.0/grid Performing prepatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1 Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/12.2.0/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Start applying binary patch on home /u01/app/12.2.0/grid Binary patch applied successfully on home /u01/app/12.2.0/grid Starting CRS service on home /u01/app/12.2.0/grid Postpatch operation log file location: /u01/app/oracle/crsdata/vna01/crsconfig/crspatch_vna01_2017-09-20_08-27-01PM.log CRS service started successfully on home /u01/app/12.2.0/grid Preparing home /u01/app/oracle/product/12.2.0/dbhome_1 after database service restarted No step execution required......... Prepared home /u01/app/oracle/product/12.2.0/dbhome_1 successfully after database service restarted Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/dbhome_1 "/bin/sh -c 'ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 ORACLE_SID=VNADB1 /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/datapatch'" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be applied by manually retrying the same command. SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:vna01 RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1 Summary: ==Following patches were SKIPPED: Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/25586399 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-23-57PM_1.log Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-23-57PM_1.log Host:vna01 CRS Home:/u01/app/12.2.0/grid Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-24-44PM_1.log Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/25586399 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-24-44PM_1.log Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-24-44PM_1.log OPatchauto session completed at Wed Sep 20 20:34:23 2017 Time taken to complete the session 15 minutes, 56 seconds lsInventory Output: [oracle@vna01 OPatch]$ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/12.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/12.2.0/grid/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2017-09-20_20-38-46PM_1.log lsinventory Output file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-09-20_20-38-46PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: vna01 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Grid Infrastructure 12c 12.2.0.1.0 There are 1 products installed in this Oracle Home. Interim patches (3) : Patch 26123830 : applied on Wed Sep 20 20:26:39 BST 2017 Unique Patch ID: 21405588 Patch description: "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)" Created on 7 Jul 2017, 00:33:59 hrs PST8PDT Bugs fixed: 23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877 25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421 25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959 25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846 24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398 24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007 25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332 25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017 22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726 25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817 24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628 24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167 25967985 Patch 25586399 : applied on Wed Sep 20 20:26:17 BST 2017 Unique Patch ID: 21306685 Patch description: "ACFS Patch Set Update : 12.2.0.1.170718 (25586399)" Created on 16 Jun 2017, 00:35:19 hrs PST8PDT Bugs fixed: 24679041, 24964969, 25098392, 25078431, 25491831 Patch 26002778 : applied on Wed Sep 20 20:25:26 BST 2017 Unique Patch ID: 21306682 Patch description: "OCW Patch Set Update : 12.2.0.1.170718 (26002778)" Created on 3 Jul 2017, 03:26:30 hrs PST8PDT Bugs fixed: 26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375 25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495 25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658 25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035 25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158 25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126 25197395, 24808260 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@vna01 OPatch] From the Database Home : [oracle@vna01 OPatch]$ . oraenv ORACLE_SID = [+ASM1] ? VNADB1 The Oracle base remains unchanged with value /u01/app/oracle [oracle@vna01 OPatch]$ export PATH=$ORACLE_HOME/OPatch:$PATH [oracle@vna01 OPatch]$ which opatch /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch [oracle@vna01 OPatch]$ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_20-40-03PM_1.log lsinventory Output file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-20_20-40-03PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: vna01 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 12c 12.2.0.1.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 26123830 : applied on Wed Sep 20 20:24:26 BST 2017 Unique Patch ID: 21405588 Patch description: "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)" Created on 7 Jul 2017, 00:33:59 hrs PST8PDT Bugs fixed: 23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877 25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421 25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959 25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846 24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398 24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007 25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332 25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017 22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726 25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817 24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628 24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167 25967985 Patch 26002778 : applied on Wed Sep 20 20:24:11 BST 2017 Unique Patch ID: 21306682 Patch description: "OCW Patch Set Update : 12.2.0.1.170718 (26002778)" Created on 3 Jul 2017, 03:26:30 hrs PST8PDT Bugs fixed: 26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375 25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495 25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658 25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035 25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158 25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126 25197395, 24808260 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@vna01 OPatch]$ Node 2 : Run OPatch Conflict Check From GI Home: [oracle@vna02 patches]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/patches/26133434/26123830 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/12.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/12.2.0/grid/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2017-09-20_20-48-20PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@vna02 patches]$ [oracle@vna02 patches]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/patches/26133434/26002778 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/12.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/12.2.0/grid/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2017-09-20_20-48-32PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. For the DB Home: [oracle@vna02 patches]$ export PATH=$ORACLE_HOME/OPatch:$PATH [oracle@vna02 patches]$ which opatch /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch [oracle@vna02 patches]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/patches/26133434/26123830 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_20-52-24PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@vna02 patches]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/patches/26133434/26002778 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_20-52-38PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@vna02 patches]$ OPATCH Conflict Checks: [root@vna02 12.2.0]# $ORACLE_HOME/OPatch/opatchauto apply /home/oracle/patches/26133434 -analyze OPatchauto session is initiated at Thu Sep 21 02:18:32 2017 System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-09-21_02-18-33AM.log. Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-09-21_02-18-53AM.log The id for this session is NWN8 Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Patch applicability verified successfully on home /u01/app/12.2.0/grid Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:vna02 RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1 ==Following patches were SKIPPED: Patch: /home/oracle/patches/26133434/25586399 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /home/oracle/patches/26133434/26002778 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log Patch: /home/oracle/patches/26133434/26123830 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log Host:vna02 CRS Home:/u01/app/12.2.0/grid ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /home/oracle/patches/26133434/26002778 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log Patch: /home/oracle/patches/26133434/25586399 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log Patch: /home/oracle/patches/26133434/26123830 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log OPatchauto session completed at Thu Sep 21 02:22:48 2017 Time taken to complete the session 4 minutes, 16 seconds OPatchauto apply: [root@vna02 12.2.0]# $ORACLE_HOME/OPatch/opatchauto apply /home/oracle/patches/26133434 OPatchauto session is initiated at Thu Sep 21 02:25:35 2017 System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-09-21_02-25-36AM.log. Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-09-21_02-25-57AM.log The id for this session is PM1S Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid Patch applicability verified successfully on home /u01/app/12.2.0/grid Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/dbhome_1 Successfully prepared home /u01/app/oracle/product/12.2.0/dbhome_1 to bring down database service Bringing down CRS service on home /u01/app/12.2.0/grid Prepatch operation log file location: /u01/app/oracle/crsdata/vna02/crsconfig/crspatch_vna02_2017-09-21_02-30-11AM.log CRS service brought down successfully on home /u01/app/12.2.0/grid Performing prepatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1 Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/12.2.0/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 Start applying binary patch on home /u01/app/12.2.0/grid Binary patch applied successfully on home /u01/app/12.2.0/grid Starting CRS service on home /u01/app/12.2.0/grid Postpatch operation log file location: /u01/app/oracle/crsdata/vna02/crsconfig/crspatch_vna02_2017-09-21_02-34-30AM.log CRS service started successfully on home /u01/app/12.2.0/grid Preparing home /u01/app/oracle/product/12.2.0/dbhome_1 after database service restarted No step execution required......... Prepared home /u01/app/oracle/product/12.2.0/dbhome_1 successfully after database service restarted Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/dbhome_1 SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:vna02 RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1 Summary: ==Following patches were SKIPPED: Patch: /home/oracle/patches/26133434/25586399 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/patches/26133434/26002778 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-31-39AM_1.log Patch: /home/oracle/patches/26133434/26123830 Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-31-39AM_1.log Host:vna02 CRS Home:/u01/app/12.2.0/grid Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/patches/26133434/26002778 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-32-21AM_1.log Patch: /home/oracle/patches/26133434/25586399 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-32-21AM_1.log Patch: /home/oracle/patches/26133434/26123830 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-32-21AM_1.log OPatchauto session completed at Thu Sep 21 02:41:44 2017 Time taken to complete the session 16 minutes, 9 seconds [root@vna02 12.2.0]# LsInventory Checks: GRIDHome Inventory [oracle@vna02 ~]$ . oraenv ORACLE_SID = [oracle] ? +ASM2 The Oracle base has been set to /u01/app/oracle [oracle@vna02 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH [oracle@vna02 ~]$ which opatch /u01/app/12.2.0/grid/OPatch/opatch [oracle@vna02 ~]$ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/12.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/12.2.0/grid/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2017-09-21_02-44-21AM_1.log Lsinventory Output file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-09-21_02-44-21AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: vna02 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Grid Infrastructure 12c 12.2.0.1.0 There are 1 products installed in this Oracle Home. Interim patches (3) : Patch 26123830 : applied on Thu Sep 21 02:34:08 BST 2017 Unique Patch ID: 21405588 Patch description: "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)" Created on 7 Jul 2017, 00:33:59 hrs PST8PDT Bugs fixed: 23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877 25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421 25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959 25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846 24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398 24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007 25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332 25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017 22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726 25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817 24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628 24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167 25967985 Patch 25586399 : applied on Thu Sep 21 02:33:51 BST 2017 Unique Patch ID: 21306685 Patch description: "ACFS Patch Set Update : 12.2.0.1.170718 (25586399)" Created on 16 Jun 2017, 00:35:19 hrs PST8PDT Bugs fixed: 24679041, 24964969, 25098392, 25078431, 25491831 Patch 26002778 : applied on Thu Sep 21 02:33:01 BST 2017 Unique Patch ID: 21306682 Patch description: "OCW Patch Set Update : 12.2.0.1.170718 (26002778)" Created on 3 Jul 2017, 03:26:30 hrs PST8PDT Bugs fixed: 26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375 25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495 25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658 25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035 25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158 25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126 25197395, 24808260 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@vna02 ~]$ DBHome Inventory: [oracle@vna02 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH [oracle@vna02 ~]$ which opatch /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch [oracle@vna02 ~]$ [oracle@vna02 ~]$ [oracle@vna02 ~]$ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-21_02-45-58AM_1.log Lsinventory Output file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-21_02-45-58AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: vna02 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 12c 12.2.0.1.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 26123830 : applied on Thu Sep 21 02:32:03 BST 2017 Unique Patch ID: 21405588 Patch description: "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)" Created on 7 Jul 2017, 00:33:59 hrs PST8PDT Bugs fixed: 23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877 25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421 25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959 25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846 24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398 24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007 25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332 25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017 22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726 25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817 24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628 24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167 25967985 Patch 26002778 : applied on Thu Sep 21 02:31:51 BST 2017 Unique Patch ID: 21306682 Patch description: "OCW Patch Set Update : 12.2.0.1.170718 (26002778)" Created on 3 Jul 2017, 03:26:30 hrs PST8PDT Bugs fixed: 26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375 25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495 25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658 25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035 25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158 25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126 25197395, 24808260 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@vna02 ~]$