Applying GI Release Update 19.8.0.0.200714 & Database Release Update 19.8.0.0.0 to Oracle 19c (19.3.0.0.0) - 3-Node RAC ------------------------------------------------------------------------------------------------------------------------- Required Softwares: ------------------- Latest OPatch: p6880880_190000_Linux-x86-64.zip GI Release Update (July 2020): p31305339_190000_Linux-x86-64.zip Database Release Update (July 2020): p31281355_190000_Linux-x86-64.zip Check the status of cluster instances: -------------------------------------- [oracle@19c-rac1 ~]$ srvctl status database -d cdbrac Instance cdbrac1 is running on node 19c-rac1 Instance cdbrac2 is running on node 19c-rac2 Instance cdbrac3 is running on node 19c-rac3 [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ . oraenv ORACLE_SID = [cdbrac] ? cdbrac The Oracle base remains unchanged with value /u01/app/oracle [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ sqlplus sys/oracle@cdbrac as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 17 11:58:16 2020 Version 19.7.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.7.0.0.0 SQL> select instance_name,instance_number from gv$instance order by instance_number; INSTANCE_NAME INSTANCE_NUMBER ---------------- --------------- cdbrac1 1 cdbrac2 2 cdbrac3 3 SQL> Copy latest OPatch (12.2.0.1.21), GRID RU (p31305339_190000_Linux-x86-64.zip) and RDBMS RU (p31281355_190000_Linux-x86-64.zip) ------------------------------------------------------------------------------------------------------------------------------- [oracle@19c-rac1 ~]$ scp *.zip oracle@192.168.2.20:/home/oracle/ p31281355_190000_Linux-x86-64.zip 100% 1295MB 56.3MB/s 00:23 p31305339_190000_Linux-x86-64.zip 100% 2490MB 53.0MB/s 00:47 p6880880_190000_Linux-x86-64.zip 100% 113MB 56.4MB/s 00:02 [oracle@19c-rac1 ~]$ [oracle@19c-rac2 ~]$ scp *.zip oracle@192.168.2.30:/home/oracle/ p31281355_190000_Linux-x86-64.zip 100% 1295MB 51.8MB/s 00:25 p31305339_190000_Linux-x86-64.zip 100% 2490MB 49.8MB/s 00:50 p6880880_190000_Linux-x86-64.zip 100% 113MB 37.6MB/s 00:03 [oracle@19c-rac2 ~]$ Update latest OPatch in GI and RDBMS homes: ------------------------------------------- [oracle@19c-rac1 ~]$ unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid/ [oracle@19c-rac1 ~]$ unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1/ [oracle@19c-rac2 ~]$ unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid/ [oracle@19c-rac2 ~]$ unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1/ [oracle@19c-rac3 ~]$ unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid/ [oracle@19c-rac3 ~]$ unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1/ Run OPatch Conflict Check ========================= [oracle@19c-rac1 ~]$ sh /u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/31 31281355/ 31305339/ [oracle@19c-rac1 ~]$ sh /u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/31305339/31281355/ Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-07-17_23-13-59PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ sh /u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/31305339/31305087 Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-07-17_23-15-35PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ sh /u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/31305339/31304218 Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-07-17_23-15-51PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ sh /u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/31305339/ Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-07-17_23-15-59PM_1.log This command doesn't support System Patch. OPatch failed with error code 21 [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ sh /u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/31305339/31335188 Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2020-07-17_23-16-11PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@19c-rac1 ~]$ As a Oracle User: ================= [oracle@19c-rac1 ~]$ sh /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/31305339/31281355 Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2020-07-17_23-18-06PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ sh /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/31305339/31305087 Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2020-07-17_23-18-34PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@19c-rac1 ~]$ Run OPatch SystemSpace Check: ============================== [oracle@19c-rac1 ~]$ . oraenv ORACLE_SID = [+ASM1] ? cdbrac The Oracle base remains unchanged with value /u01/app/oracle [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ sh /u01/app/19.3.0/grid/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2020-07-17_23-26-45PM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. [oracle@19c-rac1 ~]$ To patch the GI home and all Oracle RAC database homes of the same version: --------------------------------------------------------------------------- [root@19c-rac1 ~]# . oraenv ORACLE_SID = [root] ? +ASM1 The Oracle base has been set to /u01/app/oracle [root@19c-rac1 ~]# [root@19c-rac1 ~]# sh /u01/app/19.3.0/grid/OPatch/opatchauto apply /home/oracle/31305339 OPatchauto session is initiated at Fri Jul 17 23:28:25 2020 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-07-17_11-28-29PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2020-07-17_11-29-09PM.log The id for this session is 46DR Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/19.3.0/grid Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/dbhome_1 Successfully prepared home /u01/app/oracle/product/19.3.0/dbhome_1 to bring down database service Bringing down CRS service on home /u01/app/19.3.0/grid CRS service brought down successfully on home /u01/app/19.3.0/grid Performing prepatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Perpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/19.3.0/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/19.3.0/grid Binary patch applied successfully on home /u01/app/19.3.0/grid Starting CRS service on home /u01/app/19.3.0/grid CRS service started successfully on home /u01/app/19.3.0/grid Preparing home /u01/app/oracle/product/19.3.0/dbhome_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:19c-rac1 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /home/oracle/31305339/31304218 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /home/oracle/31305339/31335188 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/31305339/31281355 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-17_23-36-23PM_1.log Patch: /home/oracle/31305339/31305087 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-17_23-36-23PM_1.log Host:19c-rac1 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/31305339/31281355 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-17_23-41-50PM_1.log Patch: /home/oracle/31305339/31304218 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-17_23-41-50PM_1.log Patch: /home/oracle/31305339/31305087 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-17_23-41-50PM_1.log Patch: /home/oracle/31305339/31335188 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-17_23-41-50PM_1.log OPatchauto session completed at Fri Jul 17 23:57:46 2020 Time taken to complete the session 29 minutes, 21 seconds [root@19c-rac1 ~]# Second Node: 19c-rac2 ---------------------- [oracle@19c-rac2 ~]$ su - root Password: [root@19c-rac2 ~]# . oraenv ORACLE_SID = [root] ? +ASM2 The Oracle base has been set to /u01/app/oracle [root@19c-rac2 ~]# [root@19c-rac2 ~]# sh /u01/app/19.3.0/grid/OPatch/opatchauto apply /home/oracle/31305339 OPatchauto session is initiated at Sat Jul 18 00:00:53 2020 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-07-18_12-00-57AM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2020-07-18_12-01-21AM.log The id for this session is QIXV Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/dbhome_1 Successfully prepared home /u01/app/oracle/product/19.3.0/dbhome_1 to bring down database service Bringing down CRS service on home /u01/app/19.3.0/grid CRS service brought down successfully on home /u01/app/19.3.0/grid Performing prepatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Perpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/19.3.0/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/19.3.0/grid Binary patch applied successfully on home /u01/app/19.3.0/grid Starting CRS service on home /u01/app/19.3.0/grid CRS service started successfully on home /u01/app/19.3.0/grid Preparing home /u01/app/oracle/product/19.3.0/dbhome_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:19c-rac2 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /home/oracle/31305339/31304218 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /home/oracle/31305339/31335188 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/31305339/31281355 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-05-12AM_1.log Patch: /home/oracle/31305339/31305087 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-05-12AM_1.log Host:19c-rac2 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/31305339/31281355 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-10-52AM_1.log Patch: /home/oracle/31305339/31304218 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-10-52AM_1.log Patch: /home/oracle/31305339/31305087 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-10-52AM_1.log Patch: /home/oracle/31305339/31335188 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-10-52AM_1.log OPatchauto session completed at Sat Jul 18 00:31:50 2020 Time taken to complete the session 30 minutes, 57 seconds [root@19c-rac2 ~]# Third Node: 19c-rac3: ---------------------- [oracle@19c-rac3 ~]$ su - root Password: [root@19c-rac3 ~]# . oraenv ORACLE_SID = [root] ? +ASM3 The Oracle base has been set to /u01/app/oracle [root@19c-rac3 ~]# [root@19c-rac3 ~]# sh /u01/app/19.3.0/grid/OPatch/opatchauto apply /home/oracle/31305339 OPatchauto session is initiated at Sat Jul 18 00:33:22 2020 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-07-18_12-33-26AM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2020-07-18_12-33-51AM.log The id for this session is SJV7 Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/dbhome_1 Successfully prepared home /u01/app/oracle/product/19.3.0/dbhome_1 to bring down database service Bringing down CRS service on home /u01/app/19.3.0/grid CRS service brought down successfully on home /u01/app/19.3.0/grid Performing prepatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Perpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/19.3.0/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/19.3.0/grid Binary patch applied successfully on home /u01/app/19.3.0/grid Starting CRS service on home /u01/app/19.3.0/grid CRS service started successfully on home /u01/app/19.3.0/grid Preparing home /u01/app/oracle/product/19.3.0/dbhome_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:19c-rac3 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /home/oracle/31305339/31304218 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /home/oracle/31305339/31335188 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/31305339/31281355 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-40-38AM_1.log Patch: /home/oracle/31305339/31305087 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-40-38AM_1.log Host:19c-rac3 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/31305339/31281355 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-46-06AM_1.log Patch: /home/oracle/31305339/31304218 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-46-06AM_1.log Patch: /home/oracle/31305339/31305087 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-46-06AM_1.log Patch: /home/oracle/31305339/31335188 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-07-18_00-46-06AM_1.log OPatchauto session completed at Sat Jul 18 01:41:24 2020 Time taken to complete the session 68 minutes, 2 seconds [root@19c-rac3 ~]# Grid Home: ---------- [oracle@19c-rac1 ~]$ . oraenv ORACLE_SID = [cdbrac1] ? +ASM1 The Oracle base remains unchanged with value /u01/app/oracle [oracle@19c-rac1 ~]$ sh /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lspatches 31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188) 31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087) 31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218) 31281355;Database Release Update : 19.8.0.0.200714 (31281355) OPatch succeeded. [oracle@19c-rac1 ~]$ RDBMS Home: ----------- [oracle@19c-rac1 ~]$ sh /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lspatches 31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087) 31281355;Database Release Update : 19.8.0.0.200714 (31281355) OPatch succeeded. [oracle@19c-rac1 ~]$ [oracle@19c-rac1 ~]$ . oraenv ORACLE_SID = [+ASM1] ? cdbrac The Oracle base remains unchanged with value /u01/app/oracle [oracle@19c-rac1 ~]$ srvctl status database -d cdbrac Instance cdbrac1 is running on node 19c-rac1 Instance cdbrac2 is running on node 19c-rac2 Instance cdbrac3 is running on node 19c-rac3 [oracle@19c-rac1 ~]$
Friday, July 17, 2020
Applying GRID RU (19.8.0.0.200714) & Database RU (19.8.0.0.0) to Oracle 19c (19.3.0.0.0) - 3-Node RAC
Subscribe to:
Post Comments (Atom)
Hello sir,
ReplyDeleteBelow is my current database version.
[oracle@servername OPatch]$ ./opatch lspatches
30869156;Database Release Update : 19.7.0.0.200414 (30869156)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
OPatch succeeded.
I would like to apply latest July2020 patch,which are the options 19.7.0.0.200714 or 19.8.0.0.200414 . Please explain