Oracle 12cR2 (12.2.0.1) grid ve db home’una ilk yayınlanan RU (Release Update) patch’lerini platformunuza göre metalinkten indirip aşağıdaki gibi geçebilirsiniz. Öncesinde conflict check yapmayı unutmayın.
Patch 26133434 – Grid Infrastructure Jul2017 Release Update 12.2.0.1.170718 -> p26133434_122010_Linux-x86-64.zip
OPatch patch of version 12.2.0.1.9 for Oracle software releases 12.1.0.x (installer) and 12.2.0.x (MAY 2017) -> p6880880_122010_Linux-x86-64.zip
ORACLE_HOME=/oracle/app/oracle/product/12.2.0.1/dbhome_1
GRID_HOME=/oracle/app/grid
mv /oracle/app/grid/OPatch /oracle/app/grid/OPatch_10082017
mv /oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch /oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch_10082017
cp -R /backup/SETUP/OPatch/OPatch /oracle/app/grid
cp -R /backup/SETUP/OPatch/OPatch /oracle/app/oracle/product/12.2.0.1/dbhome_1
cd /oracle/app/grid
chown -R oracle:oinstall OPatch
chmod 755 OPatch
ls -la
cd /oracle/app/oracle/product/12.2.0.1/dbhome_1
chown -R oracle:oinstall OPatch
chmod 755 OPatch
ls -la
[oracle@testdb01 ~]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.9 OPatch succeeded. [oracle@testdb01 ~]$
[oracle@testdb01 psu_for_12cr2]$ ls -la total 953420 drwxr-xr-x 2 oracle oinstall 4096 Aug 15 11:27 . drwxrwxrwx. 9 oracle oinstall 4096 Aug 10 15:07 .. -rwxr-xr-x 1 oracle oinstall 976259134 Aug 10 14:52 p26133434_122010_Linux-x86-64.zip [oracle@testdb01 psu_for_12cr2]$ unzip p26133434_122010_Linux-x86-64.zip
–for grid home as oracle user;
/oracle/app/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26123830
/oracle/app/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26002778
/oracle/app/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/25586399
–for db home as oracle user;
/oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26123830
/oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26002778
[oracle@testdb01 psu_for_12cr2]$ /oracle/app/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26123830 Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1 Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2017-08-15_11-30-59AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@testdb01 psu_for_12cr2]$
--patch for grid and db home; [root@testdb01 ~]# export PATH=$PATH:/oracle/app/grid/OPatch [root@testdb01 ~]# cd /oracle/app/grid/OPatch [root@testdb01 OPatch]# opatchauto apply /backup/SETUP/psu_for_12cr2/26133434 OPatchauto session is initiated at Tue Aug 15 11:45:26 2017 System initialization log file is /oracle/app/grid/cfgtoollogs/opatchautodb/systemconfig2017-08-15_11-45-29AM.log. Session log file is /oracle/app/grid/cfgtoollogs/opatchauto/opatchauto2017-08-15_11-45-36AM.log The id for this session is ADRE Executing OPatch prereq operations to verify patch applicability on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Patch applicability verified successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Verifying SQL patch applicability on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 SQL patch applicability verified successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Executing OPatch prereq operations to verify patch applicability on home /oracle/app/grid Patch applicability verified successfully on home /oracle/app/grid Preparing to bring down database service on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Successfully prepared home /oracle/app/oracle/product/12.2.0.1/dbhome_1 to bring down database service Bringing down database service on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Following database has been stopped and will be restarted later during the session: fbcmsprd Database service successfully brought down on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Bringing down CRS service on home /oracle/app/grid Prepatch operation log file location: /oracle/app/oracle/crsdata/testdb01/crsconfig/hapatch_2017-08-15_11-48-40AM.log CRS service brought down successfully on home /oracle/app/grid Start applying binary patch on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Binary patch applied successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Start applying binary patch on home /oracle/app/grid Binary patch applied successfully on home /oracle/app/grid Starting CRS service on home /oracle/app/grid Postpatch operation log file location: /oracle/app/oracle/crsdata/testdb01/crsconfig/hapatch_2017-08-15_11-58-19AM.log CRS service started successfully on home /oracle/app/grid Starting database service on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Database service successfully started on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 Preparing home /oracle/app/oracle/product/12.2.0.1/dbhome_1 after database service restarted No step execution required......... Prepared home /oracle/app/oracle/product/12.2.0.1/dbhome_1 successfully after database service restarted Trying to apply SQL patch on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 SQL patch applied successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:testdb01 SIDB Home:/oracle/app/oracle/product/12.2.0.1/dbhome_1 Summary: ==Following patches were SKIPPED: Patch: /backup/SETUP/psu_for_12cr2/26133434/25586399 Reason: This patch is not applicable to this specified target type - "oracle_database" ==Following patches were SUCCESSFULLY applied: Patch: /backup/SETUP/psu_for_12cr2/26133434/26002778 Log: /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-49-22AM_1.log Patch: /backup/SETUP/psu_for_12cr2/26133434/26123830 Log: /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-49-22AM_1.log Host:testdb01 SIHA Home:/oracle/app/grid Summary: ==Following patches were SUCCESSFULLY applied: Patch: /backup/SETUP/psu_for_12cr2/26133434/26002778 Log: /oracle/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-52-04AM_1.log Patch: /backup/SETUP/psu_for_12cr2/26133434/25586399 Log: /oracle/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-52-04AM_1.log Patch: /backup/SETUP/psu_for_12cr2/26133434/26123830 Log: /oracle/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-52-04AM_1.log OPatchauto session completed at Tue Aug 15 12:06:51 2017 Time taken to complete the session 21 minutes, 26 seconds [root@testdb01 OPatch]#
[oracle@testdb01 ~]$ echo $ORACLE_HOME /oracle/app/grid/ [oracle@testdb01 ~]$ $ORACLE_HOME/OPatch/opatch lspatches 26123830;DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830) 25586399;ACFS Patch Set Update : 12.2.0.1.170718 (25586399) 26002778;OCW Patch Set Update : 12.2.0.1.170718 (26002778) OPatch succeeded. [oracle@testdb01 ~]$ [oracle@testdb01 ~]$ export ORACLE_HOME=/oracle/app/oracle/product/12.2.0.1/dbhome_1 [oracle@testdb01 ~]$ [oracle@testdb01 ~]$ $ORACLE_HOME/OPatch/opatch lspatches 26123830;DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830) 26002778;OCW Patch Set Update : 12.2.0.1.170718 (26002778) OPatch succeeded. [oracle@testdb01 ~]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.9 OPatch succeeded. [oracle@testdb01 ~]$ [oracle@testdb01 ~]$ /oracle/app/grid/OPatch/opatch lsinventory -detail -oh /oracle/app/grid/ Oracle Interim Patch Installer version 12.2.0.1.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/grid Central Inventory : /oracle/app/oraInventory from : /oracle/app/grid//oraInst.loc OPatch version : 12.2.0.1.9 OUI version : 12.2.0.1.4 Log file location : /oracle/app/grid/cfgtoollogs/opatch/opatch2017-08-15_12-25-04PM_1.log Lsinventory Output file location : /oracle/app/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-08-15_12-25-04PM.txt Installed Top-level Products (1): Oracle Grid Infrastructure 12c 12.2.0.1.0 There are 1 products installed in this Oracle Home. Installed Products (99): ... ... There are 99 products installed in this Oracle Home. Interim patches (3) : Patch 26123830 : applied on Tue Aug 15 11:57:35 EEST 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 Files Touched: /lpu.o --> ORACLE_HOME/lib/libcore12.a libcell12.so --> ORACLE_HOME/lib/libcell12.so ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/libasmclntsh12.ohso ... ... Patch Location in Inventory: Patch Location in Inventory: /oracle/app/grid/inventory/oneoffs/26123830 Patch Location in Storage area: /oracle/app/grid/.patch_storage/26123830_Jul_7_2017_00_33_59 Patch 25586399 : applied on Tue Aug 15 11:56:55 EEST 2017Unique Patch ID: 21306685Patch 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 Files Touched: ... ... oracle_version.h --> ORACLE_HOME/usm/public/oracle_version.h security.xsd --> ORACLE_HOME/usm/xml/schema/security.xsd Patch Location in Inventory: /oracle/app/grid/inventory/oneoffs/25586399 Patch Location in Storage area: /oracle/app/grid/.patch_storage/25586399_Jun_16_2017_00_35_19 Patch 26002778 : applied on Tue Aug 15 11:53:57 EEST 2017 Patch 26002778 : applied on Tue Aug 15 11:53:57 EEST 2017Unique Patch ID: 21306682Patch 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 Files Touched: ... ... Patch Location in Inventory: /oracle/app/grid/inventory/oneoffs/26002778 Patch Location in Storage area: /oracle/app/grid/.patch_storage/26002778_Jul_3_2017_03_26_30 -------------------------------------------------------------------------------- OPatch succeeded.[oracle@testdb01 ~]$
/oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch lsinventory -detail -oh /oracle/app/oracle/product/12.2.0.1/dbhome_1/
Release Schedule of Current Database Releases (Doc ID 742060.1)
Release Update and Release Update Revisions for Database Proactive Patch Program (Doc ID 2285040.1)
Orhan Eripek's Oracle Blog 