RAC Patching Understanding | Rolling Vs Non-Rolling

RAC Patching Understanding – Rolling Vs Non-Rolling? Oracle Release Quarterly Patches, In a year 4 times Oracle will releases patches. Patches: Quarterly JAN - (17 to 21) APR - (17 to 21) JUL - (17 to 21) OCT - (17 to 21) What are the different times of Patching Methods in Oracle RAC? - Rolling and Non-Rolling RAC Patching Methods: Rolling Patching: Patching one node at a time = Node1 - Node2 - Node3 - Node4 - No downtime needed - Patching duration is longer Non-Rolling Patching Patching all nodes at a time = Node1 & Node2 & Node3 & Node4 - Complete downtime - Patching duration is smaller oraclelab1: +ASM1 & DEVDB1 oraclelab2: +ASM2 & DEVDB2 Rolling Patching Steps: Steps 1: Node1 Patching 1. Patch GI Home - OPatch 2. Patch DB Home - OPatch Steps Node2 Patching 1. Patch GI Home - OPatch 2. Patch DB Home - OPatch Step 3: Patch databases - DEVDB - datapatch (Perform from any of Node1 or Node2 database instance) Non-Rolling Patching Steps: Steps 1: Node1 & Node2 Patching together Node1: Node2: 1. Patch GI Home - OPatch 1. Patch GI Home - OPatch 2. Patch DB Home - OPatch 2. Patch DB Home - OPatch Step 2: Patch databases - DEVDB - datapatch (Perform from any of Node1 or Node2 database instance) Tools used for patching: 1. Patch GI Home Patching using - Opatch 2. Patch DB Home Patching using - Opatch 3. Patch databases using - datapatch GI Software & Oracle Software - Base software - Downloaded freely from oracle.edelivery.com - Install GI Home & Oracle Home Patches - are downloaded in support.oracle.com - You need a license Patches - we will apply on top of base software (GI Home & Oracle Home) - BUG fixes - New enhancements - Security fixes - Vulnerability fixes - New features How many times customer needs to apply the patches? - It depends on the customer and it best practice to apply the 4 times all 4 quarterly patches 1. All 4 times in a years 2. 2 times in a years 3. 1 times in a year When Oracle release patches on quarterly? Patches: Quarterly JAN - (17 to 21) APR - (17 to 21) JUL - (17 to 21) OCT - (17 to 21) What is base release or RU? - GI and Oracle Home software whatever releases by Oracle in the base software. - Whatever the quarterly patches oracle releases are called RU – release updates. GI Home - /u01/app/19.0.0.0/grid DB Home - /u01/app/oracle/product/19.0.0.0/dbhome_1 GI and OH home: We installed 19c GI Home - Base Software (19.3) We installed 19c DB home - Base Software (19.3) RU-Release Updates: 19c - Quarterly Patches called as RU - Release updates JAN - (17 to 21) APR - (17 to 21) JUL - (17 to 21) OCT - (17 to 21) Apr - 2019 - 19.3 Jul - 2019 - 19.4 Oct - 2019 - 19.5 Jan - 2020 - 19.6 Apr - 2020 - 19.7 Jul - 2020 - 19.8 Oct - 2020 - 19.9 Jan - 2021 - 19.10 Apr - 2021 - 19.11 Jul - 2021 - 19.12 Oct - 2021 - 19.13 Jan - 2022 - 19.14 Apr - 2022 - 19.15 Jul - 2022 - 19.16 Oct - 2022 - 19.17 Jan - 2023 - 19.18 Apr - 2023 - 19.19 Jul - 2023 - 19.20 Oct - 2023 - 19.21 Jan - 2024 - 19.22 Apr - 2024 - 19.23 Jul - 2024 - 19.24 Oct - 2024 - Node1 GI and OH Patches: [oracle@hostnode1 ~]$ /u01/app/19.0.0.0/grid/OPatch/opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) 29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763) [oracle@hostnode1 ~]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) Node2 GI and OH Patches: [oracle@hostnode2 ~]$ /u01/app/19.0.0.0/grid/OPatch/opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) 29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763) [oracle@hostnode2 ~]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) #rac #database #asm #mallik034 #vismotechnologies #oracledba #oraclecarrers #oracleworld #training #onlinetraining #liveclasses #Patching #GIPatching #OHPatching Regards, Mallikarjun / Vismo Technologies WhatsApp: +91 9880616848 / +91 9036478079 Cell: +91 9880616848 / +91 9036478079 Email: [email protected] / [email protected] / [email protected]