Sunday 3 May 2020

JAN 2020 PSU patch for 12c(12.1.0.2) Grid Home


This document describes how to apply January 2020 PSU patches on Grid Home.

Below are the steps to complete PSU patch on GRID Home

1. Download PSU patch
2. Upgrade opatch to latest version
3. Analyze the patches (prepatch analysis)
4. Apply patches on Grid home
5. Post patch steps

1. Download PSU patches:

Use below url and download database and GI PSU.

https://www.oracle.com/security-alerts/cpujan2020.html




Note: In my case I have downloaded combo OJVM patches for Grid (30464119) and DB (30463684).


2. Upgrade opatch to latest version 

Take backup of OPatch folder which is under $GRID_HOME

Unzip the patch under $GRID_HOME

grid@server1 grid_home]$ unzip p6880880_180000_Linux-x86-64.zip


3. Analyze the patches (prepatch analysis)

SCP downloaded GI patch to server and unzip it. Verify the readme.txt file for any pre-requisite steps and analyze it for conflicts. Proceed for patching if no conflicts come. We have to raise an SR for merge patch if we get conflicts.

In my case, Non-shared oracle homes and grid homes across the 2 nodes. So we are applying the patch in rolling passion.  No ACFS file system available.

Note: We have to unmount ACFS file system if it is available in our environment before patching and mount it after apply the patch.

Run analyze command as root user and find conflicts if any. Output looks like below.

[root@server1 ~]# /u01/app/grid/12102/grid_home/OPatch/opatchauto apply /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119 -analyze -oh /u01/app/grid/12102/grid_home

OPatchauto session is initiated at Sat May  2 09:13:28 2020

System initialization log file is /u01/app/grid/12102/grid_home/cfgtoollogs/opatchautodb/systemconfig2020-05-02_09-13-36AM.log.

Session log file is /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/opatchauto2020-05-02_09-13-50AM.log
The id for this session is CZ2S

Executing OPatch prereq operations to verify patch applicability on home /u01/app/grid/12102/grid_home
Patch applicability verified successfully on home /u01/app/grid/12102/grid_home

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:server1
CRS Home:/u01/app/grid/12102/grid_home
Version:12.1.0.2.0


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119/26983807
Log: /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2020-05-02_09-14-22AM_1.log

Patch: /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119/30304402
Log: /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2020-05-02_09-14-22AM_1.log

Patch: /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119/30304434
Log: /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2020-05-02_09-14-22AM_1.log

Patch: /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119/30340202
Log: /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2020-05-02_09-14-22AM_1.log


OPatchauto session completed at Sat May  2 09:15:19 2020
Time taken to complete the session 1 minute, 51 seconds
[root@server1 ~]#


4. Apply patch on Grid Home

Shutdown the  database. Cluster services should be up and running while applying grid patch. Apply the patch as root user.

[root@server1 ~]# /u01/app/grid/12102/grid_home/OPatch/opatchauto apply /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119 -oh /u01/app/grid/12102/grid_home

OPatchauto session is initiated at Sat May  2 09:55:24 2020

System initialization log file is /u01/app/grid/12102/grid_home/cfgtoollogs/opatchautodb/systemconfig2020-05-02_09-55-33AM.log.

Session log file is /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/opatchauto2020-05-02_09-55-54AM.log
The id for this session is QHK5

Executing OPatch prereq operations to verify patch applicability on home /u01/app/grid/12102/grid_home
Patch applicability verified successfully on home /u01/app/grid/12102/grid_home


Bringing down CRS service on home /u01/app/grid/12102/grid_home
Prepatch operation log file location: /u01/app/grid/12102/grid_home/cfgtoollogs/crsconfig/crspatch_server1_2020-05-02_09-57-32AM.log
CRS service brought down successfully on home /u01/app/grid/12102/grid_home


Start applying binary patch on home /u01/app/grid/12102/grid_home
Binary patch applied successfully on home /u01/app/grid/12102/grid_home


Starting CRS service on home /u01/app/grid/12102/grid_home
Postpatch operation log file location: /u01/app/grid/12102/grid_home/cfgtoollogs/crsconfig/crspatch_server1_2020-05-02_10-29-36AM.log
CRS service started successfully on home /u01/app/grid/12102/grid_home

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:server1
CRS Home:/u01/app/grid/12102/grid_home
Version:12.1.0.2.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119/26983807
Log: /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2020-05-02_10-02-07AM_1.log

Patch: /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119/30304402
Log: /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2020-05-02_10-02-07AM_1.log

Patch: /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119/30304434
Log: /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2020-05-02_10-02-07AM_1.log

Patch: /u02/software/19C_Upgrade/JAN20_CPU_12102/GI/30463691/30464119/30340202
Log: /u01/app/grid/12102/grid_home/cfgtoollogs/opatchauto/core/opatch/opatch2020-05-02_10-02-07AM_1.log


OPatchauto session completed at Sat May  2 10:45:56 2020
Time taken to complete the session 50 minutes, 32 seconds
[root@server1 ~]#

5. Post patch steps

Verify Readme.txt for any post patch installation steps and proceed.


No comments:

Post a Comment