Steps to Apply Database and Grid Infrastructure RU Patch Before Grid Infrastructure Configuration (before root.sh or rootupgrade.sh execution)

March 8, 2022
()

Steps to Apply Database and Grid Infrastructure RU Patch Before Grid Infrastructure Configuration (before root.sh or rootupgrade.sh execution)


If you are planning to upgrade your Grid Infrastructure (GI) and Database from the 12.2 version to the latest Release Update (RU) 19.14. First, we need to download Gold Image 19.3 software for GI and Database and then Upgrade your Grid Infrastructure and database from 12.2 to 19.3 and then apply the latest Patch 33509923: RELEASE UPDATE 19.14.0.0.0. 


Before executing the root script, applying a GI patch with the patch readme may result in fail as these instructions are written for a “configured” GI Home. “opatch auto” must NOT be used as the new GI home hasn’t been configured yet.


This blog describes the procedure to apply a Grid Infrastructure patch(including GI PSU patch) before GI is configured (in other words, before root.sh or rootupgrade.sh is executed).


Below are the high-level steps we will follow.
Step 1. Download Gold Image Grid and DB software 19.3
Step 2. Download latest January 2022 RU Patch 33509923
Step 3. Download Latest OPatch
Step 4. Copy all downloaded software to Server 
Step 5. Unzip GI Software and Update Grid Home Opatch Utility
Step 6. Unzip DB Software and Update DB Home Opatch Utility
Step 7. Configure and Apply Patch on Grid Home
Step 8. Configure and Apply Patch on Oracle DB Home


Below are setup details and the same will be used in this demonstration.

Grid Home Location/u01/app/19.0/grid
Oracle DB Home Location /u01/app/oracle/product/19.0/db_1
19.3 Gold Image Location /u01/19c_soft
Patch Software Location/u01/19c_patch


Step 1. Download Gold Image Grid and DB software 19.3: Download Gold Image 19.3 for GI and Database Click here to download.


Step 2. Download latest January 2022 RU Patch 33509923: Download January 2022 RU patch 33509923 Click here to get January 2022 Patch IDs along with enable download link.


Step 3. Download Latest Opatch: Download the latest OPatch utility Click here to download.


Step 4. Copy all downloaded software to Server: Use WinScp software to transfer all downloaded software to Server.

[root@test-machine03 ~]#
[root@test-machine03 ~]# cd /u01/19c_soft
[root@test-machine03 19c_soft]#
[root@test-machine03 19c_soft]# ls -l
total 5809468
-rw-r--r--. 1 root root 3059705302 Nov  1  2020 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 root root 2889184573 Nov 18  2020 LINUX.X64_193000_grid_home.zip
[root@test-machine03 19c_soft]#
[root@test-machine03 19c_soft]# chown grid:oinstall LINUX.X64_193000_grid_home.zip
[root@test-machine03 19c_soft]# chown oracle:oinstall LINUX.X64_193000_db_home.zip
[root@test-machine03 19c_soft]# 
[root@test-machine03 19c_soft]# ls -l
total 5809468
-rw-r--r--. 1 oracle oinstall 3059705302 Nov  1  2020 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 grid   oinstall 2889184573 Nov 18  2020 LINUX.X64_193000_grid_home.zip
[root@test-machine03 19c_soft]# 

[root@test-machine03 19c_soft]#
[root@test-machine03 19c_soft]# cd /u01/19c_patch
[root@test-machine03 19c_patch]#
[root@test-machine03 19c_patch]# ls -l
total 5139128
-rw-r--r--. 1 root root     2622069290 Feb 11 22:26 p33509923_190000_Linux-x86-64.zip
-rw-r--r--. 1 root root      122883931 Feb 11 22:55 p6880880_190000_Linux-x86-64.zip
[root@test-machine03 19c_patch]#


Step 5. Unzip GI Software and Update Grid Home OPatch Utility: Follow below steps to unzip and update OPatch folder.

