Patch 32545008 - GI Release Update 19.11.0.0.
210420
--------------------------------
1. Download/Copy Patch on server
--------------------------------
mkdir -p /stage_software/Patches/RU11
cd /stage_software/Patches/RU11
p32545008_190000_Linux-x86-64.zip <--- GI patch
p6880880_122010_Linux-x86-64.zip <---- OPatch tool
-ensure the grid and oracle user can access it while applying
chmod -R 775 /stage_software/Patches/RU11/
--------------------------------
2. Verify has and ASM is healthy
--------------------------------
[grid@rac3 ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM
The Oracle base has been set to /u002/app/gridbase
[grid@rac3 ~]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@rac3 ~]$ srvctl status asm
ASM is running on rac3
[grid@rac3 ~]$ srvctl status database -d PROD -v -f
Database PROD is running. Instance status: Open.
[grid@rac3 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac3
[grid@rac3 ~]$
-------------------------------------------------
3. Update the Required/Latest OPatch tool version
-------------------------------------------------
You must use the OPatch utility version 12.2.0.1.24 or later to apply this patch.
For grid home need to do as a root user as GI home is owned by root
after installatin
--Check current version
[oracle@rac3 RU11]$ /u002/app/oracle/product/19.3.0/grid/OPatch/opatch version
OPatch Version: 12.2.0.1.17
--/Update OPatch for GI home
su - root
cd /u002/app/oracle/product/19.3.0/grid
mv OPatch OPatch.old
unzip -qqo /stage_software/Patches/RU11/p6880880_122010_Linux-x86-64.zip -d .
chown -R grid:oinstall OPatch
chmod -R 775 OPatch
/u002/app/oracle/product/19.3.0/grid/OPatch/opatch version
For RDBMS we can do it as a oracle user
su - oracle
cd /u008/app/oracle/product/19.3.0/dbhome_1
mv OPatch OPatch.old
unzip -qqo /stage_software/Patches/RU11/p6880880_122010_Linux-x86-64.zip -d .
chown -R oracle:oinstall OPatch
chmod -R 775 OPatch
/u008/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch version
--------------------------------
4. Apply Patch using OPatch auto
--------------------------------
a. Run first in Anlyze mode and see the result , anayze just checks the
prerequisites part does not apply patch
su - root
/u002/app/oracle/product/19.3.0/grid/OPatch/opatchauto apply
/stage_software/Patches/RU11/32545008 -analyze
b. Actual apply
su - root
/u002/app/oracle/product/19.3.0/grid/OPatch/opatchauto apply
/stage_software/Patches/RU11/32545008
5. Verify the Patches
Once opatchauto is successfull verify the patches
[root@rac3 grid]# su - grid
[grid@rac3 ~]$ /u002/app/oracle/product/19.3.0/grid/OPatch/opatch lspatches -oh
/u002/app/oracle/product/19.3.0/grid
32585572;DBWLM RELEASE UPDATE 19.0.0.0.0 (32585572)
32584670;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32584670)
32579761;OCW RELEASE UPDATE 19.11.0.0.0 (32579761)
32576499;ACFS RELEASE UPDATE 19.11.0.0.0 (32576499)
32545013;Database Release Update : 19.11.0.0.210420 (32545013)
OPatch succeeded.
[root@rac3 grid]# su - oracle
Last login: Mon Jul 5 17:06:37 IST 2021
[oracle@rac3 ~]$ /u008/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lspatches -
oh /u008/app/oracle/product/19.3.0/dbhome_1
32579761;OCW RELEASE UPDATE 19.11.0.0.0 (32579761)
32545013;Database Release Update : 19.11.0.0.210420 (32545013)
OPatch succeeded.
**************************
--what if opatchauto fails
***************************
1. identify and fix the failure
2. resume opatchauto
/u002/app/oracle/product/19.3.0/grid/OPatch/opatchauto resume
should show as below 19.3 only
[root@rac3 grid]# su - grid
Last login: Mon Jul 5 17:42:02 IST 2021
[grid@rac3 ~]$ /u002/app/oracle/product/19.3.0/grid/OPatch/opatch lspatches -oh
/u002/app/oracle/product/19.3.0/grid
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)
OPatch succeeded.
[grid@rac3 ~]$ logout
[root@rac3 grid]#
[root@rac3 grid]# su - oracle
Last login: Mon Jul 5 17:43:26 IST 2021
[oracle@rac3 ~]$ /u008/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lspatches -
oh /u008/app/oracle/product/19.3.0/dbhome_1
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
