GI and RDBMS - Patching Oracle 18c (18.3.2.0.0) to Oracle 18c (18.5.0.0.0) On Two-Node RAC in Multi-Tenant Environment Instance Type: Two Node RAC (orcl1 and orcl2) Container Database: orcl Pluggable Databases: pdb1 and pdb2 GRID Patch: p28828717_180000_Linux-x86-64.zip RDBMS Patch: p28822489_180000_Linux-x86-64.zip Before Patching Versions: GRID Version: Oracle 18c Enterprise Edition Release 18.3.2.0.0 RDBMS Version: Oracle 18c Enterprise Edition Release 18.3.2.0.0 After Patching Versions: GRID Version: Oracle 18c Enterprise Edition Release 18.5.0.0.0 RDBMS Version: Oracle 18c Enterprise Edition Release 18.5.0.0.0 Unzip GI and RDBMS patches in both the nodes (rac1-18c & rac2-18c) [oracle@rac1-18c ~]$ unzip p28828717_180000_Linux-x86-64.zip Archive: p28828717_180000_Linux-x86-64.zip creating: 28828717/ creating: 28828717/28547619/ creating: 28828717/28547619/files/ creating: 28828717/28547619/files/tomcat/ creating: 28828717/28547619/files/tomcat/lib/ inflating: 28828717/28547619/files/tomcat/lib/tomcat-juli.jar inflating: 28828717/28547619/files/tomcat/lib/servlet-api.jar inflating: 28828717/28547619/files/tomcat/lib/jaspic-api.jar inflating: 28828717/28547619/files/tomcat/lib/tomcat-util.jar inflating: 28828717/28547619/files/tomcat/lib/tomcat-api.jar inflating: 28828717/28547619/files/tomcat/lib/tomcat-jni.jar inflating: 28828717/28547619/files/tomcat/lib/catalina.jar inflating: 28828717/28547619/files/tomcat/lib/tomcat-util-scan.jar inflating: 28828717/28547619/files/tomcat/lib/annotations-api.jar inflating: 28828717/28547619/files/tomcat/lib/bootstrap.jar inflating: 28828717/28547619/files/tomcat/lib/tomcat-coyote.jar creating: 28828717/28547619/files/tomcat/conf/ [oracle@rac1-18c ~]$ [oracle@rac1-18c ~]$ unzip p28822489_180000_Linux-x86-64.zip Archive: p28822489_180000_Linux-x86-64.zip creating: 28822489/ creating: 28822489/files/ creating: 28822489/files/suptools/ extracting: 28822489/files/suptools/orachk.zip creating: 28822489/files/crs/ creating: 28822489/files/crs/install/ inflating: 28822489/files/crs/install/tfa_setup creating: 28822489/files/jlib/ inflating: 28822489/files/jlib/cryptojcommon.jar inflating: 28822489/files/jlib/jersey-server-2.25.1.jar replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y inflating: PatchSearch.xml [oracle@rac1-18c ~]$ scp p28828717_180000_Linux-x86-64.zip oracle@rac2-18c:/home/oracle p28828717_180000_Linux-x86-64.zip 100% 2135MB 59.9MB/s 00:35 [oracle@rac1-18c ~]$ [oracle@rac1-18c ~]$ scp p28822489_180000_Linux-x86-64.zip oracle@rac2-18c:/home/oracle p28822489_180000_Linux-x86-64.zip 100% 653MB 32.7MB/s 00:20 [oracle@rac1-18c ~]$ [oracle@rac1-18c ~]$ ssh rac2-18c [oracle@rac2-18c ~]$ unzip p28828717_180000_Linux-x86-64.zip Archive: p28828717_180000_Linux-x86-64.zip creating: 28828717/ creating: 28828717/28547619/ creating: 28828717/28547619/files/ creating: 28828717/28547619/files/tomcat/ creating: 28828717/28547619/files/tomcat/lib/ inflating: 28828717/28547619/files/tomcat/lib/tomcat-juli.jar inflating: 28828717/28547619/files/tomcat/lib/servlet-api.jar inflating: 28828717/28547619/files/tomcat/lib/jaspic-api.jar [oracle@rac2-18c ~]$ [oracle@rac2-18c ~]$ unzip p28822489_180000_Linux-x86-64.zip Archive: p28822489_180000_Linux-x86-64.zip creating: 28822489/ creating: 28822489/files/ creating: 28822489/files/suptools/ extracting: 28822489/files/suptools/orachk.zip creating: 28822489/files/crs/ creating: 28822489/files/crs/install/ inflating: 28822489/files/crs/install/tfa_setup creating: 28822489/files/jlib/ inflating: 28822489/files/jlib/cryptojcommon.jar inflating: 28822489/files/jlib/jersey-server-2.25.1.jar inflating: 28822489/files/jlib/osdt_core.jar inflating: 28822489/files/jlib/jersey-media-jaxb-2.25.1.jar replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y inflating: PatchSearch.xml [oracle@rac2-18c ~]$ exit logout Connection to rac2-18c closed. [oracle@rac1-18c ~]$ [oracle@rac1-18c ~]$ su - root Password: Last login: Thu Feb 14 18:26:31 EST 2019 on pts/0 [root@rac1-18c ~]# . oraenv ORACLE_SID = [root] ? +ASM1 The Oracle base has been set to /u01/app/grid [root@rac1-18c ~]# sh /u01/app/18.3.0/grid/OPatch/opatchauto apply /home/oracle/28828717 -oh /u01/app/18.3.0/grid/ OPatchauto session is initiated at Thu Feb 14 18:51:43 2019 System initialization log file is /u01/app/18.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-02-14_06-51-49PM.log. Session log file is /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/opatchauto2019-02-14_06-54-08PM.log The id for this session is XFUD Executing OPatch prereq operations to verify patch applicability on home /u01/app/18.3.0/grid Patch applicability verified successfully on home /u01/app/18.3.0/grid Bringing down CRS service on home /u01/app/18.3.0/grid CRS service brought down successfully on home /u01/app/18.3.0/grid Start applying binary patch on home /u01/app/18.3.0/grid Binary patch applied successfully on home /u01/app/18.3.0/grid Starting CRS service on home /u01/app/18.3.0/grid CRS service started successfully on home /u01/app/18.3.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac1-18c CRS Home:/u01/app/18.3.0/grid Version:18.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/28828717/28435192 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_18-56-26PM_1.log Patch: /home/oracle/28828717/28547619 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_18-56-26PM_1.log Patch: /home/oracle/28828717/28822489 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_18-56-26PM_1.log Patch: /home/oracle/28828717/28864593 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_18-56-26PM_1.log Patch: /home/oracle/28828717/28864607 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_18-56-26PM_1.log OPatchauto session completed at Thu Feb 14 19:07:39 2019 Time taken to complete the session 15 minutes, 56 seconds [root@rac1-18c ~]# [root@rac1-18c ~]# ps -ef | grep pmon oracle 11249 1 0 19:05 ? 00:00:00 asm_pmon_+ASM1 oracle 11509 1 0 19:05 ? 00:00:00 apx_pmon_+APX1 oracle 11556 1 0 19:05 ? 00:00:00 ora_pmon_orcl1 [root@rac1-18c ~]# [root@rac1-18c ~]# ssh rac2-18c root@rac2-18c's password: Last login: Thu Feb 14 15:35:22 2019 [root@rac2-18c ~]# . oraenv ORACLE_SID = [root] ? +ASM2 The Oracle base has been set to /u01/app/grid [root@rac2-18c ~]# sh /u01/app/18.3.0/grid/OPatch/opatchauto apply /home/oracle/28828717 -oh /u01/app/18.3.0/grid/ OPatchauto session is initiated at Thu Feb 14 19:08:27 2019 System initialization log file is /u01/app/18.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-02-14_07-08-34PM.log. Session log file is /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/opatchauto2019-02-14_07-10-50PM.log The id for this session is RSQD Executing OPatch prereq operations to verify patch applicability on home /u01/app/18.3.0/grid Patch applicability verified successfully on home /u01/app/18.3.0/grid Bringing down CRS service on home /u01/app/18.3.0/grid CRS service brought down successfully on home /u01/app/18.3.0/grid Start applying binary patch on home /u01/app/18.3.0/grid Binary patch applied successfully on home /u01/app/18.3.0/grid Starting CRS service on home /u01/app/18.3.0/grid CRS service started successfully on home /u01/app/18.3.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac2-18c CRS Home:/u01/app/18.3.0/grid Version:18.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/28828717/28435192 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_19-14-05PM_1.log Patch: /home/oracle/28828717/28547619 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_19-14-05PM_1.log Patch: /home/oracle/28828717/28822489 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_19-14-05PM_1.log Patch: /home/oracle/28828717/28864593 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_19-14-05PM_1.log Patch: /home/oracle/28828717/28864607 Log: /u01/app/18.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-14_19-14-05PM_1.log OPatchauto session completed at Thu Feb 14 19:46:47 2019 Time taken to complete the session 38 minutes, 20 seconds root@rac2-18c ~]# [root@rac2-18c ~]# su - oracle Last login: Thu Feb 14 19:46:41 EST 2019 [oracle@rac2-18c ~]$ . oraenv ORACLE_SID = [orcl] ? +ASM2 The Oracle base has been changed from /u01/app/oracle to /u01/app/grid [oracle@rac2-18c ~]$ [oracle@rac2-18c ~]$ sqlplus /nolog SQL*Plus: Release 18.0.0.0.0 - Production on Thu Feb 14 19:48:14 2019 Version 18.5.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. SQL> exit [oracle@rac2-18c ~]$ srvctl status database -d orcl Instance orcl1 is running on node rac1-18c Instance orcl2 is running on node rac2-18c [oracle@rac1-18c ~]$ . oraenv ORACLE_SID = [orcl] ? +ASM1 The Oracle base has been changed from /u01/app/oracle to /u01/app/grid [oracle@rac1-18c ~]$ sqlplus /nolog SQL*Plus: Release 18.0.0.0.0 - Production on Thu Feb 14 19:48:51 2019 Version 18.5.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. SQL> exit [oracle@rac1-18c ~]$ [oracle@rac1-18c ~]$ srvctl status database -d orcl Instance orcl1 is running on node rac1-18c Instance orcl2 is running on node rac2-18c [oracle@rac1-18c ~]$ ps -ef | grep pmon oracle 13016 1 0 10:59 ? 00:00:00 asm_pmon_+ASM1 oracle 14335 1 0 11:00 ? 00:00:00 apx_pmon_+APX1 oracle 14428 1 0 11:00 ? 00:00:00 mdb_pmon_-MGMTDB oracle 17479 1 0 11:02 ? 00:00:00 ora_pmon_orcl1 [oracle@rac1-18c ~]$ . oraenv ORACLE_SID = [orcl] ? +ASM1 The Oracle base has been changed from /u01/app/oracle to /u01/app/grid [oracle@rac1-18c ~]$ sqlplus / as sysasm SQL*Plus: Release 18.0.0.0.0 - Production on Fri Feb 15 11:05:15 2019 Version 18.5.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.5.0.0.0 SQL> exit Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.5.0.0.0 [oracle@rac1-18c ~]$ su - root Password: Last login: Thu Feb 14 19:51:42 EST 2019 on pts/0 [root@rac1-18c ~]# . oraenv ORACLE_SID = [root] ? +ASM1 The Oracle base has been set to /u01/app/grid [root@rac1-18c ~]# sh /u01/app/oracle/product/18.3.0/db_1/OPatch/opatchauto apply /home/oracle/28822489 -oh /u01/app/oracle/product/18.3.0/db_1/ OPatchauto session is initiated at Fri Feb 15 11:07:15 2019 System initialization log file is /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2019-02-15_11-08-11AM.log. Session log file is /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2019-02-15_11-21-07AM.log The id for this session is KI8E Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/18.3.0/db_1 Patch applicability verified successfully on home /u01/app/oracle/product/18.3.0/db_1 Verifying SQL patch applicability on home /u01/app/oracle/product/18.3.0/db_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/18.3.0/db_1 Preparing to bring down database service on home /u01/app/oracle/product/18.3.0/db_1 Successfully prepared home /u01/app/oracle/product/18.3.0/db_1 to bring down database service Bringing down database service on home /u01/app/oracle/product/18.3.0/db_1 Following database(s) and/or service(s) are stopped and will be restarted later during the session: orcl Database service successfully brought down on home /u01/app/oracle/product/18.3.0/db_1 Performing prepatch operation on home /u01/app/oracle/product/18.3.0/db_1 Perpatch operation completed successfully on home /u01/app/oracle/product/18.3.0/db_1 Start applying binary patch on home /u01/app/oracle/product/18.3.0/db_1 Binary patch applied successfully on home /u01/app/oracle/product/18.3.0/db_1 Performing postpatch operation on home /u01/app/oracle/product/18.3.0/db_1 Postpatch operation completed successfully on home /u01/app/oracle/product/18.3.0/db_1 Starting database service on home /u01/app/oracle/product/18.3.0/db_1 Database service successfully started on home /u01/app/oracle/product/18.3.0/db_1 Preparing home /u01/app/oracle/product/18.3.0/db_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/18.3.0/db_1 SQL patch applied successfully on home /u01/app/oracle/product/18.3.0/db_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac1-18c RAC Home:/u01/app/oracle/product/18.3.0/db_1 Version:18.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/28822489 Log: /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-15_11-28-01AM_1.log OPatchauto session completed at Fri Feb 15 11:43:48 2019 Time taken to complete the session 36 minutes, 41 seconds [root@rac1-18c ~]# ssh rac2-18c root@rac2-18c's password: Last login: Thu Feb 14 19:46:47 2019 [root@rac2-18c ~]# . oraenv ORACLE_SID = [root] ? +ASM2 The Oracle base has been set to /u01/app/grid [root@rac2-18c ~]# [root@rac2-18c ~]# sh /u01/app/oracle/product/18.3.0/db_1/OPatch/opatchauto apply /home/oracle/28822489 -oh /u01/app/oracle/product/18.3.0/db_1/ OPatchauto session is initiated at Fri Feb 15 11:47:49 2019 System initialization log file is /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2019-02-15_11-47-54AM.log. Session log file is /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2019-02-15_11-50-24AM.log The id for this session is 2D73 Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/18.3.0/db_1 Patch applicability verified successfully on home /u01/app/oracle/product/18.3.0/db_1 Verifying SQL patch applicability on home /u01/app/oracle/product/18.3.0/db_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/18.3.0/db_1 Preparing to bring down database service on home /u01/app/oracle/product/18.3.0/db_1 Successfully prepared home /u01/app/oracle/product/18.3.0/db_1 to bring down database service Bringing down database service on home /u01/app/oracle/product/18.3.0/db_1 Following database(s) and/or service(s) are stopped and will be restarted later during the session: orcl Database service successfully brought down on home /u01/app/oracle/product/18.3.0/db_1 Performing prepatch operation on home /u01/app/oracle/product/18.3.0/db_1 Perpatch operation completed successfully on home /u01/app/oracle/product/18.3.0/db_1 Start applying binary patch on home /u01/app/oracle/product/18.3.0/db_1 Binary patch applied successfully on home /u01/app/oracle/product/18.3.0/db_1 Performing postpatch operation on home /u01/app/oracle/product/18.3.0/db_1 Postpatch operation completed successfully on home /u01/app/oracle/product/18.3.0/db_1 Starting database service on home /u01/app/oracle/product/18.3.0/db_1 Database service successfully started on home /u01/app/oracle/product/18.3.0/db_1 Preparing home /u01/app/oracle/product/18.3.0/db_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/18.3.0/db_1 SQL patch applied successfully on home /u01/app/oracle/product/18.3.0/db_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac2-18c RAC Home:/u01/app/oracle/product/18.3.0/db_1 Version:18.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /home/oracle/28822489 Log: /u01/app/oracle/product/18.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-15_11-53-50AM_1.log OPatchauto session completed at Fri Feb 15 12:16:08 2019 Time taken to complete the session 28 minutes, 20 seconds [root@rac2-18c ~]# exit logout Connection to rac2-18c closed. [root@rac1-18c ~]# exit logout [oracle@rac1-18c ~]$ ps -ef | grep pmon oracle 1225 1 0 11:37 ? 00:00:00 ora_pmon_orcl1 oracle 13016 1 0 10:59 ? 00:00:00 asm_pmon_+ASM1 oracle 14335 1 0 11:00 ? 00:00:00 apx_pmon_+APX1 oracle 14428 1 0 11:00 ? 00:00:00 mdb_pmon_-MGMTDB [oracle@rac1-18c ~]$ . oraenv ORACLE_SID = [+ASM1] ? orcl The Oracle base has been changed from /u01/app/grid to /u01/app/oracle [oracle@rac1-18c ~]$ sqlplus /nolog SQL*Plus: Release 18.0.0.0.0 - Production on Fri Feb 15 12:38:59 2019 Version 18.5.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. SQL> connect sys/oracle@orcl as sysdba Connected. SQL> select banner_full from v$version; BANNER_FULL ---------------------------------------------------------------------- Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.5.0.0.0 SQL> exit Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.5.0.0.0 [oracle@rac1-18c ~]$ srvctl status database -d orcl Instance orcl1 is running on node rac1-18c Instance orcl2 is running on node rac2-18c [oracle@rac1-18c ~]$
Friday, February 15, 2019
GI and RDBMS - Patching Oracle 18c (18.3.2.0.0) to Oracle 18c (18.5.0.0.0) On Two-Node RAC in Multi-Tenant Environment
Subscribe to:
Post Comments (Atom)
what about ./datapatch -verbose
ReplyDeleteThis comment has been removed by the author.
ReplyDelete