[grid@test-machine03 ~]$
[grid@test-machine03 ~]$ mkdir  -p /u01/app/19.0/grid
[grid@test-machine03 ~]$
[grid@test-machine03 ~]$ cd /u01/19c_soft
[grid@test-machine03 19c_soft]$
[grid@test-machine03 19c_soft]$ ls -l
total 5809468
-rw-r--r--. 1 oracle oinstall 3059705302 Nov  1  2020 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 grid   oinstall 2889184573 Nov 18  2020 LINUX.X64_193000_grid_home.zip
[grid@test-machine03 19c_soft]$
[grid@test-machine03 19c_soft]$ unzip -q LINUX.X64_193000_grid_home.zip -d /u01/app/19.0/grid
[grid@test-machine03 19c_soft]$
[grid@test-machine03 ~]$
[grid@test-machine03 ~]$ /u01/app/19.0/grid/OPatch/opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.
[grid@test-machine03 ~]$
[grid@test-machine03 ~]$
[grid@test-machine03 ~]$ cd /u01/app/19.0/grid/
[grid@test-machine03 grid]$
[grid@test-machine03 grid]$ mv OPatch OPatch_Old
[grid@test-machine03 grid]$
[grid@test-machine03 grid]$ cd /u01/19c_patch
[grid@test-machine03 19c_patch]$ ls -ltr
total 5137676
-rw-r--r--. 1 root root 2622069290 Feb 11 22:26 p33509923_190000_Linux-x86-64.zip
-rw-r--r--. 1 root root  122883931 Feb 11 22:55 p6880880_190000_Linux-x86-64.zip
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$ unzip -q p6880880_190000_Linux-x86-64.zip -d /u01/app/19.0/grid/
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$ /u01/app/19.0/grid/OPatch/opatch version
OPatch Version: 12.2.0.1.29

OPatch succeeded.
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$ unzip -q p33509923_190000_Linux-x86-64.zip
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$ ls -ltr
total 5139124
drwxr-x---. 8 grid oinstall       4096 Jan 13 09:48 33509923
-rw-rw-r--. 1 grid oinstall    1478442 Jan 20 08:25 PatchSearch.xml
-rw-r--r--. 1 root root     2622069290 Feb 11 22:26 p33509923_190000_Linux-x86-64.zip
-rw-r--r--. 1 root root      122883931 Feb 11 22:55 p6880880_190000_Linux-x86-64.zip
[grid@test-machine03 19c_patch]$
[grid@test-machine03 19c_patch]$


Step 6. Unzip DB Software and Update DB Home OPatch Utility: Follow below steps to unzip and update OPatch folder.

[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ mkdir -p /u01/app/oracle/product/19.0/db_1
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ cd /u01/19c_soft
[oracle@test-machine03 19c_soft]$
[oracle@test-machine03 19c_soft]$ ls -l
total 5809468
-rw-r--r--. 1 oracle oinstall 3059705302 Nov  1  2020 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 grid   oinstall 2889184573 Nov 18  2020 LINUX.X64_193000_grid_home.zip
[oracle@test-machine03 19c_soft]$
[oracle@test-machine03 19c_soft]$ unzip -q LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.0/db_1
[oracle@test-machine03 19c_soft]$
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ /u01/app/oracle/product/19.0/db_1/OPatch/opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ 
[oracle@test-machine03 ~]$ cd /u01/app/oracle/product/19.0/db_1/
[oracle@test-machine03 db_1]$
[oracle@test-machine03 db_1]$ mv OPatch OPatch_Old
[oracle@test-machine03 db_1]$
[oracle@test-machine03 db_1]$ cd /u01/19c_patch/
[oracle@test-machine03 19c_patch]$
[oracle@test-machine03 19c_patch]$ ls -l
total 5137676
-rw-r--r--. 1 root root 2622069290 Feb 11 22:26 p33509923_190000_Linux-x86-64.zip
-rw-r--r--. 1 root root  122883931 Feb 11 22:55 p6880880_190000_Linux-x86-64.zip
[oracle@test-machine03 19c_patch]$
[oracle@test-machine03 19c_patch]$ unzip -q p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.0/db_1/
[oracle@test-machine03 19c_patch]$
[oracle@test-machine03 19c_patch]$
[oracle@test-machine03 19c_patch]$ /u01/app/oracle/product/19.0/db_1/OPatch/opatch version
OPatch Version: 12.2.0.1.29

OPatch succeeded.
[oracle@test-machine03 19c_patch]$


Step 7. Configure and Apply Patch on Grid Home: Once all above steps are done. Export Display variable and invoke gridSetup.sh with option -applyRU. Follow the below screenshots. Please note here we are not performing actual GI Upgrade, our GI is still running in 12.2 version. We are only applying RU on top of 19.3 GI Home, so GI Home will be ready with RU patch 19.14 when we do actual upgrade. Also since this is not actual GI upgrade we will not execute rootupgrade.sh script. We need to run rootupgrade.sh script only when we are performing actual GI upgrade from 12.2 to 19C. After below steps are done we can verify patches are applied with command opatch lspatches. So this single command has done 19.3 Grid Setup and applied RU patch.

[grid@test-machine03 bin]$
[grid@test-machine03 bin]$ pwd
/u01/app/12.2/grid/bin
[grid@test-machine03 bin]$ ./crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [12.2.0.1.0]
[grid@test-machine03 bin]$
[grid@test-machine03 bin]$ ./crsctl query has softwareversion
Oracle High Availability Services version on the local node is [12.2.0.1.0]
[grid@test-machine03 bin]$
[grid@test-machine03 bin]$

[grid@test-machine03 grid]$
[grid@test-machine03 grid]$ export DISPLAY=localhost:10.0
[grid@test-machine03 grid]$ xclock
Warning: Missing charsets in String to FontSet conversion
[grid@test-machine03 grid]$ 
[grid@test-machine03 grid]$ export ORACLE_HOME=/u01/app/19.0/grid
[grid@test-machine03 grid]$ export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
[grid@test-machine03 grid]$ which opatch
/u01/app/19.0/grid/OPatch/opatch
[grid@test-machine03 grid]$ cd $ORACLE_HOME 
[grid@test-machine03 grid]$ ./gridSetup.sh -applyRU /u01/19c_patch/33509923
Preparing the home to patch...
Applying the patch /u01/19c_patch/33509923...


Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/GridSetupActions2022-02-14_12-27-15PM/installerPatchActions_2022-02-14_12-27-15PM.log
Launching Oracle Grid Infrastructure Setup Wizard...

The response file for this session can be found at:
 /u01/app/19.0/grid/install/response/grid_2022-02-14_12-27-15PM.rsp

You can find the log of this install session at:
 /u01/app/oraInventory/logs/GridSetupActions2022-02-14_12-27-15PM/gridSetupActions2022-02-14_12-27-15PM.log
[grid@test-machine03 grid]$ 
[grid@test-machine03 grid]$
[grid@test-machine03 grid]$ $ORACLE_HOME/OPatch/opatch lspatches
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
33534448;ACFS RELEASE UPDATE 19.14.0.0.0 (33534448)
33529556;OCW RELEASE UPDATE 19.14.0.0.0 (33529556)
33515361;Database Release Update : 19.14.0.0.220118 (33515361)
33239955;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33239955)

