OPatch Apply for Grid 19.27 <<<< 37641958

Oracle Grid Infrastructure 19.27 Patch (37641958) - Application Log

📋 Patch Information

• Patch ID: 37641958
• Patch Type: GI RU 19.27.0.0.250415
• OPatch Required: 12.2.0.1.45 or later download only same base p6880880_190000_Linux-x86-64.zip v
• Oracle Home: /u01/app/19.0.0/grid

📁 Directory Structure of Patch Location

/home/grid/37641958/
├── 37654975/
├── 37643161/
├── 37762426/
├── 36758186/
├── 37642901/
├── README.txt
├── README.html
├── bundle.xml
└── automation/
    

⚠️ Pre-checks & Requirements

• Review README.txt and README.html in patch directory.

OPatch Version Check

export PATH=$ORACLE_HOME/OPatch:$PATH
opatch version
# Output: OPatch Version: 12.2.0.1.46 ✅

Disk Space Verification

• Required: ~14.5GB
• Initial Free Space on /: 17GB
• After patch: 12GB available

Relocated Old Patch Data

mv /u01/app/19.0.0/grid/.patch_storage/36912597_Oct_11_2024_06_47_24/ /home/grid/

  
 
 Create space .. 
 
 Delete Inactive Patches (OPatch 12.2.0.1.37+)
 $ORACLE_HOME/OPatch/opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"
 
 ./opatch util listorderedinactivepatches
./opatch util deleteinactivepatches
./opatch util cleanup
 

  
  
  

    
🔎 Conflict Checks for Each Subpatch
    
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/<PATCH_ID>
    
✔ Prereq "checkConflictAgainstOHWithDetail" passed.
    
       
    
[grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37654975| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.

[grid@srv1 ~]$
[grid@srv1 ~]$

[grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37643161| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.


[grid@srv1 ~]$
[grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37762426| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.

[grid@srv1 ~]$
[grid@srv1 ~]$
[grid@srv1 ~]$
[grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/37642901| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.



[grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/37641958/36758186| grep checkConflictAgainstOHWithDetail
Prereq "checkConflictAgainstOHWithDetail" passed.


       
    
    
    
  

  

    
🛠️ Patch Apply Procedure
    
⚠️ Ensure current directory is NOT /root or /
    
cd /home/grid/37641958
$ORACLE_HOME/OPatch/opatchauto apply /home/grid/37641958 -oh $ORACLE_HOME
# ❌ Error: Incompatible OPatch version (23.x vs required 12.2.0.1.x)
    

    
✅ Fixed by Replacing OPatch:
    
unzip -qqd /u01/app/19.0.0/grid /home/grid/p6880880_190000_Linux-x86-64.zip
chown -R grid:oinstall OPatch


================
Download ..

unzip -qqd /u01/app/19.0.0/grid /home/grid/p6880880_190000_Linux-x86-64.zip
chown -R grid:oinstall OPatch


+ASM:/u01/app/19.0.0/grid:N             # line added by Agent
[root@srv1 grid]# . oraenv
ORACLE_SID = [root] ? +ASM
The Oracle base has been set to /u01/app/grid
[root@srv1 grid]# export PATH=$ORACLE_HOME/OPatch:$PATH
[root@srv1 grid]#
[root@srv1 grid]#
[root@srv1 grid]# echo $ORACLE_HOME

/u01/app/19.0.0/grid
[root@srv1 grid]# $ORACLE_HOME/OPatch/opatchauto apply /home/grid/37641958 -oh $ORACLE_HOME

OPatchauto session is initiated at Mon Jun 16 13:10:57 2025

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-06-16_01-11-06PM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-06-16_01-11-12PM.log
The id for this session is JATU

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_2025-06-16_01-13-40PM.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_2025-06-16_01-27-11PM.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/37641958/36758186
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-06-16_13-11-36PM_1.log
Reason: /home/grid/37641958/36758186 is not required to be applied to oracle home /u01/app/19.0.0/grid


==Following patches were SUCCESSFULLY applied:

Patch: /home/grid/37641958/37642901
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-06-16_13-14-37PM_1.log

Patch: /home/grid/37641958/37643161
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-06-16_13-14-37PM_1.log

Patch: /home/grid/37641958/37654975
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-06-16_13-14-37PM_1.log

Patch: /home/grid/37641958/37762426
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-06-16_13-14-37PM_1.log



OPatchauto session completed at Mon Jun 16 13:30:20 2025
Time taken to complete the session 19 minutes, 14 seconds


Time taken to complete the session 19 minutes, 14 seconds


After Patch space 

[root@srv1 grid]# df -Ph
Filesystem           Size  Used Avail Use% Mounted on
devtmpfs             3.8G     0  3.8G   0% /dev
tmpfs                3.8G  1.1G  2.7G  30% /dev/shm
tmpfs                3.8G  9.7M  3.8G   1% /run
tmpfs                3.8G     0  3.8G   0% /sys/fs/cgroup
/dev/mapper/ol-root   50G   39G   12G  77% /   --------------<<<<<< 
/dev/sda1           1014M  233M  782M  23% /boot
/dev/mapper/ol-home  339G  9.3G  330G   3% /home
tmpfs                771M   20K  771M   1% /run/user/54323
tmpfs                771M     0  771M   0% /run/user/0
[root@srv1 grid]#




    

    
✅ Successful Patch Output Summary
    
==Following patches were SKIPPED:
Patch: 36758186 - Not required

==Following patches were SUCCESSFULLY applied:
Patch: 37642901
Patch: 37643161
Patch: 37654975
Patch: 37762426

Total Time: 19 minutes, 14 seconds
    
  

  

    
📌 Post Patch Verification

    
Patch Inventory Check
    
opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"
Patch 37762426 applied at: Jun 16 13:26:01 GST 2025
Patch 37654975 applied at: Jun 16 13:25:36 GST 2025
Patch 37643161 applied at: Jun 16 13:24:49 GST 2025
Patch 37642901 applied at: Jun 16 13:19:57 GST 2025
    

    
SQL Version Check
    
sqlplus / as sysasm
SELECT * FROM v$version;
# Output: Version 19.27.0.0.0
    

    
Filesystem Usage After Patch
    
/dev/mapper/ol-root   50G   39G   12G  77% /
  

  

  

    
👨‍💻 Check Patch and Environment
    
. oraenv
ORACLE_SID = +ASM
export PATH=$ORACLE_HOME/OPatch:$PATH



[root@srv1 grid]# su - grid
Last login: Mon Jun 16 13:46:05 +04 2025 on pts/2



[grid@srv1 ~]$ cat /etc/oratab
#Backup file is  /u01/app/grid/crsdata/srv1/output/oratab.bak.srv1.grid line added by Agent
#



# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
oradb:/u01/app/oracle/product/19.0.0/db_1:N             # line added by Agent
doradb:/u01/app/oracle/product/19.0.0/db_1:N            # line added by Agent
+ASM:/u01/app/19.0.0/grid:N             # line added by Agent

[grid@srv1 ~]$ . oraenv

ORACLE_SID = [+ASM] ?
The Oracle base remains unchanged with value /u01/app/grid





[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 [2119256259] and the complete list of patches [36758186 37642901 37643161 37654975 37762426 ] have been applied on the local node. The release patch string is [19.27.0.0.0].
[grid@srv1 ~]$ crsctl query has softwarepatch


Oracle Clusterware patch level on node srv1 is [2119256259].


*******************************************************************************************



[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
ora.oradb.prodb_srvp.svc
      1        OFFLINE OFFLINE                               STABLE
--------------------------------------------------------------------------------
[grid@srv1 ~]$