In this blog I am going to cover Patching of Oracle RAC 18c (fresh installation)
Download Patches
1. Patch 6880880: OPatch 12.2.0.1.14 for DB 12.2 releases (JUL 2018) (or higher)
2. Patch 28659165: GI RELEASE UPDATE 18.4.0.0.0
Step 1 - [As grid] - Unzip Opatch (on both nodes)
[As root]
# cd /u01/app/180/grid/
# mv OPatch OPatch.20190115
[As grid]
# unzip -qq /tmp/p6880880_122010_Linux-x86-64.zip
# chown -R grid:oinstall OPatch
[As grid]
Verify OPatch version
# /u01/app/180/grid/OPatch/opatch version
OPatch Version: 12.2.0.1.14
2. Step 2 [As Grid - on Both Nodes ]
3. Step 3 [As Grid - On All Nodes]
Run - Pre-req check to ensure all is fine.
[As oracle - on all Nodes]
4. Step 4 [As Grid - On All Nodes]
Run System Space Check and ensure they pass on all nodes for both users
Create File
Create File
<
5. Step [As root - On All Nodes Rolling (Node 1 and then Node 2 and 3..4..5)]
Patch the Grid Home
Node 1
[root@rac18c01 ~]# opatchauto apply /tmp/install/28659165 -oh /u01/app/180/grid
OPatchauto session is initiated at Tue Jan 15 05:07:09 2019
System initialization log file is /u01/app/180/grid/cfgtoollogs/opatchautodb/systemconfig2019-01-15_05-07-12AM.log.
Session log file is /u01/app/180/grid/cfgtoollogs/opatchauto/opatchauto2019-01-15_05-08-00AM.log
The id for this session is VH7W
Executing OPatch prereq operations to verify patch applicability on home /u01/app/180/grid
Patch applicability verified successfully on home /u01/app/180/grid
Bringing down CRS service on home /u01/app/180/grid
CRS service brought down successfully on home /u01/app/180/grid
Start applying binary patch on home /u01/app/180/grid
Binary patch applied successfully on home /u01/app/180/grid
Starting CRS service on home /u01/app/180/grid
CRS service started successfully on home /u01/app/180/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac18c01
CRS Home:/u01/app/180/grid
Version:18.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /tmp/install/28659165/28547619
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
Patch: /tmp/install/28659165/28655784
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
Patch: /tmp/install/28659165/28655916
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
Patch: /tmp/install/28659165/28655963
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
Patch: /tmp/install/28659165/28656071
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
OPatchauto session completed at Tue Jan 15 05:18:44 2019
Time taken to complete the session 11 minutes, 36 seconds
At this stage your Clusterware is patched to latest version, you can check it by running below command as grid user on all your nodesDownload Patches
1. Patch 6880880: OPatch 12.2.0.1.14 for DB 12.2 releases (JUL 2018) (or higher)
2. Patch 28659165: GI RELEASE UPDATE 18.4.0.0.0
Step 1 - [As grid] - Unzip Opatch (on both nodes)
[As root]
# cd /u01/app/180/grid/
# mv OPatch OPatch.20190115
[As grid]
# unzip -qq /tmp/p6880880_122010_Linux-x86-64.zip
# chown -R grid:oinstall OPatch
[As grid]
Verify OPatch version
# /u01/app/180/grid/OPatch/opatch version
OPatch Version: 12.2.0.1.14
2. Step 2 [As Grid - on Both Nodes ]
# mkdir /tmp/install
# chmod 777 /tmp/install
# mv p28659165_180000_Linux-x86-64.zip /tmp/install
# cd /tmp/install
# unzip -qq p28659165_180000_Linux-x86-64.zip
# chmod -R 777 28659165
# cd 28659165/
# export ORACLE_HOME=/u01/app/180/grid
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# chmod 777 /tmp/install
# mv p28659165_180000_Linux-x86-64.zip /tmp/install
# cd /tmp/install
# unzip -qq p28659165_180000_Linux-x86-64.zip
# chmod -R 777 28659165
# cd 28659165/
# export ORACLE_HOME=/u01/app/180/grid
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
3. Step 3 [As Grid - On All Nodes]
Run - Pre-req check to ensure all is fine.
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28655784
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28656071
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28655916
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28656071
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28655916
[As oracle - on all Nodes]
# export ORACLE_HOME=/u01/app/oracle/product/180/db/
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28655784
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28656071
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28655784
# $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/install/28659165/28656071
4. Step 4 [As Grid - On All Nodes]
Run System Space Check and ensure they pass on all nodes for both users
Create File
# cat /tmp/patch_list_gihome.txt
/tmp/install/28659165/28655784
/tmp/install/28659165/28656071
/tmp/install/28659165/28655916
# export ORACLE_HOME=/u01/app/180/grid
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
[As oracle - on All nodes]/tmp/install/28659165/28655784
/tmp/install/28659165/28656071
/tmp/install/28659165/28655916
# export ORACLE_HOME=/u01/app/180/grid
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
Create File
<
# cat /tmp/patch_list_dbhome.txt
/tmp/install/28659165/28655784
/tmp/install/28659165/28656071
# export ORACLE_HOME=/u01/app/oracle/product/180/db/
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
/tmp/install/28659165/28655784
/tmp/install/28659165/28656071
# export ORACLE_HOME=/u01/app/oracle/product/180/db/
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
5. Step [As root - On All Nodes Rolling (Node 1 and then Node 2 and 3..4..5)]
Patch the Grid Home
# export ORACLE_HOME=/u01/app/180/grid
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# opatchauto apply /tmp/install/28659165 -oh /u01/app/180/grid
# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
# opatchauto apply /tmp/install/28659165 -oh /u01/app/180/grid
Node 1
[root@rac18c01 ~]# opatchauto apply /tmp/install/28659165 -oh /u01/app/180/grid
OPatchauto session is initiated at Tue Jan 15 05:07:09 2019
System initialization log file is /u01/app/180/grid/cfgtoollogs/opatchautodb/systemconfig2019-01-15_05-07-12AM.log.
Session log file is /u01/app/180/grid/cfgtoollogs/opatchauto/opatchauto2019-01-15_05-08-00AM.log
The id for this session is VH7W
Executing OPatch prereq operations to verify patch applicability on home /u01/app/180/grid
Patch applicability verified successfully on home /u01/app/180/grid
Bringing down CRS service on home /u01/app/180/grid
CRS service brought down successfully on home /u01/app/180/grid
Start applying binary patch on home /u01/app/180/grid
Binary patch applied successfully on home /u01/app/180/grid
Starting CRS service on home /u01/app/180/grid
CRS service started successfully on home /u01/app/180/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac18c01
CRS Home:/u01/app/180/grid
Version:18.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /tmp/install/28659165/28547619
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
Patch: /tmp/install/28659165/28655784
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
Patch: /tmp/install/28659165/28655916
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
Patch: /tmp/install/28659165/28655963
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
Patch: /tmp/install/28659165/28656071
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-10-21AM_1.log
OPatchauto session completed at Tue Jan 15 05:18:44 2019
Time taken to complete the session 11 minutes, 36 seconds
Node 2 -
[root@rac18c02 ~]# opatchauto apply /tmp/install/28659165 -oh /u01/app/180/grid
OPatchauto session is initiated at Tue Jan 15 05:50:49 2019
System initialization log file is /u01/app/180/grid/cfgtoollogs/opatchautodb/systemconfig2019-01-15_05-50-51AM.log.
Session log file is /u01/app/180/grid/cfgtoollogs/opatchauto/opatchauto2019-01-15_05-51-29AM.log
The id for this session is RK7B
Executing OPatch prereq operations to verify patch applicability on home /u01/app/180/grid
Patch applicability verified successfully on home /u01/app/180/grid
Bringing down CRS service on home /u01/app/180/grid
CRS service brought down successfully on home /u01/app/180/grid
Start applying binary patch on home /u01/app/180/grid
Binary patch applied successfully on home /u01/app/180/grid
Starting CRS service on home /u01/app/180/grid
CRS service started successfully on home /u01/app/180/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac18c02
CRS Home:/u01/app/180/grid
Version:18.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /tmp/install/28659165/28547619
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
Patch: /tmp/install/28659165/28655784
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
Patch: /tmp/install/28659165/28655916
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
Patch: /tmp/install/28659165/28655963
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
Patch: /tmp/install/28659165/28656071
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
OPatchauto session completed at Tue Jan 15 06:01:48 2019
Time taken to complete the session 11 minutes, 0 second
OPatchauto session is initiated at Tue Jan 15 05:50:49 2019
System initialization log file is /u01/app/180/grid/cfgtoollogs/opatchautodb/systemconfig2019-01-15_05-50-51AM.log.
Session log file is /u01/app/180/grid/cfgtoollogs/opatchauto/opatchauto2019-01-15_05-51-29AM.log
The id for this session is RK7B
Executing OPatch prereq operations to verify patch applicability on home /u01/app/180/grid
Patch applicability verified successfully on home /u01/app/180/grid
Bringing down CRS service on home /u01/app/180/grid
CRS service brought down successfully on home /u01/app/180/grid
Start applying binary patch on home /u01/app/180/grid
Binary patch applied successfully on home /u01/app/180/grid
Starting CRS service on home /u01/app/180/grid
CRS service started successfully on home /u01/app/180/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac18c02
CRS Home:/u01/app/180/grid
Version:18.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /tmp/install/28659165/28547619
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
Patch: /tmp/install/28659165/28655784
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
Patch: /tmp/install/28659165/28655916
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
Patch: /tmp/install/28659165/28655963
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
Patch: /tmp/install/28659165/28656071
Log: /u01/app/180/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-15_05-54-10AM_1.log
OPatchauto session completed at Tue Jan 15 06:01:48 2019
Time taken to complete the session 11 minutes, 0 second
$ORACLE_HOME/OPatch/opatch lspatches and it will display as below.
28656071;OCW RELEASE UPDATE 18.4.0.0.0 (28656071)
28655963;DBWLM RELEASE UPDATE 18.4.0.0.0 (28655963)
28655916;ACFS RELEASE UPDATE 18.4.0.0.0 (28655916)
28655784;Database Release Update : 18.4.0.0.181016 (28655784)
The Next Step now is to patch your databases
No comments:
Write comments