Nächste Patchrunde: Grid Infrastructure – Release Update 12.2.0.1.20170718
Nach der Installation von Datenbank- und OJVM-Release Update 12.2.0.1.20170718 geht es jetzt an die Installation des nächsten Release Updates: Grid Infrastructure Release Update 12.2.0.1-20170718 (Patch 26133434).
Update 16.08.2017
Oracle hat diesen Release-Update durch den RU 12.2.0.1.170814 ersetzt.
Ausgangssituation:
2-Node-Linux Cluster:
grid@ernie:~/ [-MGMTDB] olsnodes ernie bert grid@ernie:~/ [-MGMTDB] cat /etc/oracle-release Oracle Linux Server release 7.3
Installierte Software:
grid@ernie:~/ [-MGMTDB] $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.6 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u00/app/grid/product/12.2.0.1 Central Inventory : /u00/app/oraInventory from : /u00/app/grid/product/12.2.0.1/oraInst.loc OPatch version : 12.2.0.1.6 OUI version : 12.2.0.1.4 Log file location : /u00/app/grid/product/12.2.0.1/cfgtoollogs/opatch/opatch2017-07-20_20-42-10PM_1.log Lsinventory Output file location : /u00/app/grid/product/12.2.0.1/cfgtoollogs/opatch/lsinv/lsinventory2017-07-20_20-42-10PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: ernie.markusdba.net ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Grid Infrastructure 12c 12.2.0.1.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home.
Auf dem Cluster ist auch Datenbanksoftware installiert (12.2.0.1.0) und es läuft eine RAC One Node-Datenbank.
Vorbereitungen:
Software runterladen und auf den Servern bereitstellen grid@ernie:/u00/app/oracle/stage/ [-MGMTDB] ls -l total 1031776 -rw-r--r--. 1 grid oinstall 976258939 Jul 20 20:43 p26133434_122010_Linux-x86-64-GI.zip -rw-r--r--. 1 grid oinstall 80276058 Jul 20 20:43 p6880880_122010_Linux-x86-64.zip opatch auf beiden Servern aktualisieren root@ernie:/u00/app/grid/product/12.2.0.1/ [-MGMTDB] mv OPatch OPatch.backup.20170720 root@ernie:/u00/app/grid/product/12.2.0.1/ [-MGMTDB] mkdir OPatch root@ernie:/u00/app/grid/product/12.2.0.1/ [-MGMTDB] chown grid:oinstall Opatch root@ernie:/u00/app/grid/product/12.2.0.1/ [-MGMTDB] exit exit grid@ernie:/u00/app/grid/product/12.2.0.1/ [-MGMTDB] unzip /u00/app/oracle/stage/p6880880_122010_Linux-x86-64.zip [..] grid@ernie:/u00/app/grid/product/12.2.0.1/ [-MGMTDB] cd /u00/app/oracle/stage/ grid@ernie:/u00/app/oracle/stage/ [-MGMTDB] scp p6880880_122010_Linux-x86-64.zip bert:/u00/app/oracle/stage/. p6880880_122010_Linux-x86-64.zip 100% 77MB 76.6MB/s 00:01 grid@ernie:/u00/app/oracle/stage/ [-MGMTDB] ssh bert Last login: Thu Jul 20 20:42:44 2017 grid@bert:~/ [+ASM2] cd /u00/app/grid/product/12.2.0.1/ grid@bert:/u00/app/grid/product/12.2.0.1/ [+ASM2] su Password: root@bert:/u00/app/grid/product/12.2.0.1/ [+ASM2] mv OPatch/ OPatch.backup.20170720 root@bert:/u00/app/grid/product/12.2.0.1/ [+ASM2] mkdir OPatch root@bert:/u00/app/grid/product/12.2.0.1/ [+ASM2] chown grid:oinstall OPatch root@bert:/u00/app/grid/product/12.2.0.1/ [+ASM2] exit exit grid@bert:/u00/app/grid/product/12.2.0.1/ [+ASM2] unzip /u00/app/oracle/stage/p6880880_122010_Linux-x86-64.zip [..]
Opatch-Version checken
grid@ernie:/u00/app/oracle/stage/ [-MGMTDB] $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.9 OPatch succeeded.
Lt. Patch-Readme ist mindestens 12.2.0.1.7 erforderlich.
Release-Update auspacken
grid@ernie:/u00/app/oracle/stage/ [-MGMTDB] cd /u00/app/oracle/stage/ grid@ernie:/u00/app/oracle/stage/ [-MGMTDB] ls p26133434_122010_Linux-x86-64-GI.zip p6880880_122010_Linux-x86-64.zip grid@ernie:/u00/app/oracle/stage/ [-MGMTDB] unzip p26133434_122010_Linux-x86-64-GI.zip [..] grid@ernie:/u00/app/oracle/stage/ [-MGMTDB] cd 26133434/ /u00/app/oracle/stage/26133434
Patch installieren
grid@ernie:/u00/app/oracle/stage/26133434/ [-MGMTDB] su Password: root@ernie:/u00/app/oracle/stage/26133434/ [-MGMTDB] $ORACLE_HOME/OPatch/opatchauto apply OPatchauto session is initiated at Thu Jul 20 20:59:03 2017 System initialization log file is /u00/app/grid/product/12.2.0.1/cfgtoollogs/opatchautodb/systemconfig2017-07-20_08-59-06PM.log. Session log file is /u00/app/grid/product/12.2.0.1/cfgtoollogs/opatchauto/opatchauto2017-07-20_09-00-01PM.log The id for this session is XGMW Executing OPatch prereq operations to verify patch applicability on home /u00/app/grid/product/12.2.0.1 Executing OPatch prereq operations to verify patch applicability on home /u00/app/oracle/product/12.2.0.1 Patch applicability verified successfully on home /u00/app/grid/product/12.2.0.1 Patch applicability verified successfully on home /u00/app/oracle/product/12.2.0.1 Verifying SQL patch applicability on home /u00/app/oracle/product/12.2.0.1 SQL patch applicability verified successfully on home /u00/app/oracle/product/12.2.0.1 Preparing to bring down database service on home /u00/app/oracle/product/12.2.0.1 Successfully prepared home /u00/app/oracle/product/12.2.0.1 to bring down database service Relocating RACOne home before patching on home /u00/app/oracle/product/12.2.0.1 Relocated RACOne home before patching on home /u00/app/oracle/product/12.2.0.1 Bringing down CRS service on home /u00/app/grid/product/12.2.0.1 Prepatch operation log file location: /u00/app/oracle/crsdata/ernie/crsconfig/crspatch_ernie_2017-07-20_09-04-01PM.log CRS service brought down successfully on home /u00/app/grid/product/12.2.0.1 Performing prepatch operation on home /u00/app/oracle/product/12.2.0.1 Perpatch operation completed successfully on home /u00/app/oracle/product/12.2.0.1 Start applying binary patch on home /u00/app/oracle/product/12.2.0.1 Binary patch applied successfully on home /u00/app/oracle/product/12.2.0.1 Performing postpatch operation on home /u00/app/oracle/product/12.2.0.1 Postpatch operation completed successfully on home /u00/app/oracle/product/12.2.0.1 Start applying binary patch on home /u00/app/grid/product/12.2.0.1 Binary patch applied successfully on home /u00/app/grid/product/12.2.0.1 Starting CRS service on home /u00/app/grid/product/12.2.0.1 Postpatch operation log file location: /u00/app/oracle/crsdata/ernie/crsconfig/crspatch_ernie_2017-07-20_09-10-11PM.log CRS service started successfully on home /u00/app/grid/product/12.2.0.1 Relocating back RACOne to home /u00/app/oracle/product/12.2.0.1 Relocated back RACOne home successfully to home /u00/app/oracle/product/12.2.0.1 Preparing home /u00/app/oracle/product/12.2.0.1 after database service restarted No step execution required......... Prepared home /u00/app/oracle/product/12.2.0.1 successfully after database service restarted Trying to apply SQL patch on home /u00/app/oracle/product/12.2.0.1 SQL patch applied successfully on home /u00/app/oracle/product/12.2.0.1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:ernie RAC Home:/u00/app/oracle/product/12.2.0.1 Summary: ==Following patches were SKIPPED: Patch: /u00/app/oracle/stage/26133434/25586399 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /u00/app/oracle/stage/26133434/26002778 Log: /u00/app/oracle/product/12.2.0.1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-20_21-06-00PM_1.log Patch: /u00/app/oracle/stage/26133434/26123830 Log: /u00/app/oracle/product/12.2.0.1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-20_21-06-00PM_1.log Host:ernie CRS Home:/u00/app/grid/product/12.2.0.1 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u00/app/oracle/stage/26133434/26002778 Log: /u00/app/grid/product/12.2.0.1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-20_21-07-01PM_1.log Patch: /u00/app/oracle/stage/26133434/25586399 Log: /u00/app/grid/product/12.2.0.1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-20_21-07-01PM_1.log Patch: /u00/app/oracle/stage/26133434/26123830 Log: /u00/app/grid/product/12.2.0.1/cfgtoollogs/opatchauto/core/opatch/opatch2017-07-20_21-07-01PM_1.log
Kontrolle
GI-Home:
grid@ernie:/u00/app/oracle/stage/26133434/ [-MGMTDB] echo $ORACLE_HOME /u00/app/grid/product/12.2.0.1 grid@ernie:/u00/app/oracle/stage/26133434/ [-MGMTDB] $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.
RDBMS-Home:
oracle@ernie:/u00/app/oracle/stage/26133434/ [rdbms12201] echo $ORACLE_HOME /u00/app/oracle/product/12.2.0.1 oracle@ernie:/u00/app/oracle/stage/26133434/ [rdbms12201] $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.
Im RDBMS-Home fehlt also nur noch das OJVM Release Update.
Auf die gleiche Art und Weise muss dann noch der zweite Knoten aktualisiert werden. Danach folgt noch der OVJM-Patch und das Einspielen der Änderungen in die Datenbank.
Insgesamt lief die Patch-Installation der ersten „Release Updates“ in meinem Fall problemlos.
Interessanterweise ist die Umbenennung von „Patch Set Update“ von „Release Update“ anscheinend noch nicht ganz abgeschlossen, denn bei der Installation werden das „OCW Patch Set Update“ und das „ACFS Patch Set Update“ in der Version 12.2.0.1.170718 installiert.
Werbung (Amazon-Partner-Link)