Right now, I am on the 19.18 for both components.
First, we will prepare the clone of the grid home and patch it with 19.19.
Unzip the Patch:
[root@ol7-19-restart software]# unzip -qo /vagrant_software/p35037840_190000_Linux-x86-64_grid_19.19.zip
Next, change the directory to the unziped patch, and run the opatch analyze to check, if you can apply the patch:
[root@ol7-19-restart 35037840]# /u01/app/19.0.0/grid/OPatch/opatchauto apply -oh /u01/app/19.0.0/grid --analyze
OPatchauto session is initiated at Sat Oct 21 06:19:19 2023
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-10-21_06-19-28AM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-10-21_06-19-35AM.log
The id for this session is D7BI
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:ol7-19-restart
SIHA Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
==Following patches were SKIPPED:
Patch: /u02/software/35037840/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-20-08AM_1.log
Reason: /u02/software/35037840/33575402 is not required to be applied to oracle home /u01/app/19.0.0/grid
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u02/software/35037840/35050331
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-20-08AM_1.log
Patch: /u02/software/35037840/35050325
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-20-08AM_1.log
Patch: /u02/software/35037840/35107512
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-20-08AM_1.log
Patch: /u02/software/35037840/35042068
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-20-08AM_1.log
OPatchauto session completed at Sat Oct 21 06:21:23 2023
Time taken to complete the session 1 minute, 55 seconds
It’s safe to apply the patch, so let’s create the clone:
[root@ol7-19-restart 35037840]# /u01/app/19.0.0/grid/OPatch/opatchauto apply -prepare-clone -oh /u01/app/19.0.0/grid -logLevel FINEST
OPatchauto session is initiated at Sat Oct 21 06:23:54 2023
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-10-21_06-23-59AM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-10-21_06-24-05AM.log
The id for this session is HUJZ
Please press ENTER button to accept system generated default clone path.
Please enter clone path [/u01/app/19.0.0/grid_2 ] :
/u01/app/grid/19.19
Specified clone path /u01/app/grid/19.19 already exists or path is not valid.
Please enter clone path [/u01/app/19.0.0/grid_2 ] :
/u01/app/grid/19.19
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
Copying the files from the existing oracle home /u01/app/19.0.0/grid to a new location. Please wait...
Clone of oracle home /u01/app/19.0.0/grid is /u01/app/grid/19.19 on host ol7-19-restart
Copying the files from the existing oracle home /u01/app/19.0.0/grid to a new location is successful.
Unlocking CRS clone home for home /u01/app/19.0.0/grid.
Prepatch operation log file location: /u01/app/19.0.0/gridbase/crsdata/ol7-19-restart/crsconfig/hapatch_2023-10-21_06-42-36AM.log
Unlocked CRS clone home successfully for home /u01/app/19.0.0/grid.
Creating clone for oracle home /u01/app/19.0.0/grid.
Clone operation successful for oracle home /u01/app/19.0.0/grid.
Performing post clone operation for oracle home /u01/app/19.0.0/grid.
Performing post clone operation was successful for oracle home /u01/app/grid/19.19.
Start applying binary patch on home /u01/app/grid/19.19
Binary patch applied successfully on home /u01/app/grid/19.19
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:ol7-19-restart
SIHA Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /u02/software/35037840/33575402
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-27-27AM_1.log
Reason: /u02/software/35037840/33575402 is not required to be applied to oracle home /u01/app/19.0.0/grid
==Following patches were SUCCESSFULLY applied:
Patch: /u02/software/35037840/35042068
Log: /u01/app/grid/19.19/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-46-59AM_1.log
Patch: /u02/software/35037840/35050325
Log: /u01/app/grid/19.19/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-46-59AM_1.log
Patch: /u02/software/35037840/35050331
Log: /u01/app/grid/19.19/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-46-59AM_1.log
Patch: /u02/software/35037840/35107512
Log: /u01/app/grid/19.19/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_06-46-59AM_1.log
Out of place patching clone home(s) summary
____________________________________________
Host : ol7-19-restart
Actual Home : /u01/app/19.0.0/grid
Version:19.0.0.0.0
Clone Home Path : /u01/app/grid/19.19
OPatchauto session completed at Sat Oct 21 07:21:30 2023
Time taken to complete the session 57 minutes, 36 seconds
Clone of the GRID is prepared, now, let’s prepare the clone of th DB home.
Unzip the patch:
[root@ol7-19-restart 35037840]# unzip -qo /vagrant_software/p35042068_190000_Linux-x86-64_19_19_db.zip
Do the analyze of the patch:
[root@ol7-19-restart 35037841]# /u02/app/oracle/roduct/19.0.0/dbhome_1/OPatch/opatchauto apply -oh /u02/app/oracle/product/19.0.0/dbhome_1 -analyze
OPatchauto session is initiated at Sat Oct 21 07:46:43 2023
System initialization log file is /u02/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2023-10-21_07-47-35AM.log.
Session log file is /u02/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/opatchauto2023-10-21_07-47-46AM.log
The id for this session is P8CF
Executing OPatch prereq operations to verify patch applicability on home /u02/app/oracle/product/19.0.0/dbhome_1
Patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/dbhome_1
Executing patch validation checks on home /u02/app/oracle/product/19.0.0/dbhome_1
Patch validation checks successfully completed on home /u02/app/oracle/product/19.0.0/dbhome_1
Verifying SQL patch applicability on home /u02/app/oracle/product/19.0.0/dbhome_1
SQL patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/dbhome_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:ol7-19-restart
SIDB Home:/u02/app/oracle/product/19.0.0/dbhome_1
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u02/software/35042068
Log: /u02/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_07-48-16AM_1.log
OPatchauto session completed at Sat Oct 21 07:50:27 2023
Time taken to complete the session 2 minutes, 54 seconds
It’s OK, so lets prepare the clone:
[root@ol7-19-restart 35037842]# /u02/app/oracle/product/db_home1/OPatch/opatchauto apply -prepare-clone -oh /u02/app/oracle/product/19.0.0/dbhome_1 -logLevel FINEST
OPatchauto session is initiated at Sat Oct 21 07:50:54 2023
System initialization log file is /u02/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2023-10-21_07-51-04AM.log.
Session log file is /u02/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/opatchauto2023-10-21_07-51-12AM.log
The id for this session is ACVC
Please press ENTER button to accept system generated default clone path.
Please enter clone path [/u02/app/oracle/product/19.0.0/dbhome_2 ] :
/u02/app/oracle/product/19.19/dbhome_1
Executing OPatch prereq operations to verify patch applicability on home /u02/app/oracle/product/19.0.0/dbhome_1
Patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/dbhome_1
Executing patch validation checks on home /u02/app/oracle/product/19.0.0/dbhome_1
Patch validation checks successfully completed on home /u02/app/oracle/product/19.0.0/dbhome_1
Verifying SQL patch applicability on home /u02/app/oracle/product/19.0.0/dbhome_1
^[[5~SQL patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/dbhome_1
Copying the files from the existing oracle home /u02/app/oracle/product/19.0.0/dbhome_1 to a new location. Please wait...
^[[CClone of oracle home /u02/app/oracle/product/19.0.0/dbhome_1 is /u02/app/oracle/product/19.19/dbhome_1 on host ol7-19-restart
Copying the files from the existing oracle home /u02/app/oracle/product/19.0.0/dbhome_1 to a new location is successful.
Creating clone for oracle home /u02/app/oracle/product/19.0.0/dbhome_1.
Clone operation successful for oracle home /u02/app/oracle/product/19.0.0/dbhome_1.
Performing post clone operation for oracle home /u02/app/oracle/product/19.0.0/dbhome_1.
Performing post clone operation was successful for oracle home /u02/app/oracle/product/19.19/dbhome_1.
Start applying binary patch on home /u02/app/oracle/product/19.19/dbhome_1
Binary patch applied successfully on home /u02/app/oracle/product/19.19/dbhome_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:ol7-19-restart
SIDB Home:/u02/app/oracle/product/19.0.0/dbhome_1
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u02/software/35042068
Log: /u02/app/oracle/product/19.19/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-21_08-12-51AM_1.log
Out of place patching clone home(s) summary
____________________________________________
Host : ol7-19-restart
Actual Home : /u02/app/oracle/product/19.0.0/dbhome_1
Version:19.0.0.0.0
Clone Home Path : /u02/app/oracle/product/19.19/dbhome_1
OPatchauto session completed at Sat Oct 21 08:36:52 2023
Time taken to complete the session 45 minutes, 59 seconds
Now, do the switchover to the new GRID home:
[root@ol7-19-restart software]# /u01/app/19.0.0/grid/OPatch/opatchauto apply -switch-clone -oh /u01/app/19.0.0/grid -logLevel FINEST
OPatchauto session is initiated at Sat Oct 21 18:56:23 2023
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-10-21_06-56-45PM.log
The id for this session is EBJD
Executing patch validation checks on home /u01/app/grid/19.19
Patch validation checks successfully completed on home /u01/app/grid/19.19
Verifying clone home details before switch for oracle home /u01/app/grid/19.19.
Verified clone home details successfully for oracle home /u01/app/grid/19.19 before switch.
Update nodelist in the inventory for oracle home /u01/app/grid/19.19.
Update nodelist in the inventory is completed for oracle home /u01/app/grid/19.19.
Performing postpatch operations on CRS - starting CRS service on home /u01/app/grid/19.19
Postpatch operation log file location: /u01/app/19.0.0/gridbase/crsdata/ol7-19-restart/crsconfig/hapatch_2023-10-21_06-57-31PM.log
CRS service started successfully on home /u01/app/grid/19.19
Confirm that all resources have been started from home /u01/app/grid/19.19.
All resources have been started successfully from home /u01/app/grid/19.19.
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching session reported following warning(s):
_________________________________________________
[Note]: Please verify the database is running from the desired Oracle home, if not then manually execute
$ORACLE_HOME/bin/srvctl modify database command to fix the problem
Out of place patching clone home(s) summary
____________________________________________
Host : ol7-19-restart
Actual Home : /u01/app/19.0.0/grid
Version:19.0.0.0.0
Clone Home Path : /u01/app/grid/19.19
OPatchauto session completed at Sat Oct 21 19:05:36 2023
Time taken to complete the session 9 minutes, 15 seconds
Check, that the GRID is running from the new home:
[root@ol7-19-restart software]# ps -aef|grep d.bin grid 26525 1 0 19:00 ? 00:00:04 /u01/app/grid/19.19/bin/ohasd.bin reboot _ORA_BLOCKING_STACK_LOCALE=AMERICAN_AMERICA.AL32UTF8 grid 26734 1 0 19:00 ? 00:00:00 /u01/app/grid/19.19/bin/evmd.bin grid 26862 1 0 19:00 ? 00:00:01 /u01/app/grid/19.19/bin/ocssd.bin root 28383 8382 0 19:08 pts/0 00:00:00 grep --color=auto d.bin
Now, do the switchover to the new DB home and do the datpatch:
[root@ol7-19-restart software]# /u02/app/oracle/product/19.0.0/dbhome_1/OPatch/opatchauto apply -switch-clone -oh /u02/app/oracle/product/19.0.0/dbhome_1 -logLevel FINEST
OPatchauto session is initiated at Sat Oct 21 19:13:01 2023
Session log file is /u02/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/opatchauto2023-10-21_07-13-27PM.log
The id for this session is LGU3
Executing patch validation checks on home /u02/app/oracle/product/19.19/dbhome_1
Patch validation checks successfully completed on home /u02/app/oracle/product/19.19/dbhome_1
Verifying clone home details before switch for oracle home /u02/app/oracle/product/19.19/dbhome_1.
Verified clone home details successfully for oracle home /u02/app/oracle/product/19.19/dbhome_1 before switch.
Bringing down database service on home /u02/app/oracle/product/19.19/dbhome_1
Database service successfully brought down on home /u02/app/oracle/product/19.19/dbhome_1
Bringing down database service on home /u02/app/oracle/product/19.19/dbhome_1
Following database has been stopped and will be restarted later during the session: mncdb
Database service successfully brought down on home /u02/app/oracle/product/19.19/dbhome_1
Starting database service on home /u02/app/oracle/product/19.19/dbhome_1
Database service successfully started on home /u02/app/oracle/product/19.19/dbhome_1
Preparing home /u02/app/oracle/product/19.19/dbhome_1 after database service restarted
No step execution required.........
Modifying the database(s) to use new location home /u02/app/oracle/product/19.19/dbhome_1.
All database(s) modified successfully to run from new location home /u02/app/oracle/product/19.19/dbhome_1.
Trying to apply SQL patch on home /u02/app/oracle/product/19.19/dbhome_1
SQL patch applied successfully on home /u02/app/oracle/product/19.19/dbhome_1
Trying to apply SQL patch on home /u02/app/oracle/product/19.19/dbhome_1
SQL patch applied successfully on home /u02/app/oracle/product/19.19/dbhome_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Out of place patching clone home(s) summary
____________________________________________
Host : ol7-19-restart
Actual Home : /u02/app/oracle/product/19.0.0/dbhome_1
Version:19.0.0.0.0
Clone Home Path : /u02/app/oracle/product/19.19/dbhome_1
OPatchauto session completed at Sat Oct 21 20:47:30 2023
Time taken to complete the session 94 minutes, 30 seconds