GI rolling upgrade from 19.12 to 19.15 on RAC
Step by step procedure to upgrade Grid infrastructure from 19.12 to 19.15 on RAC.
Oracle Grid infrastructure from 19.12 to 19.15 on RAC in a rolling method.
download Patch: 33803476 with root: 33575402,33806152, with grid Local apply 33815596,33815607,33911149
High level steps to apply patch in rolling method:
1) Run opatch prereq and analyze for all patches on Node 1 & 2.
If there are any issues in the above steps stop the activity and fix.
2) stop all instances on Node2
3) Apply pathes on Node 1
4) Start all instances on Node2
5) Run opatch prereq and analyze for all patches on Node2.
6) stop all instances on Node2
7) Apply pathes on Node 2
8) Start all instances on Node2
Commands to run prereq , analyze and rollback patches
export ORACLE_HOME=/u01/app/19.0.0/grid
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33806152
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33815596
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33815607
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33911149
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33575402
$ORACLE_HOME/OPatch/opatchauto apply /u01/software/19C_GRID/1915/33803476 -analyze -oh /u01/app/19.0.0/grid
$ORACLE_HOME/OPatch/opatchauto apply /u01/software/19C_GRID/1915/33803476 -oh /u01/app/19.0.0/grid
$ORACLE_HOME/opatchauto rollback /u01/software/19C_GRID/1915/33803476 -oh /u01/app/19.0.0/grid
On Node 1
Prereq check on node1 with grid user
Node1 +ASM1 $ pwd
/u01/software/19C_GRID/1915/33803476
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir </u01/software/19C_GRID/1915/33803476/33806152
Oracle Interim Patch Installer version 12.2.0.1.29
The argument “” does not exists.
PREREQ session
Argument(s) Error… Patch base location is not valid.
Please check the arguments and try again.
OPatch failed with error code 135
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOEM/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33806152
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_14-36-38PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33815596
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_14-36-48PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33815607
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_14-37-03PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33911149
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_14-37-12PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33575402
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_14-37-20PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node1 +ASM1 $
Analyze command on node1 with root user
root@Node1 :/u01/software/19C_GRID/1915/33803476 0
# $ORACLE_HOME/OPatch/opatchauto apply /u01/software/19C_GRID/1915/33803476 -analyze -oh /u01/app/19.0.0/grid
OPatchauto session is initiated at Sat May 7 14:39:05 2022
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-05-07_02-39-09PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-05-07_02-39-22PM.log
The id for this session is Q6MI
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0/grid
OPatchAuto successful.
——————————–Summary——————————–
Analysis for applying patches has completed successfully:
Host:Node1
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/software/19C_GRID/1915/33803476/33815596
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_14-39-39PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33815607
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_14-39-39PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_14-39-39PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33911149
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_14-39-39PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33806152
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_14-39-39PM_1.log
OPatchauto session completed at Sat May 7 14:40:14 2022
Time taken to complete the session 1 minute, 9 seconds
root@Node1 :/u01/software/19C_GRID/1915/33803476 0
#
Stop instances on Node1
Node1 $ srvctl stop instance -d ORCLD1 -i ORCLD11 -o immediate
Node1 $ srvctl stop instance -d ORCLT1 -i ORCLT11 -o immediate
Apply patch on node1
root@Node1 :/u01/software/19C_GRID/1915/33803476 0
# $ORACLE_HOME/OPatch/opatchauto apply /u01/software/19C_GRID/1915/33803476 -oh /u01/app/19.0.0/grid
OPatchauto session is initiated at Sat May 7 15:01:50 2022
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-05-07_03-01-53PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-05-07_03-02-06PM.log
The id for this session is ZXUA
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0/grid
Performing prepatch operations on CRS – bringing down CRS service on home /u01/app/19.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/Node1/crsconfig/crs_prepatch_apply_inplace_Node1_2022-05-07_03-03-01PM.log
CRS service brought down successfully on home /u01/app/19.0.0/grid
Start applying binary patch on home /u01/app/19.0.0/grid
Failed while applying binary patches on home /u01/app/19.0.0/grid
Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : Node1->/u01/app/19.0.0/grid Type[crs]
Details: [
—————————Patching Failed———————————
Command execution failed during patching in home: /u01/app/19.0.0/grid, host: Node1.
Command failed: /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/software/19C_GRID/1915/33803476 -oh /u01/app/19.0.0/grid -target_type cluster -binary -invPtrLoc /u01/app/19.0.0/grid/oraInst.loc -jre /u01/app/19.0.0/grid/OPatch/jre -persistresult /u01/app/19.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_Node1_crs_3.ser -analyzedresult /u01/app/19.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_Node1_crs_3.ser
Command failure output:
==Following patches FAILED in apply:
Patch: /u01/software/19C_GRID/1915/33803476/33815596
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_15-05-43PM_1.log
Reason: Failed during Analysis: CheckNApplyReport Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Prerequisite check “CheckApplicable” failed.]
After fixing the cause of failure Run opatchauto resume
]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.
OPatchauto session completed at Sat May 7 15:15:41 2022
Time taken to complete the session 13 minutes, 51 seconds
opatchauto failed with error code 42
root@Node1 :/u01/software/19C_GRID/1915/33803476 42
Even though the above command failed , below two patches were applied . From the logfile , we can find the below info.
logfile: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_15-05-43PM_1.log
Patch 33575402
[May 7, 2022 3:06:29 PM] [INFO] [OPSR-TIME] Patch 33575402 saved to inventory
[May 7, 2022 3:06:29 PM] [INFO] [OPSR-TIME] Finished applying patch “33575402” to local system
[May 7, 2022 3:06:30 PM] [INFO] Patch 33575402 successfully applied.
[May 7, 2022 3:06:30 PM] [INFO] Sub-set patch [32585572] has become inactive due to the application of a super-set patch [33575402].
Patch 33806152
[May 7, 2022 3:14:59 PM] [INFO] [OPSR-TIME] Finished applying patch “33806152” to local system
[May 7, 2022 3:15:20 PM] [INFO] Patch 33806152 successfully applied.
[May 7, 2022 3:15:20 PM] [INFO] Sub-set patch [32904851] has become inactive due to the application of a super-set patch [33806152].
Apply remaining 3 patches to local system with -local keyword
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /u01/software/19C_GRID/1915/33803476/33815596
Oracle Interim Patch Installer version 12.2.0.1.29
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_16-40-03PM_1.log
Verifying environment and performing prerequisite checks…
——————————————————————————–
Start OOP by Prereq process.
Launch OOP…
Oracle Interim Patch Installer version 12.2.0.1.29
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_16-42-53PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 33815596
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/19.0.0/grid’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘33815596’ to OH ‘/u01/app/19.0.0/grid’
ApplySession: Optional component(s) [ oracle.has.db.cvu, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.has.crs.cvu, 19.0.0.0.0…
Patching component oracle.has.db, 19.0.0.0.0…
Patching component oracle.has.common, 19.0.0.0.0…
Patching component oracle.has.crs, 19.0.0.0.0…
Patching component oracle.has.rsf, 19.0.0.0.0…
Patching component oracle.has.common.cvu, 19.0.0.0.0…
Patching component oracle.rhp.common, 19.0.0.0.0…
Patching component oracle.rhp.db, 19.0.0.0.0…
Patching component oracle.has.cvu, 19.0.0.0.0…
Patching component oracle.rhp.crs, 19.0.0.0.0…
Patching component oracle.xag, 19.0.0.0.0…
Patch 33815596 successfully applied.
Sub-set patch [32916816] has become inactive due to the application of a super-set patch [33815596].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_16-42-53PM_1.log
OPatch succeeded.
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /u01/software/19C_GRID/1915/33803476/33815607
Oracle Interim Patch Installer version 12.2.0.1.29
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_16-46-05PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 33815607
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/19.0.0/grid’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘33815607’ to OH ‘/u01/app/19.0.0/grid’
Patching component oracle.usm, 19.0.0.0.0…
Patch 33815607 successfully applied.
Sub-set patch [32915586] has become inactive due to the application of a super-set patch [33815607].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_16-46-05PM_1.log
OPatch succeeded.
Node1 +ASM1 $
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /u01/software/19C_GRID/1915/33803476/33911149
Oracle Interim Patch Installer version 12.2.0.1.29
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_16-47-44PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 33911149
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/19.0.0/grid’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘33911149’ to OH ‘/u01/app/19.0.0/grid’
Patching component oracle.tomcat.crs, 19.0.0.0.0…
Patch 33911149 successfully applied.
Sub-set patch [32918050] has become inactive due to the application of a super-set patch [33911149].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_16-47-44PM_1.log
OPatch succeeded.
Node1 +ASM1 $
Node1 +ASM1 $ $ORACLE_HOME/OPatch/opatch lsinventory |grep applied
Patch 33911149 : applied on Sat May 07 16:48:20 CEST 2022
Patch 33815607 : applied on Sat May 07 16:47:07 CEST 2022
Patch 33815596 : applied on Sat May 07 16:44:58 CEST 2022
Patch 33806152 : applied on Sat May 07 15:09:35 CEST 2022
Patch 33575402 : applied on Sat May 07 15:06:23 CEST 2022
Node1 +ASM1 $
# id
uid=0(root) gid=0(root) groups=0(root),232(avdefs)
root@Node1 :/export/home/oracle 0
# $ORACLE_HOME/crs/install/rootcrs.sh -postpatch
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/Node1/crsconfig/crs_postpatch_apply_inplace_Node1_2022-05-07_04-55-54PM.log
2022/05/07 16:56:11 CLSRSC-329: Replacing Clusterware entries in file ‘oracle-ohasd.service’
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [3998055650].
2022/05/07 16:58:52 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2022/05/07 16:58:53 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
root@Node1 :/export/home/oracle 0
#
start instances
srvctl start instance -d ORCLT1 -i ORCLT11
srvctl start instance -d ORCLD1 -i ORCLD11
Node2:
Prerequisites
With a grid user
Node2 +ASM2 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33806152
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_17-13-53PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node2 +ASM2 $
Node2 +ASM2 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33815596
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_17-14-09PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node2 +ASM2 $
Node2 +ASM2 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33815607
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_17-14-22PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node2 +ASM2 $
Node2 +ASM2 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33911149
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_17-14-46PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node2 +ASM2 $
Node2 +ASM2 $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/19C_GRID/1915/33803476/33575402
Oracle Interim Patch Installer version 12.2.0.1.29
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2022-05-07_17-14-57PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
Node2 +ASM2 $
Analyze command as a root user
# $ORACLE_HOME/OPatch/opatchauto apply /u01/software/19C_GRID/1915/33803476 -analyze -oh /u01/app/19.0.0/grid
OPatchauto session is initiated at Sat May 7 17:15:39 2022
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-05-07_05-15-46PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-05-07_05-16-09PM.log
The id for this session is CQW3
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0/grid
OPatchAuto successful.
——————————–Summary——————————–
Analysis for applying patches has completed successfully:
Host:Node2
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/software/19C_GRID/1915/33803476/33815596
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-16-40PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33815607
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-16-40PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-16-40PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33911149
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-16-40PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33806152
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-16-40PM_1.log
OPatchauto session completed at Sat May 7 17:17:18 2022
Time taken to complete the session 1 minute, 40 seconds
root@Node2 :/export/home/oracle 0
#
Stop Instances
Node2 $ srvctl stop instance -d ORCLD1 -i ORCLD12 -o immediate
Node2 $ srvctl stop instance -d ORCLT1 -i ORCLT12 -o immediate
Apply patches as a root user
# $ORACLE_HOME/OPatch/opatchauto apply /u01/software/19C_GRID/1915/33803476 -oh /u01/app/19.0.0/grid
OPatchauto session is initiated at Sat May 7 17:18:20 2022
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-05-07_05-18-28PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-05-07_05-18-50PM.log
The id for this session is JJ2W
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/19.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0/grid
Performing prepatch operations on CRS – bringing down CRS service on home /u01/app/19.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/Node2/crsconfig/crs_prepatch_apply_inplace_Node2_2022-05-07_05-20-32PM.log
CRS service brought down successfully on home /u01/app/19.0.0/grid
Start applying binary patch on home /u01/app/19.0.0/grid
Binary patch applied successfully on home /u01/app/19.0.0/grid
Performing postpatch operations on CRS – starting CRS service on home /u01/app/19.0.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/Node2/crsconfig/crs_postpatch_apply_inplace_Node2_2022-05-07_05-48-21PM.log
CRS service started successfully on home /u01/app/19.0.0/grid
OPatchAuto successful.
——————————–Summary——————————–
Patching is completed successfully. Please find the summary as follows:
Host:Node2
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/software/19C_GRID/1915/33803476/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-23-35PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33806152
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-23-35PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33815596
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-23-35PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33815607
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-23-35PM_1.log
Patch: /u01/software/19C_GRID/1915/33803476/33911149
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-05-07_17-23-35PM_1.log
OPatchauto session completed at Sat May 7 18:06:20 2022
Time taken to complete the session 48 minutes, 0 second
root@Node2 :/export/home/oracle 0
start instances
srvctl start instance -d ORCLT1 -i ORCLT12
srvctl start instance -d ORCLD1 -i ORCLD12
Node2 +ASM2 $ $ORACLE_HOME/OPatch/opatch lsinventory |grep -i applied
Patch 33911149 : applied on Sat May 07 17:48:00 CEST 2022
Patch 33815607 : applied on Sat May 07 17:45:35 CEST 2022
Patch 33815596 : applied on Sat May 07 17:42:14 CEST 2022
Patch 33806152 : applied on Sat May 07 17:29:05 CEST 2022
Patch 33575402 : applied on Sat May 07 17:24:27 CEST 2022
Node2 +ASM2 $
See Also
Oracle Clusterware cannot be started
Failed or Missing checks – 19c runcluvfy.sh on RAC