Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233126) On Grid Infrastructure Standalone Server
Posted by Mir Sayeed Hassan on May 29th, 2024
Apply Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233126) On Grid Infrastructure Standalone Server.
Check the status of Database
[oracle@stagdb1 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 15 01:11:01 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.22.0.0.0 SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE ---------------- --------------------------- DBSTAGE 19.0.0.0.0 READ WRITE
Prior to this apply the OPATCH on GRID
To Apply the Opatch at GRID & Database., Click on below link:
GRID OPATCH APPLY:
Download the Patch from below link https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=ym4c1dobw_120&_afrLoop=189225645173189
Create a directory & place the downloaded Patch into it.
[oracle@stagdb1 ~]$ cd /u02/source/PATCH_19C_19.23/
[oracle@stagdb1 PATCH_19C_19.23]$ ls GI_RU_19.23.0.0.0_16-APR-2024
[oracle@stagdb1 PATCH_19C_19.23]$ cd GI_RU_19.23.0.0.0_16-APR-2024
[oracle@stagdb1 GI_RU_19.23.0.0.0_16-APR-2024]$ ls p36233126_190000_Linux-x86-64.zip
Unzip GRID Patch
[oracle@stagdb1 GI_RU_19.23.0.0.0_16-APR-2024]$ unzip p36233126_190000_Linux-x86-64.zip
[oracle@pepdbsstd GI_RU_19.23.0.0.0_16-APR-2024]$ ls 36233126 p36233126_190000_Linux-x86-64.zip PatchSearch.xml
[oracle@stagdb1 GI_RU_19.23.0.0.0_16-APR-2024]$ cd 36233126/
[oracle@stagdb1 35940989]$ ls 36233263 36233343 36240578 36383196 36460248 automation bundle.xml README.html README.txt
Note: Here you can see the sub-multiple are exist., You need to apply for each & every patch set as shown below:
To Apply the GRID Patch you need to shutdown the ASM Instance
Stop the ASM Instance
[oracle@stagdb1 ~]$ srvctl status asm ASM is running on stagdb1
[oracle@stagdb1 ~]$ srvctl stop asm PRCR-1065 : Failed to stop resource ora.asm CRS-2974: unable to act on resource 'ora.asm' on server 'stagdb1' because that would require stopping or relocating resource 'ora.stagdb1.db' but the appropriate force flag was not specified
Note: The resolve the above error & stop the ASM forcefully., use the -f option into it.
[oracle@stagdb1 ~]$ srvctl stop asm -f
[oracle@stagdb1 ~]$ srvctl status asm ASM is not running.
Therefore the ASM Instance is stop successfully.
Check teh Pre-requisite before apply the patch
[oracle@stagdb1 ~]$ cd /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126
[oracle@stagdb1 35940989]$ ls 36233263 36233343 36240578 36383196 36460248 automation bundle.xml README.html README.txt
Note: You need to check the Pre-requiste for all the individual sub-patches as below above.
[oracle@stagdb1 36233263]$ /u01/app/19c/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.42 Copyright (c) 2024, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19c/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19c/grid/oraInst.loc OPatch version : 12.2.0.1.42 OUI version : 12.2.0.7.0 Log file location : /u01/app/19c/grid/cfgtoollogs/opatch/opatch2024-05-27_11-29-18AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
Note: I have checked for all., all the pre-requites are OPatch Succeeded.
Start Applying the Patch on GRID Infrastructure for all the sub patches individual.
[oracle@stagdb1 ~]$ cd /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/
[oracle@stagdb1 35940989]$ ls 36233263 36233343 36240578 36383196 36460248 automation bundle.xml README.html README.txt
Here you need to apply the Individual SUB-PATCHES as shown below.
Note: In case if you get the below error while applying the sub patches., Use the below method to resolve and re-run the patch.
ERROR: fuser not found error
Solution [oracle@peptestdb db_1]$ touch fuser [root@peptestdb 35940989]# export OPATCH_NO_FUSER=true [root@peptestdb 35940989]# /u01/app/19c/grid/OPatch/opatchauto apply /u02/source/PATCH_19C_19.22/GI_RU_19.22.0.0.0_06-JAN-2024/35940989/33575402/ -oh /u01/app/19c/grid/
Successfully executed.
If this error occur : 2024/05/26 18:30:44 CLSRSC-180: An error occurred while executing the command ‘pstree -sp 58410 |’
Solution: install the below RPM Package as per recomendation. & Re-run.
[root@peptestdb ~]# yum install psmisc -y
Apply 1st Sub-Patch
[root@stagdb1 36233126]# /u01/app/19c/grid/OPatch/opatchauto apply /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36233263/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Mon May 27 12:36:09 2024 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2024-05-27_11-36-18AM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2024-05-27_11-36-23AM.log The id for this session is 6EAA Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid Patch applicability verified successfully on home /u01/app/19c/grid Executing patch validation checks on home /u01/app/19c/grid Patch validation checks successfully completed on home /u01/app/19c/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19c/grid Prepatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_12-38-16AM.log CRS service brought down successfully on home /u01/app/19c/grid Start applying binary patch on home /u01/app/19c/grid Binary patch applied successfully on home /u01/app/19c/grid Running rootadd_rdbms.sh on home /u01/app/19c/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19c/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_12-49-29AM.log CRS service started successfully on home /u01/app/19c/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:stagdb1 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36233263 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-05-27_11-38-40AM_1.log OPatchauto session completed at Mon May 27 12:51:39 2024 Time taken to complete the session 15 minutes, 21 seconds
Apply 2nd Sub-Patch
[root@stagdb1 35940989]# /u01/app/19c/grid/OPatch/opatchauto apply /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36233343/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Mon May 27 12:53:08 2024 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2024-05-27_11-53-17AM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2024-05-27_11-53-21AM.log The id for this session is ACKU Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid Patch applicability verified successfully on home /u01/app/19c/grid Executing patch validation checks on home /u01/app/19c/grid Patch validation checks successfully completed on home /u01/app/19c/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19c/grid Prepatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_12-55-34AM.log CRS service brought down successfully on home /u01/app/19c/grid Start applying binary patch on home /u01/app/19c/grid Binary patch applied successfully on home /u01/app/19c/grid Running rootadd_rdbms.sh on home /u01/app/19c/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19c/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_01-00-04PM.log CRS service started successfully on home /u01/app/19c/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:stagdb1 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36233343 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-05-27_11-56-37AM_1.log OPatchauto session completed at Mon May 27 13:02:05 2024 Time taken to complete the session 8 minutes, 58 seconds
Apply 3rd Sub-Patch
[root@stagdb1 35940989]# /u01/app/19c/grid/OPatch/opatchauto apply /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36240578/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Mon May 27 13:03:08 2024 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2024-05-27_12-03-14PM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2024-05-27_12-03-20PM.log The id for this session is LWJ9 Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid Patch applicability verified successfully on home /u01/app/19c/grid Executing patch validation checks on home /u01/app/19c/grid Patch validation checks successfully completed on home /u01/app/19c/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19c/grid Prepatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_01-05-33PM.log CRS service brought down successfully on home /u01/app/19c/grid Start applying binary patch on home /u01/app/19c/grid Binary patch applied successfully on home /u01/app/19c/grid Running rootadd_rdbms.sh on home /u01/app/19c/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19c/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_01-09-41PM.log CRS service started successfully on home /u01/app/19c/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:stagdb1 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36240578 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-05-27_12-06-40PM_1.log OPatchauto session completed at Mon May 27 13:11:51 2024 Time taken to complete the session 8 minutes, 44 seconds
Apply 4th Sub-Patch
[root@stagdb1 35940989]# /u01/app/19c/grid/OPatch/opatchauto apply /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36383196/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Mon May 27 13:13:02 2024 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2024-05-27_12-13-15PM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2024-05-27_12-13-21PM.log The id for this session is PQ68 Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid Patch applicability verified successfully on home /u01/app/19c/grid Executing patch validation checks on home /u01/app/19c/grid Patch validation checks successfully completed on home /u01/app/19c/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19c/grid Prepatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_01-15-43PM.log CRS service brought down successfully on home /u01/app/19c/grid Start applying binary patch on home /u01/app/19c/grid Binary patch applied successfully on home /u01/app/19c/grid Running rootadd_rdbms.sh on home /u01/app/19c/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19c/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_01-19-22PM.log CRS service started successfully on home /u01/app/19c/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:stagdb1 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36383196 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-05-27_12-16-50PM_1.log OPatchauto session completed at Mon May 27 13:21:23 2024 Time taken to complete the session 8 minutes, 22 seconds
Apply 5th Sub-Patch
[root@stagdb1 35940989]# /u01/app/19c/grid/OPatch/opatchauto apply /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36460248/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Mon May 27 13:24:07 2024 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2024-05-27_12-24-17PM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2024-05-27_12-24-26PM.log The id for this session is YHXZ Executing OPatch prereq operations to verify patch applicability on home /u01/app/19c/grid Patch applicability verified successfully on home /u01/app/19c/grid Executing patch validation checks on home /u01/app/19c/grid Patch validation checks successfully completed on home /u01/app/19c/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19c/grid Prepatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_01-26-39PM.log CRS service brought down successfully on home /u01/app/19c/grid Start applying binary patch on home /u01/app/19c/grid Binary patch applied successfully on home /u01/app/19c/grid Running rootadd_rdbms.sh on home /u01/app/19c/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19c/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb1/crsconfig/hapatch_2024-05-27_01-30-06PM.log CRS service started successfully on home /u01/app/19c/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:stagdb1 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u02/source/PATCH_19C_19.23/GI_RU_19.23.0.0.0_16-APR-2024/36233126/36460248 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-05-27_12-27-36PM_1.log OPatchauto session completed at Mon May 27 13:32:05 2024 Time taken to complete the session 7 minutes, 59 seconds
Therefore., applied all the sub-patches successfully.
START THE ASM INSTANCE & VERIFY
Start the ASM Instance
[oracle@stagdb1 ~]$ srvctl start asm
Check the Status of ASM Instance
[oracle@stagdb1 ~]$ srvctl status asm ASM is running on stagdb1
Login to ASM Instance & Verify the ASM Disks
[oracle@stagdb1 ~]$ . oraenv ORACLE_SID = [stagdb1] ? +ASM The Oracle base remains unchanged with value /u01/app/oracle
[oracle@stagdb1 ~]$ asmcmd
ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 512 4096 4194304 102396 83784 0 83784 0 N ORADATA/
Check the ASM Databas Instance
[oracle@stagdb1 ~]$ sqlplus / as sysasm SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 27 13:36:57 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 SQL> select status from v$instance; STATUS ------------ STARTED
Verified the GRID Patch applied.
[oracle@stagdb1 ~]$ echo $GRID_HOME /u01/app/19c/grid
[oracle@stagdb1 ~]$ cd $GRID_HOME/OPatch
Check the applied list of patches
[oracle@stagdb1 OPatch]$ ./opatch lspatches 36460248;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36460248) 36383196;DBWLM RELEASE UPDATE 19.0.0.0.0 (36383196) 36240578;OCW RELEASE UPDATE 19.23.0.0.0 (36240578) 36233343;ACFS RELEASE UPDATE 19.23.0.0.0 (36233343) 36233263;Database Release Update : 19.23.0.0.240416 (36233263) OPatch succeeded.
Verify with LSINVENTORY
[oracle@stagdb1 OPatch]$ ./opatch lsinventory [oracle@stagdb1 OPatch]$ ./opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.42 Copyright (c) 2024, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/19c/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19c/grid/oraInst.loc OPatch version : 12.2.0.1.42 OUI version : 12.2.0.7.0 Log file location : /u01/app/19c/grid/cfgtoollogs/opatch/opatch2024-05-27_12-39-09PM_1.log Lsinventory Output file location : /u01/app/19c/grid/cfgtoollogs/opatch/lsinv/lsinventory2024-05-27_12-39-09PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: stagdb1 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Grid Infrastructure 19c 19.0.0.0.0 There are 1 products installed in this Oracle Home. Interim patches (5) : Patch 36460248 : applied on Mon May 27 12:29:52 IRST 2024 Unique Patch ID: 25623983 Patch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (36460248)" Created on 29 Mar 2024, 14:15:01 hrs PST8PDT Bugs fixed: 29286300, 30009095, 30729044, 30997459, 31657943, 32107716, 32248633 32625073, 33121445, 33655429, 33846688, 34300543, 34519419, 34816344 34970057, 35229376, 35538576, 35779899, 35926707, 36066696, 36440449 Patch 36383196 : applied on Mon May 27 12:19:07 IRST 2024 Unique Patch ID: 25597177 Patch description: "DBWLM RELEASE UPDATE 19.0.0.0.0 (36383196)" Created on 8 Mar 2024, 05:51:56 hrs PST8PDT Bugs fixed: 30086914, 31547458, 31554751, 31862202, 32153618, 32435386, 33403356 35096482 Patch 36240578 : applied on Mon May 27 12:09:15 IRST 2024 Unique Patch ID: 25625545 Patch description: "OCW RELEASE UPDATE 19.23.0.0.0 (36240578)" Created on 1 Apr 2024, 03:00:31 hrs PST8PDT Bugs fixed: 13742922, 17787434, 23320062, 24611963, 24677421, 24943214, 25642320 ------------------------------------------------------------------------------- OPatch succeeded.