Search This Blog

Total Pageviews

Saturday, 26 October 2024

Patch 36582629 - GI Release Update 19.24.0.0.240716


How to Patch Oracle Grid Infrastructure 19c ?





Patch 36582629 - GI Release Update 19.24.0.0.240716

As the Grid home user: [grid@srv1 ~]$ unzip p36582629_190000_Linux-x86-64.zip inflating: 36582629/automation/bp1-rollback-inplace-automation.xml inflating: 36582629/automation/bp1-rollback-inplace-non-rolling-automation.xml inflating: 36582629/automation/messages.properties inflating: 36582629/README.txt inflating: 36582629/README.html inflating: 36582629/bundle.xml /home/grid/36582629/36587798 [grid@srv1 ~]$ echo $ORACLE_HOME /u01/app/19.0.0/grid [grid@srv1 ~]$ [grid@srv1 ~]$ export ORACLE_HOME=/u01/app/19.0.0/grid [grid@srv1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36582781 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36587798 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36590554 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36648174 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36758186 [grid@srv1 ~]$ echo $ORACLE_HOME /u01/app/19.0.0/grid [grid@srv1 ~]$ export ORACLE_HOME=/u01/app/19.0.0/grid export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch grid@srv1 ~]$ ls -ld */ drwxr-x---. 8 grid oinstall 4096 Jul 13 23:20 36582629/ export ORACLE_HOME=/u01/app/19.0.0/grid export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch [grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36582781 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-26_21-22-05PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36587798 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-26_21-25-05PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36590554 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-26_21-25-57PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/36648174 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-26_21-26-17PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/36582629/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-26_21-26-48PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/34762026/34768569 | grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/34762026/34765931 | grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/34762026/33575402 | grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/34762026/34863894 | grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/34762026/34768559 | grep checkConflictAgainstOHWithDetail
$ORACLE_HOME/OPatch/opatch lsinventory|grep -i 19
Oracle Home       : /u01/app/19.0.0/grid
   from           : /u01/app/19.0.0/grid/oraInst.loc
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-26_21-39-12PM_1.log
Lsinventory Output file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2024-10-26_21-39-12PM.txt
Oracle Grid Infrastructure 19c                                       19.0.0.0.0
Patch description:  "TOMCAT RELEASE UPDATE 19.0.0.0.0 (34863894)"
     32625073, 33121445, 33655429, 33846688, 34300543, 34519419, 34816344
Patch description:  "ACFS RELEASE UPDATE 19.18.0.0.0 (34768569)"
   Created on 19 Dec 2022, 00:41:48 hrs PST8PDT





[grid@srv1 ~]$ which opatchauto
/u01/app/19.0.0/grid/OPatch/opatchauto


To patch only the Grid home:

# opatchauto apply /home/grid/36582629 -oh /u01/app/19.0.0/grid




***********  as root !!!

export ORACLE_HOME=/u01/app/19.0.0/grid
export PATH=$ORACLE_HOME/OPatch:$PATH
echo $ORACLE_HOME
/u01/app/19.0.0/grid


[grid@srv1 ~]$ su -
Password:

[root@srv1 ~]# export ORACLE_HOME=/u01/app/19.0.0/grid
[root@srv1 ~]# export PATH=$ORACLE_HOME/OPatch:$PATH




$ORACLE_HOME/OPatch/opatchauto -help

Invalid current directory.  Please run opatchauto from other than '/root' or '/' directory.
And check if the home owner user has write permission set for the current directory.
opatchauto returns with error code = 2   <<<<

change the dir 

[root@srv1 ~]# cd /home/grid

$ORACLE_HOME/OPatch/opatchauto apply /home/grid/36582629 -oh $ORACLE_HOME



[root@srv1 ~]# cd /home/grid
[root@srv1 grid]#
[root@srv1 grid]# $ORACLE_HOME/OPatch/opatchauto apply /home/grid/36582629 -oh $ORACLE_HOME

OPatchauto session is initiated at Sat Oct 26 21:47:11 2024

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2024-10-26_09-47-21PM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2024-10-26_09-47-26PM.log
The id for this session is 8TYG

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-26_09-49-47PM.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-26_10-03-06PM.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 SUCCESSFULLY applied:

Patch: /home/grid/36582629/36582781
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-26_21-50-44PM_1.log

Patch: /home/grid/36582629/36587798
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-26_21-50-44PM_1.log

Patch: /home/grid/36582629/36590554
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-26_21-50-44PM_1.log

Patch: /home/grid/36582629/36648174
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-26_21-50-44PM_1.log

Patch: /home/grid/36582629/36758186
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-10-26_21-50-44PM_1.log



OPatchauto session completed at Sat Oct 26 22:04:57 2024
Time taken to complete the session 17 minutes, 36 seconds
[root@srv1 grid]#
[root@srv1 grid]#
[root@srv1 grid]#
[root@srv1 grid]#
[root@srv1 grid]#

[grid@srv1 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[grid@srv1 ~]$ opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"
Patch  36758186     : applied on Sat Oct 26 22:02:01 GST 2024
Patch  36648174     : applied on Sat Oct 26 22:01:48 GST 2024
Patch  36590554     : applied on Sat Oct 26 22:01:05 GST 2024
Patch  36587798     : applied on Sat Oct 26 22:00:17 GST 2024
Patch  36582781     : applied on Sat Oct 26 21:55:32 GST 2024
[grid@srv1 ~]$




$ORACLE_HOME/OPatch/opatch lsinventory|grep -i 19.18



$ORACLE_HOME/OPatch/opatch lsinventory|grep -i 19.
Oracle Home       : /u01/app/19.0.0/grid
   from           : /u01/app/19.0.0/grid/oraInst.loc
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2024-10-26_22-11-32PM_1.log
Lsinventory Output file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2024-10-26_22-11-32PM.txt
Oracle Grid Infrastructure 19c                                       19.0.0.0.0
Patch description:  "DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)"
Patch description:  "TOMCAT RELEASE UPDATE 19.0.0.0.0 (36648174)"
     32625073, 33121445, 33655429, 33846688, 34300543, 34519419, 34816344
Patch description:  "ACFS RELEASE UPDATE 19.24.0.0.0 (36590554)"


$ORACLE_HOME/OPatch/opatch lsinventory|grep -i "Patch description"



[grid@srv1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory|grep -i "Patch description"
Patch description:  "DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)"
Patch description:  "TOMCAT RELEASE UPDATE 19.0.0.0.0 (36648174)"
Patch description:  "ACFS RELEASE UPDATE 19.24.0.0.0 (36590554)"
Patch description:  "OCW RELEASE UPDATE 19.24.0.0.0 (36587798)"
Patch description:  "Database Release Update : 19.24.0.0.240716 (36582781)"
[grid@srv1 ~]$



[grid@srv1 ~]$ opatch lspatches
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)
36648174;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36648174)
36590554;ACFS RELEASE UPDATE 19.24.0.0.0 (36590554)
36587798;OCW RELEASE UPDATE 19.24.0.0.0 (36587798)
36582781;Database Release Update : 19.24.0.0.240716 (36582781)

OPatch succeeded.

crsctl query has releaseversion
    Lists the Oracle Clusterware release version

  crsctl query has softwareversion
    Lists the version of Oracle Clusterware software installed on the local node

  crsctl query has releasepatch
     Lists the Oracle Clusterware release patch level

  crsctl query has softwarepatch
     Lists the patch level of Oracle Clusterware software installed on the local host



crsctl query has releaseversion
crsctl query has softwareversion
crsctl query has releasepatch
crsctl query has softwarepatch


[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 [3669234883] and the complete list of patches [36582781 36587798 36590554 36648174 36758186 ] have been applied on the local node. The release patch string is [19.24.0.0.0].

[grid@srv1 ~]$ crsctl query has softwarepatch
Oracle Clusterware patch level on node srv1 is [3669234883].



[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
--------------------------------------------------------------------------------



 crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'srv1'
CRS-2673: Attempting to stop 'ora.OCRDISK.dg' on 'srv1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'srv1'
CRS-2677: Stop of 'ora.OCRDISK.dg' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.DATADISK.dg' on 'srv1'
CRS-2677: Stop of 'ora.DATADISK.dg' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'srv1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'srv1' succeeded
CRS-2677: Stop of 'ora.asm' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'srv1'
CRS-2677: Stop of 'ora.evmd' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'srv1'
CRS-2677: Stop of 'ora.cssd' on 'srv1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'srv1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[grid@srv1 ~]$







Oracle DBA

anuj blog Archive