The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Grid 12.2.0.1 as soon as it got released.
Download the RU 12.2.0.1.170718 for Linux
First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26133434 for Linux from MyOracle Support.
Applying the first RU for Oracle Grid 12.2.0.1
Then I unzipped the RU into my /u01 folder, set my environment and did the conflict check.
unzip p26133434_12201_Linux-x86-64.zip cd 26133434 [root@rac-ru1 ~]# opatchauto apply /u01/26133434/ -analyze -oh /u01/app/oracle/product/12.2.0.1/dbhome_1 OPatchauto session is initiated at Fri Jul 21 05:15:15 2017 System initialization log file is /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2017-07-21_05-15-17AM.log. Session log file is /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/opatchauto2017-07-21_05-15-21AM.log The id for this session is 9ZZT Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Patch applicablity verified successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Verifying patch inventory on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Patch inventory verified successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Verifying SQL patch applicablity on home /u01/app/oracle/product/12.2.0.1/dbhome_1 SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:rac-ru1 RAC Home:/u01/app/oracle/product/12.2.0.1/dbhome_1 ==Following patches were SKIPPED: Patch: /u01/26133434/25586399 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/26133434/26002778 Log: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-21_05-15-25AM_1.log Patch: /u01/26133434/26123830 Log: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-21_05-15-25AM_1.log OPatchauto session completed at Fri Jul 21 05:16:34 2017 Time taken to complete the session 1 minute, 19 seconds [root@rac-ru1 ~]#
It’s seem to be fine. Now start the apply the patch.
[root@rac-ru1 ~]# opatchauto apply /u01/26133434/ -oh /u01/app/oracle/product/12.2.0.1/dbhome_1 OPatchauto session is initiated at Fri Jul 21 05:17:17 2017 System initialization log file is /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2017-07-21_05-17-19AM.log. Session log file is /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/opatchauto2017-07-21_05-17-23AM.log The id for this session is IT4T Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Patch applicablity verified successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Verifying patch inventory on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Patch inventory verified successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Verifying SQL patch applicablity on home /u01/app/oracle/product/12.2.0.1/dbhome_1 SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Preparing to bring down database service on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Successfully prepared home /u01/app/oracle/product/12.2.0.1/dbhome_1 to bring down database service Bringing down database service on home /u01/app/oracle/product/12.2.0.1/dbhome_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/12.2.0.1/dbhome_1 Performing prepatch operation on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Starting database service on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Database service successfully started on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Preparing home /u01/app/oracle/product/12.2.0.1/dbhome_1 after database service restarted No step execution required......... Prepared home /u01/app/oracle/product/12.2.0.1/dbhome_1 successfully after database service restarted Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0.1/dbhome_1 SQL patch applied successfully on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Verifying patches applied on home /u01/app/oracle/product/12.2.0.1/dbhome_1 Patch verification completed with warning on home /u01/app/oracle/product/12.2.0.1/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac-ru1 RAC Home:/u01/app/oracle/product/12.2.0.1/dbhome_1 Summary: ==Following patches were SKIPPED: Patch: /u01/26133434/25586399 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /u01/26133434/26002778 Log: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-21_05-19-10AM_1.log Patch: /u01/26133434/26123830 Log: /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-21_05-19-10AM_1.log OPatchauto session completed at Fri Jul 21 05:21:54 2017 Time taken to complete the session 4 minutes, 37 seconds
Check the changes
using the opatch, we can check the patch is successful or not.
[oracle@rac-ru1 ~]$ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.8 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.2.0.1/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.8 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2017-07-21_05-22-47AM_1.log Lsinventory Output file location : /u01/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-07-21_05-22-47AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: rac-ru1.compute-gbvodafone.oraclecloud.internal 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 Fri Jul 21 05:20:08 UTC 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 Fri Jul 21 05:19:38 UTC 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.
Applying SQL changes
Finally I’ll have to apply the necessary SQL changes with datapatch:
[oracle@rac-ru2 26133434]$ datapatch -verbose SQL Patching tool version 12.2.0.1.0 Production on Fri Jul 21 05:58:53 2017 Copyright (c) 2012, 2017, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_2934_2017_07_21_05_58_53/sqlpatch_invocation.log Connecting to database...OK Note: Datapatch will only apply or rollback SQL fixes for PDBs that are in an open state, no patches will be applied to closed PDBs. Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation (Doc ID 1585822.1) Bootstrapping registry and package to current versions...done Determining current state...done Current state of SQL patches: Bundle series DBRU: ID 170718 in the binary registry and ID 170718 in PDB CDB$ROOT, ID 170718 in PDB PDB$SEED, ID 170718 in PDB PDB1 Adding patches to installation queue and performing prereq checks... Installation queue: For the following PDBs: CDB$ROOT PDB$SEED PDB1 Nothing to roll back Nothing to apply SQL Patching tool complete on Fri Jul 21 05:59:55 2017
Check if the patches have been applied successfully
SQL> SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time, action, status, description, version, patch_id, bundle_series FROM sys.dba_registry_sqlpatch ORDER by action_time; ACTION_TIME ACTION STATUS DESCRIPTION VERSION PATCH_ID BUNDLE_SER -------------------- ---------- ---------- ---------------------------------------- ---------- ---------- ---------- 21-JUL-2017 05:57:12 APPLY SUCCESS DATABASE RELEASE UPDATE 12.2.0.1.170718 12.2.0.1 26123830 DBRU SQL> exec dbms_qopatch.get_sqlpatch_status; Patch Id : 26123830 Action : APPLY Action Time : 21-JUL-2017 05:57:12 Description : DATABASE RELEASE UPDATE 12.2.0.1.170718 Logfile : /u01/app/oracle/cfgtoollogs/sqlpatch/26123830/21405588/26123830_apply_ORCL_CDBROOT_2017Jul21_05_55_49.log Status : SUCCESS PL/SQL procedure successfully completed.
