How to Patch Oracle Grid Infrastructure 19c ?
p36916690_190000_Linux-x86-64.zip <<<<<for Oracle Interim Patch Installer version 12.2.0.1.44 OPatch 12.2.0.1.44 for DB 23.0.0.0.0 (Oct 2024)
download below --
https://updates.oracle.com/download/6880880.html
OPatch 12.2.0.1.44 for DB 23.0.0.0.0 (Oct 2024)
unzip -q p6880880_230000_Linux-x86-64.zip -d /u01/app/19.0.0/grid
replace /u01/app/19.0.0/grid/OPatch/opatchauto? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
Patch: /home/grid/36916690/36917397
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-27_10-51-34AM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(12173.691MB) is not available.]
Patch: /home/grid/36916690/36758186
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-27_10-51-34AM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(12173.691MB) is not available.]
================================================================================
To Clean Space !!!!!
export ORACLE_HOME=/u01/app/19.0.0/grid
export PATH=$ORACLE_HOME/OPatch:$PATH
echo $ORACLE_HOME
[grid@srv1 ~]$ opatch version
OPatch Version: 12.2.0.1.44
OPatch succeeded.
[grid@srv1 grid]$ du -sh .patch_storage
15G .patch_storage
[grid@srv1 grid]$ $ORACLE_HOME/OPatch/opatch util cleanup
Oracle Interim Patch Installer version 12.2.0.1.44
Copyright (c) 2024, Oracle Corporation. All rights reserved.
[grid@srv1 grid]$ du -sh .patch_storage
6.5G .patch_storage
[grid@srv1 grid]$ $ORACLE_HOME/OPatch/opatch util cleanup
/home/grid/36916690
The OPatch being used is version 12.2.0.1.42 while the following patch(es) require higher versions:
Patch 36917416 requires OPatch version 12.2.0.1.43 or later.
export ORACLE_HOME=/u01/app/19.0.0/grid
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
[grid@srv1 36916690]$ pwd
/home/grid/36916690
[grid@srv1 36916690]$ ls -ltr
total 144
drwxr-x---. 5 grid oinstall 62 Oct 11 11:16 36917416
drwxr-x---. 5 grid oinstall 62 Oct 11 11:17 36917397
drwxr-x---. 4 grid oinstall 48 Oct 11 11:17 36940756
drwxr-x---. 5 grid oinstall 81 Oct 11 11:17 36912597
drwxr-x---. 4 grid oinstall 48 Oct 11 11:17 36758186
-rw-r--r--. 1 grid oinstall 0 Oct 11 11:20 README.txt
drwxr-x---. 2 grid oinstall 4096 Oct 11 11:20 automation
-rw-rw-r--. 1 grid oinstall 5824 Oct 11 15:43 bundle.xml
-rw-r--r--. 1 grid oinstall 134032 Oct 14 14:01 README.html
create below commands ..
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917416
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917397
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36940756
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36912597
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36758186
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917416| grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917397| grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36940756| grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36912597| grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36758186| grep checkConflictAgainstOHWithDetail
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917416
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation. All rights reserved.
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.42
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-27_09-05-59AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917397
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation. All rights reserved.
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.42
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-27_09-07-44AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36940756
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation. All rights reserved.
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.42
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-27_09-09-34AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36912597
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation. All rights reserved.
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.42
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-27_09-11-21AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36758186
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2024, Oracle Corporation. All rights reserved.
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.42
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-27_09-14-27AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
=========================
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917416| grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917397| grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36940756| grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36912597| grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36758186| grep checkConflictAgainstOHWithDetail
All Passed ..
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917416| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36917397| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36940756| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36912597| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.
[grid@srv1 36916690]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36916690/36758186| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.
su -
Password:
Last login: Sat Oct 26 22:04:57 +04 2024
[root@srv1 grid]# pwd
/home/grid
[root@srv1 grid]# ls -ltr
total 132892
drwxr-xr-x. 2 grid oinstall 6 Jul 3 2020 Videos
drwxr-xr-x. 2 grid oinstall 6 Jul 3 2020 Templates
drwxr-xr-x. 2 grid oinstall 6 Jul 3 2020 Public
drwxr-xr-x. 2 grid oinstall 6 Jul 3 2020 Pictures
drwxr-xr-x. 2 grid oinstall 6 Jul 3 2020 Music
drwxr-xr-x. 2 grid oinstall 6 Jul 3 2020 Downloads
drwxr-xr-x. 2 grid oinstall 6 Jul 3 2020 Documents
drwxr-xr-x. 2 grid oinstall 40 Jul 3 2020 Desktop
-rw-r--r--. 1 grid oinstall 133535622 Apr 19 2024 p6880880_210000_Linux-x86-64.zip
drwxr-x---. 8 grid oinstall 4096 Oct 11 11:16 36916690
-rw-rw-r--. 1 grid oinstall 2537084 Oct 15 18:36 PatchSearch.xml
[root@srv1 grid]#
export ORACLE_HOME=/u01/app/19.0.0/grid
export PATH=$ORACLE_HOME/OPatch:$PATH
echo $ORACLE_HOME
[root@srv1 grid]# ls -ltr /home/grid/36916690
total 144
drwxr-x---. 5 grid oinstall 62 Oct 11 11:16 36917416
drwxr-x---. 5 grid oinstall 62 Oct 11 11:17 36917397
drwxr-x---. 4 grid oinstall 48 Oct 11 11:17 36940756
drwxr-x---. 5 grid oinstall 81 Oct 11 11:17 36912597
drwxr-x---. 4 grid oinstall 48 Oct 11 11:17 36758186
-rw-r--r--. 1 grid oinstall 0 Oct 11 11:20 README.txt
drwxr-x---. 2 grid oinstall 4096 Oct 11 11:20 automation
-rw-rw-r--. 1 grid oinstall 5824 Oct 11 15:43 bundle.xml
-rw-r--r--. 1 grid oinstall 134032 Oct 14 14:01 README.html
[root@srv1 grid]#
$ORACLE_HOME/OPatch/opatchauto apply /home/grid/36916690 -oh $ORACLE_HOME
SQL>
set pages 50000 long 100000
spool dbms_qopatch_lsinventory.TXT
select dbms_qopatch.get_opatch_lsinventory from dual;
SQL>
set long 1000000 linesize 300 pagesize 300
select xmltransform(dbms_qopatch.is_patch_installed('36917416'),dbms_qopatch.get_opatch_xslt) from dual;
[root@srv1 grid]# $ORACLE_HOME/OPatch/opatchauto apply /home/grid/36916690 -oh $ORACLE_HOME
OPatchauto session is initiated at Sun Oct 27 11:11:39 2024
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2024-10-27_11-11-48AM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2024-10-27_11-11-52AM.log
The id for this session is 7HX1
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/srv1/crsconfig/hapatch_2024-10-27_11-16-45AM.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
Running rootadd_rdbms.sh on home /u01/app/19.0.0/grid
Successfully executed rootadd_rdbms.sh 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/srv1/crsconfig/hapatch_2024-10-27_11-32-03AM.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:srv1
SIHA Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /home/grid/36916690/36758186
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-27_11-12-18AM_1.log
Reason: /home/grid/36916690/36758186 is not required to be applied to oracle home /u01/app/19.0.0/grid
==Following patches were SUCCESSFULLY applied:
Patch: /home/grid/36916690/36912597
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-27_11-17-44AM_1.log
Patch: /home/grid/36916690/36917397
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-27_11-17-44AM_1.log
Patch: /home/grid/36916690/36917416
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-27_11-17-44AM_1.log
Patch: /home/grid/36916690/36940756
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-27_11-17-44AM_1.log
OPatchauto session completed at Sun Oct 27 11:34:05 2024
Time taken to complete the session 22 minutes, 18 seconds
===
[grid@srv1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
[grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch util cleanup
Oracle Interim Patch Installer version 12.2.0.1.44
Copyright (c) 2024, Oracle Corporation. All rights reserved.
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.44
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-27_11-41-28AM_1.log
Invoking utility "cleanup"
OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.
You will be still able to rollback patches after this cleanup.
Do you want to proceed? [y|n]
y
[grid@srv1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
[grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch util cleanup
Oracle Interim Patch Installer version 12.2.0.1.44
Copyright (c) 2024, Oracle Corporation. All rights reserved.
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.44
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-27_11-41-28AM_1.log
Invoking utility "cleanup"
OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.
You will be still able to rollback patches after this cleanup.
Do you want to proceed? [y|n]
y
User Responded with: Y
Backup area for restore has been cleaned up. For a complete list of files/directories
deleted, Please refer log file.
OPatch succeeded.
[grid@srv1 ~]$
[grid@srv1 ~]$
[grid@srv1 ~]$
====
crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@srv1 ~]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [19.0.0.0.0]
[grid@srv1 ~]$ crsctl query has releasepatch
Oracle Clusterware release patch level is [760403972] and the complete list of patches [36758186 36912597 36917397 36917416 36940756 ] have been applied on the local node. The release patch string is [19.25.0.0.0].
[grid@srv1 ~]$ crsctl query has softwarepatch
Oracle Clusterware patch level on node srv1 is [760403972].
[grid@srv1 ~]$
[grid@srv1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADISK.dg
ONLINE ONLINE srv1 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ora.OCRDISK.dg
ONLINE ONLINE srv1 STABLE
ora.asm
ONLINE ONLINE srv1 Started,STABLE
ora.ons
OFFLINE OFFLINE srv1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE srv1 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE srv1 STABLE
ora.oradb.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
--------------------------------------------------------------------------------
[grid@srv1 ~]$