OPatch succeeded.
[grid@test-machine03 grid]$
Click Yes
Click Ignore All
Do not run rootupgrade.sh script at this stage as we are going to execute it in 19c Grid actual upgrade, just Click OK and proceed.


Step 8. Configure and Apply Patch on Oracle DB Home: Once all above steps are done. Export Display variable and invoke runInstaller with option -applyRU. Follow the below screenshots. After below steps are done, we can verify patches are applied with command opatch lspatches. So this single command has done 19.3 DB Setup and applied RU patch.

[oracle@test-machine03 ~]$ 
[oracle@test-machine03 ~]$ export DISPLAY=localhost:10.0
[oracle@test-machine03 ~]$ 
[oracle@test-machine03 ~]$ xclock
Warning: Missing charsets in String to FontSet conversion
[oracle@test-machine03 ~]$ 
[oracle@test-machine03 ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0/db_1
[oracle@test-machine03 ~]$ export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
[oracle@test-machine03 ~]$ which opatch
/u01/app/oracle/product/19.0/db_1/OPatch/opatch
[oracle@test-machine03 ~]$ 
[oracle@test-machine03 ~]$ cd $ORACLE_HOME
[oracle@test-machine03 db_1]$ 
[oracle@test-machine03 db_1]$ 
[oracle@test-machine03 db_1]$ ./runInstaller -applyRU /u01/19c_patch/33509923
Preparing the home to patch...
Applying the patch /u01/19c_patch/33509923...
Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/InstallActions2022-02-14_01-35-36PM/installerPatchActions_2022-02-14_01-35-36PM.log
Launching Oracle Database Setup Wizard...


The response file for this session can be found at:
 /u01/app/oracle/product/19.0/db_1/install/response/db_2022-02-14_01-35-36PM.rsp

You can find the log of this install session at:
 /u01/app/oraInventory/logs/InstallActions2022-02-14_01-35-36PM/installActions2022-02-14_01-35-36PM.log
[oracle@test-machine03 db_1]$ 
[oracle@test-machine03 db_1]$ 
[oracle@test-machine03 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
33529556;OCW RELEASE UPDATE 19.14.0.0.0 (33529556)
33515361;Database Release Update : 19.14.0.0.220118 (33515361)

OPatch succeeded.
[oracle@test-machine03 ~]$
Click Ignore All


Reference : MOS Note : How to Apply a Grid Infrastructure Patch Before Grid Infrastructure Configuration (before root.sh or rootupgrade.sh or gridsetup.bat) is Executed (Doc ID 1410202.1)

This document is just for learning purpose and always validate in the LAB environment first before applying in the LIVE environment.


Hope so you like this article!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to understand more about our pursuit.

 

Related Articles

, , , ,


Loading

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Jamsher Khan

🌐

Hello and welcome to DBsGuru,I’m Jamsher Khan working as Senior Oracle DBA based in KSA-Jeddah, I have working experience in Oracle DBA, SQL Server, MySql, PostgreSQL, Linux, Golden Gate, ODA.Thanks for the visits!Share Learn Grow!

Leave a Reply

Your email address will not be published. Required fields are marked *