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)
Dieser Beitrag wurde unter O-NF12C-DBA, O-RAC, RAC, TrivadisContent abgelegt und mit , verschlagwortet. Setze ein Lesezeichen auf den Permalink.