In this article, I will be sharing my knowledge on applying the latest Oracle patch set update 12.1.0.2.190115 (released in January 2019) on RAC cluster. Do refer to readme file before executing the PSU.
If you need further step by step approach for applying the patch in detail, do refer to Apply the latest PSU5 for 12.1.0.2 RAC Database (here) (Scroll down) in my blog.
########
Error 1:
########
OPATCHAUTO-72053: Analysis for the patches failed.
OPATCHAUTO-72053: Command execution failed.
OPATCHAUTO-72053: Please check the summary for more details.
########
Error 2:
########
OPATCHAUTO-72088: OPatch version check failed.
OPATCHAUTO-72088: OPatch software version in homes selected for patching are different.
OPATCHAUTO-72088: Please install same OPatch software in all homes.
OPatchAuto failed.
opatchauto failed with error code 42
##########
Solution:
##########
Patch 27547329, Patch 28259833 and Patch 28729169 requires minimum OPatch version 12.2.0.1.13. Make sure to download p6880880_180000_Linux-x86-64.zip in both Grid and Oracle homes. So that, you are on the latest opatch version and move forward with patching.
After that applied the patch and it was successful.
[root@sajidserver01 OPatch]# ./opatchauto apply /usr/staging/28813884
OPatchauto session is initiated at Mon Jan 21 13:52:25 2019
System initialization log file is /usr/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-01-21_01-52-26PM.log.
Session log file is /usr/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2019-01-21_01-52-30PM.log
The id for this session is ZRI4
Executing OPatch prereq operations to verify patch applicability on home /usr/oracle/product/12.1.0
Patch applicability verified successfully on home /usr/oracle/product/12.1.0
Verifying SQL patch applicability on home /usr/oracle/product/12.1.0
SQL patch applicability verified successfully on home /usr/oracle/product/12.1.0
Executing OPatch prereq operations to verify patch applicability on home /usr/12.1.0/grid
Patch applicability verified successfully on home /usr/12.1.0/grid
Preparing to bring down database service on home /usr/oracle/product/12.1.0
Successfully prepared home /usr/oracle/product/12.1.0 to bring down database service
Bringing down database service on home /usr/oracle/product/12.1.0
Following database has been stopped and will be restarted later during the session: sajiddb
Database service successfully brought down on home /usr/oracle/product/12.1.0
Bringing down CRS service on home /usr/12.1.0/grid
Prepatch operation log file location: /usr/12.1.0/grid/cfgtoollogs/crsconfig/hapatch_2019-01-21_01-55-08PM.log
CRS service brought down successfully on home /usr/12.1.0/grid
Start applying binary patch on home /usr/oracle/product/12.1.0
Binary patch applied successfully on home /usr/oracle/product/12.1.0
Start applying binary patch on home /usr/12.1.0/grid
Binary patch applied successfully on home /usr/12.1.0/grid
Starting CRS service on home /usr/12.1.0/grid
Postpatch operation log file location: /usr/12.1.0/grid/cfgtoollogs/crsconfig/hapatch_2019-01-21_01-59-21PM.log
CRS service started successfully on home /usr/12.1.0/grid
Starting database service on home /usr/oracle/product/12.1.0
Database service successfully started on home /usr/oracle/product/12.1.0
Preparing home /usr/oracle/product/12.1.0 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /usr/oracle/product/12.1.0
SQL patch applied successfully on home /usr/oracle/product/12.1.0
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:sajidserver01
SIDB Home:/usr/oracle/product/12.1.0
Version:12.1.0.2.0
Summary:
==Following patches were SKIPPED:
Patch: /usr/staging/28813884/26983807
Reason: This patch is not applicable to this specified target type - "oracle_database"
Patch: /usr/staging/28813884/28729220
Reason: This patch is not applicable to this specified target type - "oracle_database"
==Following patches were SUCCESSFULLY applied:
Patch: /usr/staging/28813884/28729169
Log: /usr/oracle/product/12.1.0/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-55-30PM_1.log
Patch: /usr/staging/28813884/28729213
Log: /usr/oracle/product/12.1.0/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-55-30PM_1.log
Host:sajidserver01
SIHA Home:/usr/12.1.0/grid
Version:12.1.0.2.0
Summary:
==Following patches were SKIPPED:
Patch: /usr/staging/28813884/26983807
Reason: This patch is already been applied, so not going to apply again.
==Following patches were SUCCESSFULLY applied:
Patch: /usr/staging/28813884/28729169
Log: /usr/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-56-18PM_1.log
Patch: /usr/staging/28813884/28729213
Log: /usr/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-56-18PM_1.log
Patch: /usr/staging/28813884/28729220
Log: /usr/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-56-18PM_1.log
OPatchauto session completed at Mon Jan 21 14:01:18 2019
Time taken to complete the session 8 minutes, 54 seconds
Happy Patching and Learning.
