Advertisement

Tuesday, January 15, 2019

Oracle Database - 18c - RAC (GI) 18c Patching (Apply RU 18.4.0.0.0)

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 ]
# 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


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

[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

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]
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

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


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





At this stage your Clusterware is patched to latest version, you can check it by running below command as grid user on all your nodes
$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