Hello Friend's,
In this post we will discuss about the patching of RAC database of version 12.2 from no patches to patch 12.2.0.1.220118 (33678030)
So lets get started .
Summary of Steps to be done.
1)Check current version of Opatch Tool.
2)Upgrade the Opatch utility.
3)Take the backup of ORACLE_HOME.
4)Check Conflict for Patch downloaded.
5)Check space on Grid and oracle Home.
6)Apply the Patch on Node 1 and 2 one by one.
Patch level to be downloaded :
33583921 Grid + database
Database Details :
Initial Patches Installed :
Database Patch Installed :
[oracle@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/oracle/app/orawork/product/12.2.0.1/db_1".
OPatch succeeded.
[oracle@dm01db01 oracle]$
Grid Patch Installed :
[grid@dm01db01 trace]$ $ORACLE_HOME/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/Grid/app/gridwork/gr_12.2".
OPatch succeeded.
Initial Opatch version :
Opatch version : to be done on Both Nodes
[grid@dm01db01 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.6
OPatch succeeded.
[grid@dm01db01 OPatch]$
[oracle@dm01db01 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.6
OPatch succeeded.
[oracle@dm01db01 OPatch]$
update Opatch on both nodes oracle and grid.
===========After Opatch Update===========
[grid@dm01db01 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.32
OPatch succeeded.
[oracle@dm01db01 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.32
OPatch succeeded.
Check the conflict of patch on grid and database as below :
===============Grid Conflict========================
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33587128
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33678030
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33116894
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/26839277
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33610989
[grid@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33587128
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /Grid/app/gridwork/gr_12.2
Central Inventory : /Grid/app/gridwork/oraInventory
from : /Grid/app/gridwork/gr_12.2/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatch/opatch2022-10-17_17-42-21PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33678030
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /Grid/app/gridwork/gr_12.2
Central Inventory : /Grid/app/gridwork/oraInventory
from : /Grid/app/gridwork/gr_12.2/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatch/opatch2022-10-17_17-42-36PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@dm01db01 oracle]$
[grid@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33116894
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /Grid/app/gridwork/gr_12.2
Central Inventory : /Grid/app/gridwork/oraInventory
from : /Grid/app/gridwork/gr_12.2/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatch/opatch2022-10-17_17-42-50PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/26839277
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /Grid/app/gridwork/gr_12.2
Central Inventory : /Grid/app/gridwork/oraInventory
from : /Grid/app/gridwork/gr_12.2/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatch/opatch2022-10-17_17-43-03PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33610989
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /Grid/app/gridwork/gr_12.2
Central Inventory : /Grid/app/gridwork/oraInventory
from : /Grid/app/gridwork/gr_12.2/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatch/opatch2022-10-17_17-43-23PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@dm01db01 oracle]$
====================DB_Home Conflict=====================================
For database home, as home user:% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33587128
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33678030
[oracle@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33587128
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/orawork/product/12.2.0.1/db_1
Central Inventory : /Grid/app/gridwork/oraInventory
from : /oracle/app/orawork/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2022-10-17_17-44-47PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@dm01db01 oracle]$
[oracle@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/33583921/33678030
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/orawork/product/12.2.0.1/db_1
Central Inventory : /Grid/app/gridwork/oraInventory
from : /oracle/app/orawork/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2022-10-17_17-45-03PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Oracle and Grid home space check :
=======================Space Check GRID=====================================
[grid@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /oracle/patchlist_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /Grid/app/gridwork/gr_12.2
Central Inventory : /Grid/app/gridwork/oraInventory
from : /Grid/app/gridwork/gr_12.2/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatch/opatch2022-10-17_17-49-32PM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
Oracle and Grid home space check :
=======================Space Check Database=====================================
[oracle@dm01db01 oracle]$ vi patch_list_dbhome.txt
[oracle@dm01db01 oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /oracle/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/orawork/product/12.2.0.1/db_1
Central Inventory : /Grid/app/gridwork/oraInventory
from : /oracle/app/orawork/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.1.4
Log file location : /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2022-10-17_17-48-26PM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
Analyze the patch to be installed :
======================================Analyze_Patch=================================
$ORACLE_HOME/OPatch/opatchauto apply /oracle/33583921 -analyze
[root@dm01db01 oracle]# $ORACLE_HOME/OPatch/opatchauto apply /oracle/33583921 -analyze
OPatchauto session is initiated at Mon Oct 17 17:51:14 2022
System initialization log file is /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchautodb/systemconfig2022-10-17_05-51-19PM.log.
Session log file is /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/opatchauto2022-10-17_05-52-49PM.log
The id for this session is QATL
Executing OPatch prereq operations to verify patch applicability on home /Grid/app/gridwork/gr_12.2
Executing OPatch prereq operations to verify patch applicability on home /oracle/app/orawork/product/12.2.0.1/db_1
Patch applicability verified successfully on home /Grid/app/gridwork/gr_12.2
Patch applicability verified successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Executing patch validation checks on home /Grid/app/gridwork/gr_12.2
Patch validation checks successfully completed on home /Grid/app/gridwork/gr_12.2
Executing patch validation checks on home /oracle/app/orawork/product/12.2.0.1/db_1
Patch validation checks successfully completed on home /oracle/app/orawork/product/12.2.0.1/db_1
Verifying SQL patch applicability on home /oracle/app/orawork/product/12.2.0.1/db_1
SQL patch applicability verified successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:dm01db01
CRS Home:/Grid/app/gridwork/gr_12.2
Version:12.2.0.1.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /oracle/33583921/33678030
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_17-53-36PM_1.log
Patch: /oracle/33583921/33116894
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_17-53-36PM_1.log
Patch: /oracle/33583921/26839277
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_17-53-36PM_1.log
Patch: /oracle/33583921/33610989
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_17-53-36PM_1.log
Patch: /oracle/33583921/33587128
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_17-53-36PM_1.log
Host:dm01db01
RAC Home:/oracle/app/orawork/product/12.2.0.1/db_1
Version:12.2.0.1.0
==Following patches were SKIPPED:
Patch: /oracle/33583921/33116894
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /oracle/33583921/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /oracle/33583921/33610989
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /oracle/33583921/33678030
Log: /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_17-53-34PM_1.log
Patch: /oracle/33583921/33587128
Log: /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_17-53-34PM_1.log
OPatchauto session completed at Mon Oct 17 17:54:45 2022
Time taken to complete the session 3 minutes, 31 seconds
Summary commands to apply patch :
To patch the GI home and all Oracle RAC database homes of the same version:
# opatchauto apply /oracle/33583921 : $ORACLE_HOME/OPatch/opatchauto apply /oracle/33583921
To patch only the GI home:
# opatchauto apply /33583921 -oh : $ORACLE_HOME/OPatch/opatchauto apply /oracle/33583921 -oh /Grid/app/gridwork/gr_12.2
To patch one or more Oracle RAC database homes:
# opatchauto apply /33583921 -oh ,
Start with the patch Apply : Node 1
[root@dm01db01 oracle]# $ORACLE_HOME/OPatch/opatchauto apply /oracle/33583921
OPatchauto session is initiated at Mon Oct 17 18:09:53 2022
System initialization log file is /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchautodb/systemconfig2022-10-17_06-09-59PM.log.
Session log file is /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/opatchauto2022-10-17_06-10-39PM.log
The id for this session is 3GUL
Executing OPatch prereq operations to verify patch applicability on home /Grid/app/gridwork/gr_12.2
Executing OPatch prereq operations to verify patch applicability on home /oracle/app/orawork/product/12.2.0.1/db_1
Patch applicability verified successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Patch applicability verified successfully on home /Grid/app/gridwork/gr_12.2
Executing patch validation checks on home /Grid/app/gridwork/gr_12.2
Patch validation checks successfully completed on home /Grid/app/gridwork/gr_12.2
Executing patch validation checks on home /oracle/app/orawork/product/12.2.0.1/db_1
Patch validation checks successfully completed on home /oracle/app/orawork/product/12.2.0.1/db_1
Verifying SQL patch applicability on home /oracle/app/orawork/product/12.2.0.1/db_1
SQL patch applicability verified successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Preparing to bring down database service on home /oracle/app/orawork/product/12.2.0.1/db_1
Successfully prepared home /oracle/app/orawork/product/12.2.0.1/db_1 to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /Grid/app/gridwork/gr_12.2
Prepatch operation log file location: /Grid/app/gridwork/gr_base/crsdata/dm01db01/crsconfig/crspatch_dm01db01_2022-10-17_06-13-44PM.log
CRS service brought down successfully on home /Grid/app/gridwork/gr_12.2
Performing prepatch operation on home /oracle/app/orawork/product/12.2.0.1/db_1
Prepatch operation completed successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Start applying binary patch on home /oracle/app/orawork/product/12.2.0.1/db_1
Binary patch applied successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Performing postpatch operation on home /oracle/app/orawork/product/12.2.0.1/db_1
Postpatch operation completed successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Start applying binary patch on home /Grid/app/gridwork/gr_12.2
Binary patch applied successfully on home /Grid/app/gridwork/gr_12.2
Performing postpatch operations on CRS - starting CRS service on home /Grid/app/gridwork/gr_12.2
Postpatch operation log file location: /Grid/app/gridwork/gr_base/crsdata/dm01db01/crsconfig/crspatch_dm01db01_2022-10-17_06-29-39PM.log
CRS service started successfully on home /Grid/app/gridwork/gr_12.2
Preparing home /oracle/app/orawork/product/12.2.0.1/db_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /oracle/app/orawork/product/12.2.0.1/db_1
SQL patch applied successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:dm01db01
RAC Home:/oracle/app/orawork/product/12.2.0.1/db_1
Version:12.2.0.1.0
Summary:
==Following patches were SKIPPED:
Patch: /oracle/33583921/33116894
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /oracle/33583921/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /oracle/33583921/33610989
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /oracle/33583921/33587128
Log: /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-15-47PM_1.log
Patch: /oracle/33583921/33678030
Log: /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-15-47PM_1.log
Host:dm01db01
CRS Home:/Grid/app/gridwork/gr_12.2
Version:12.2.0.1.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /oracle/33583921/26839277
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-22-06PM_1.log
Patch: /oracle/33583921/33116894
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-22-06PM_1.log
Patch: /oracle/33583921/33587128
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-22-06PM_1.log
Patch: /oracle/33583921/33610989
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-22-06PM_1.log
Patch: /oracle/33583921/33678030
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-22-06PM_1.log
OPatchauto session completed at Mon Oct 17 18:42:51 2022
Time taken to complete the session 32 minutes, 58 seconds
Status Grid After Patch on node 1 :
[grid@dm01db01 OPatch]$ ./opatch lspatches
33678030;OCW JAN 2022 RELEASE UPDATE 12.2.0.1.220118 (33678030)
33610989;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:RELEASE) (33610989)
33587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)
33116894;ACFS JUL 2021 RELEASE UPDATE 12.2.0.1.210720 (33116894)
26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)
OPatch succeeded.
[grid@dm01db01 OPatch]$
Status database After Patch on node 1 :
[oracle@dm01db01 oracle]$ cd $ORACLE_HOME/OPatch
[oracle@dm01db01 OPatch]$ ./opatch lspatches
33678030;OCW JAN 2022 RELEASE UPDATE 12.2.0.1.220118 (33678030)
33587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)
OPatch succeeded.
Alert Log of Grid : for check apply start ASM stop :
Grid : Alert
2022-10-17T15:48:28.003232+05:30
Reconfiguration complete (total time 0.4 secs)
2022-10-17T15:48:50.545709+05:30
NOTE: client CDBFINDB2:CDBFINDB:dm01clust id 0x10000 has reconnected to ASM inst +ASM2 (reg:3022375326), or has been fenced
2022-10-17T15:49:01.012814+05:30
NOTE: [ocrcheck.bin@dm01db01.database.com (TNS V1-V3) 97297] opening OCR file +OCR_VOTE.255.4294967295, osid 97306
NOTE: [ocrcheck.bin@dm01db01.database.com (TNS V1-V3) 97297] opened OCR file +OCR_VOTE.255.4294967295, osid 97306
2022-10-17T17:02:01.929675+05:30
Warning: VKTM detected a forward time drift.
Please see the VKTM trace file for more details:
/Grid/app/gridwork/gr_base/diag/asm/+asm/+ASM1/trace/+ASM1_vktm_51529.trc
2022-10-17T18:13:59.841529+05:30
ALTER SYSTEM START ROLLING PATCH
Starting background process RMON
2022-10-17T18:13:59.888666+05:30
RMON started with pid=40, OS id=19590
2022-10-17T18:14:02.614568+05:30
NOTE: Cluster is in Rolling Patch
2022-10-17T18:14:07.399227+05:30
Restarting dead background process PING
Starting background process PING
2022-10-17T18:14:08.025579+05:30
PING started with pid=11, OS id=19656
2022-10-17T18:14:09.344130+05:30
NOTE: ASM client CDBFINDB1:CDBFINDB:dm01clust disconnected unexpectedly.
NOTE: check client alert log.
NOTE: Trace records dumped in trace file /Grid/app/gridwork/gr_base/diag/asm/+asm/+ASM1/trace/+ASM1_ufg_89630_CDBFINDB1_CDBFINDB.trc
NOTE: cleaned up ASM client CDBFINDB1:CDBFINDB:dm01clust connection state (reg:2409783877)
2022-10-17T18:14:10.353230+05:30
NOTE: detected orphaned client id 0x10005.
-----
SUCCESS: ALTER DISKGROUP ALL DISMOUNT /* asm agent *//* {0:0:2833} */
Shutting down archive processes
Archiving is disabled
2022-10-17T18:14:38.855621+05:30
Shutting down archive processes
Archiving is disabled
2022-10-17T18:14:38.866143+05:30
Stopping background process VKTM
2022-10-17T18:14:42.057100+05:30
freeing rdom 3
freeing rdom 2
freeing rdom 1
freeing rdom 0
2022-10-17T18:14:44.085281+05:30
Instance shutdown complete (OS id: 19985)
Database alert log Node 1 :
2022-10-17T18:14:05.119961+05:30
License high water mark = 14
2022-10-17T18:14:05.120728+05:30
USER (ospid: 19615): terminating the instance
2022-10-17T18:14:06.451968+05:30
Instance terminated by USER, pid = 19615
once completed on node 1 , Start with apply on node 2 :
[root@dm01db02 oracle]# $ORACLE_HOME/OPatch/opatchauto apply /oracle/33583921
OPatchauto session is initiated at Mon Oct 17 18:52:40 2022
System initialization log file is /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchautodb/systemconfig2022-10-17_06-52-45PM.log.
Session log file is /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/opatchauto2022-10-17_06-53-38PM.log
The id for this session is 7M8K
Executing OPatch prereq operations to verify patch applicability on home /Grid/app/gridwork/gr_12.2
Executing OPatch prereq operations to verify patch applicability on home /oracle/app/orawork/product/12.2.0.1/db_1
Patch applicability verified successfully on home /Grid/app/gridwork/gr_12.2
Patch applicability verified successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Executing patch validation checks on home /Grid/app/gridwork/gr_12.2
Patch validation checks successfully completed on home /Grid/app/gridwork/gr_12.2
Executing patch validation checks on home /oracle/app/orawork/product/12.2.0.1/db_1
Patch validation checks successfully completed on home /oracle/app/orawork/product/12.2.0.1/db_1
Verifying SQL patch applicability on home /oracle/app/orawork/product/12.2.0.1/db_1
SQL patch applicability verified successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Preparing to bring down database service on home /oracle/app/orawork/product/12.2.0.1/db_1
Successfully prepared home /oracle/app/orawork/product/12.2.0.1/db_1 to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /Grid/app/gridwork/gr_12.2
Prepatch operation log file location: /Grid/app/gridwork/gr_base/crsdata/dm01db02/crsconfig/crspatch_dm01db02_2022-10-17_06-56-46PM.log
CRS service brought down successfully on home /Grid/app/gridwork/gr_12.2
Performing prepatch operation on home /oracle/app/orawork/product/12.2.0.1/db_1
Prepatch operation completed successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Start applying binary patch on home /oracle/app/orawork/product/12.2.0.1/db_1
Binary patch applied successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Performing postpatch operation on home /oracle/app/orawork/product/12.2.0.1/db_1
Postpatch operation completed successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
Start applying binary patch on home /Grid/app/gridwork/gr_12.2
Binary patch applied successfully on home /Grid/app/gridwork/gr_12.2
Performing postpatch operations on CRS - starting CRS service on home /Grid/app/gridwork/gr_12.2
Postpatch operation log file location: /Grid/app/gridwork/gr_base/crsdata/dm01db02/crsconfig/crspatch_dm01db02_2022-10-17_07-11-49PM.log
CRS service started successfully on home /Grid/app/gridwork/gr_12.2
Preparing home /oracle/app/orawork/product/12.2.0.1/db_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /oracle/app/orawork/product/12.2.0.1/db_1
SQL patch applied successfully on home /oracle/app/orawork/product/12.2.0.1/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:dm01db02
RAC Home:/oracle/app/orawork/product/12.2.0.1/db_1
Version:12.2.0.1.0
Summary:
==Following patches were SKIPPED:
Patch: /oracle/33583921/33116894
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /oracle/33583921/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /oracle/33583921/33610989
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /oracle/33583921/33587128
Log: /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-58-18PM_1.log
Patch: /oracle/33583921/33678030
Log: /oracle/app/orawork/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_18-58-18PM_1.log
Host:dm01db02
CRS Home:/Grid/app/gridwork/gr_12.2
Version:12.2.0.1.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /oracle/33583921/26839277
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_19-04-11PM_1.log
Patch: /oracle/33583921/33116894
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_19-04-11PM_1.log
Patch: /oracle/33583921/33587128
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_19-04-11PM_1.log
Patch: /oracle/33583921/33610989
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_19-04-11PM_1.log
Patch: /oracle/33583921/33678030
Log: /Grid/app/gridwork/gr_12.2/cfgtoollogs/opatchauto/core/opatch/opatch2022-10-17_19-04-11PM_1.log
OPatchauto session completed at Mon Oct 17 19:46:11 2022
Time taken to complete the session 53 minutes, 31 seconds
Status Grid After Patch on node 2 :
[grid@dm01db02 OPatch]$ ./opatch lspatches
33678030;OCW JAN 2022 RELEASE UPDATE 12.2.0.1.220118 (33678030)
33610989;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:RELEASE) (33610989)
33587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)
33116894;ACFS JUL 2021 RELEASE UPDATE 12.2.0.1.210720 (33116894)
26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)
OPatch succeeded.
[grid@dm01db02 OPatch]$
Status Database After Patch on node 2 :
[oracle@dm01db02 OPatch]$ ./opatch lspatches
33678030;OCW JAN 2022 RELEASE UPDATE 12.2.0.1.220118 (33678030)
33587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)
OPatch succeeded.
[oracle@dm01db02 OPatch]$
Cluster level after Patch :
[root@dm01db01 ~]# crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3975995681].
[root@dm01db01 ~]# crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [12.2.0.1.0]
[root@dm01db01 ~]# crsctl query crs softwareversion
Oracle Clusterware version on node [dm01db01] is [12.2.0.1.0]
[root@dm01db01 ~]#
Note : Database will be taken care bu Opatch Auto no need to run Datapatch seprately after Patch .
SQL> col action_time for a28
col action for a8
col version for a8
col comments for a30
col status for a10
set line 999 pages 999
select patch_id, version, status, Action,Action_time from dba_registry_sqlpatch order by action_time;SQL> SQL> SQL> SQL> SQL> SQL>
PATCH_ID VERSION STATUS ACTION ACTION_TIME
---------- -------- ---------- -------- ----------------------------
33587128 12.2.0.1 SUCCESS APPLY 17-OCT-22 07.45.50.762538 PM
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> col action_time for a28
col action for a8
col version for a8
col comments for a30
col status for a10
set line 999 pages 999
select patch_id, version, status, Action,Action_time from dba_registry_sqlpatch order by action_time;SQL> SQL> SQL> SQL> SQL> SQL>
PATCH_ID VERSION STATUS ACTION ACTION_TIME
---------- -------- ---------- -------- ----------------------------
33587128 12.2.0.1 SUCCESS APPLY 17-OCT-22 07.45.56.261950 PM
SQL> show con_name
CON_NAME
------------------------------
FINDB
Patch Apply completed :
Hope This Helps
Contact Me :Telegram : https://t.me/sultandba
Facebook : https://www.facebook.com/sultandba/
Twitter : https://twitter.com/sultandba
Regards
Sultan Khan
ConversionConversion EmoticonEmoticon