How to apply the DBRU Patch_19.18 for Oracle Database 19C Grid Infrastructure on Standalone server
Posted by Mir Sayeed Hassan on May 7th, 2023
Apply the DBRU Patch_19.18 for Oracle Database 19C Grid Infrastructure on Standalone server
Check the status of Database
[oracle@stagdb2 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 1 16:53:37 2023 Version 19.17.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.17.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
After sucessfully apply the OPATCH on GRID & Database., Then start this process to apply the patch To Apply the Opatch at GRID & Database., Click on below link:
GRID OPATCH APPLY: DB OPTACH APPLY: https://mirsayeedhassan.com/apply-the-latest-opatch-12-2-0-1-37-for-oracle-database-19c/
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@stagdb2-std ~]$ cd /u01/source/PATCH_19_18/ [oracle@stagdb2-std PATCH_19_18]$ ls GRID_PATCH_19.18
[oracle@stagdb2-std PATCH_19_18]$ cd GRID_PATCH_19.18/ [oracle@stagdb2 DB_PATCH_19.18]$ ls p34765931_190000_Linux-x86-64.zip
Unzip GRID Patch
[oracle@stagdb2 DB_PATCH_19.18]$ unzip p34765931_190000_Linux-x86-64.zip
[oracle@stagdb2-std GRID_PATCH_19.18]$ ls 34762026 p34762026_190000_Linux-x86-64.zip PatchSearch.xml
[oracle@stagdb2-std GRID_PATCH_19.18]$ cd 34762026/
[oracle@stagdb2-std 34762026]$ ls 33575402 34765931 34768559 34768569 34863894 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@stagdb2 ~]$ srvctl status asm ASM is running on stagdb2
[oracle@stagdb2 ~]$ srvctl stop asm PRCR-1065 : Failed to stop resource ora.asm CRS-2974: unable to act on resource 'ora.asm' on server 'stagdb2' because that would require stopping or relocating resource 'ora.ARCH.dg' but the appropriate force flag was not specified
Note: The resolve the above error & stop the ASM., use the -f option into it.
[oracle@stagdb2 ~]$ srvctl stop asm -f [oracle@stagdb2 ~]$ srvctl status asm ASM is not running.
Therefore the ASM Instance is stop successfully.
Check the Pre-requisite before apply the patch
[oracle@stagdb2-std ~]$ cd /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/
[oracle@stagdb2-std 34762026]$ ls 33575402 34765931 34768559 34768569 34863894 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@stagdb2-std 33575402]$ /u01/app/19c/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.37 Copyright (c) 2023, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19c/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19c/db_1/oraInst.loc OPatch version : 12.2.0.1.37 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-05-01_22-28-39PM_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
[oracle@stagdb2-std ~]$ cd /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/
[oracle@stagdb2-std 34762026]$ ls 33575402 34765931 34768559 34768569 34863894 automation bundle.xml README.html README.txt
Here you need to apply the Individual SUB-PATCHES as shown below.
Apply 1st Sub-Patch
[root@stagdb2 34762026]# /u01/app/19c/grid/OPatch/opatchauto apply /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/33575402/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Tue May 2 01:08:26 2023 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2023-05-02_01-08-32AM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2023-05-02_01-08-40AM.log The id for this session is TN5Z 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/stagdb2/crsconfig/hapatch_2023-05-02_01-08-53AM.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 Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb2/crsconfig/hapatch_2023-05-02_01-09-26AM.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:stagdb2 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/33575402 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-02_01-09-12AM_1.log OPatchauto session completed at Tue May 2 01:09:47 2023 Time taken to complete the session 1 minute, 21 seconds
Apply 2nd Sub-Patch
[root@stagdb2 34762026]# /u01/app/19c/grid/OPatch/opatchauto apply /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/34765931/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Tue May 2 01:10:18 2023 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2023-05-02_01-10-29AM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2023-05-02_01-10-37AM.log 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/stagdb2/crsconfig/hapatch_2023-05-02_01-11-36AM.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 Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb2/crsconfig/hapatch_2023-05-02_01-18-55AM.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:stagdb2 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/34765931 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-02_01-12-00AM_1.log OPatchauto session completed at Tue May 2 01:19:15 2023 Time taken to complete the session 8 minutes, 47 seconds
Apply 3rd Sub-Patch
[root@stagdb2 34762026]# /u01/app/19c/grid/OPatch/opatchauto apply /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/34768559/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Tue May 2 01:20:08 2023 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2023-05-02_01-20-14AM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2023-05-02_01-20-21AM.log The id for this session is ZSI1 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/stagdb2/crsconfig/hapatch_2023-05-02_01-20-54AM.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 Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb2/crsconfig/hapatch_2023-05-02_01-22-18AM.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:stagdb2 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/34768559 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-02_01-21-11AM_1.log OPatchauto session completed at Tue May 2 01:22:36 2023 Time taken to complete the session 2 minutes, 28 seconds
Apply 4th Sub-Patch
[root@stagdb2 34762026]# /u01/app/19c/grid/OPatch/opatchauto apply /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/34768569/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Tue May 2 01:22:58 2023 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2023-05-02_01-23-04AM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2023-05-02_01-23-11AM.log The id for this session is 2K3Y 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/stagdb2/crsconfig/hapatch_2023-05-02_01-23-43AM.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 Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb2/crsconfig/hapatch_2023-05-02_01-24-49AM.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:stagdb2 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/34768569 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-02_01-24-00AM_1.log OPatchauto session completed at Tue May 2 01:26:05 2023 Time taken to complete the session 3 minutes, 7 seconds
Apply 5th Sub-Patch
[root@stagdb2 34762026]# /u01/app/19c/grid/OPatch/opatchauto apply /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/34863894/ -oh /u01/app/19c/grid/ OPatchauto session is initiated at Tue May 2 01:26:34 2023 System initialization log file is /u01/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2023-05-02_01-26-40AM.log. Session log file is /u01/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2023-05-02_01-26-46AM.log The id for this session is JS4S 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/stagdb2/crsconfig/hapatch_2023-05-02_01-27-18AM.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 Performing postpatch operations on CRS - starting CRS service on home /u01/app/19c/grid Postpatch operation log file location: /u01/app/oracle/crsdata/stagdb2/crsconfig/hapatch_2023-05-02_01-28-14AM.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:stagdb2 SIHA Home:/u01/app/19c/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/source/PATCH_19_18/GRID_PATCH_19.18/34762026/34863894 Log: /u01/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-05-02_01-27-35AM_1.log OPatchauto session completed at Tue May 2 01:29:35 2023 Time taken to complete the session 3 minutes, 2 seconds
Therefore., applied all the sub-patches successfully.
START THE ASM INSTANCE & VERIFY
Start the ASM Instance
[oracle@stagdb2 ~]$ srvctl start asm
Check the Status of ASM Instance
[oracle@stagdb2 ~]$ srvctl status asm ASM is running on stagdb2
Login to ASM Instance & Verify the ASM Disks
[oracle@stagdb2 ~]$ . oraenv ORACLE_SID = [pepdb] ? +ASM The Oracle base remains unchanged with value /u01/app/oracle
[oracle@stagdb2 ~]$ 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 153592 121640 0 121640 0 N ARCH/ MOUNTED EXTERN N 512 512 4096 4194304 2097144 1048900 0 1048900 0 N ORADATA/ MOUNTED EXTERN N 512 512 4096 4194304 10236 5860 0 5860 0 N REDO1/ MOUNTED EXTERN N 512 512 4096 4194304 10236 5860 0 5860 0 N REDO2/
Check the ASM Databas Instance
[oracle@stagdb2 ~]$ sqlplus / as sysasm SQL*Plus: Release 19.0.0.0.0 - Production on Thu May 4 12:17:17 2023 Version 19.18.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.18.0.0.0 SQL> select status from v$instance; STATUS ------------ STARTED
Verified the GRID Patch applied.
[oracle@stagdb2 ~]$ echo $ORACLE_HOME /u01/app/19c/grid
[oracle@stagdb2 ~]$ /u01/app/19c/grid/OPatch/opatch lspatches 34863894;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34863894) 34768569;ACFS RELEASE UPDATE 19.18.0.0.0 (34768569) 34768559;OCW RELEASE UPDATE 19.18.0.0.0 (34768559) 34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931) 33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402) OPatch succeeded.
Verify with LSINVENTORY
[oracle@stagdb2 ~]$ /u01/app/19c/grid/OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.37 Copyright (c) 2023, 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.37 OUI version : 12.2.0.7.0 Log file location : /u01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-02_01-32-50AM_1.log Lsinventory Output file location : /u01/app/19c/grid/cfgtoollogs/opatch/lsinv/lsinventory2023-05-02_01-32-50AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: stagdb2.pep.local 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 34863894 : applied on Tue May 02 01:28:05 IRST 2023 Unique Patch ID: 25031287 Patch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (34863894)" Created on 5 Dec 2022, 10:50:00 hrs PST8PDT Bugs fixed: 29286300, 30009095, 30729044, 30997459, 31657943, 32107716, 32248633 32625073, 33121445, 33655429, 33846688, 34300543, 34519419, 34816344 Patch 34768569 : applied on Tue May 02 01:24:38 IRST 2023 Unique Patch ID: 25046897 Patch description: "ACFS RELEASE UPDATE 19.18.0.0.0 (34768569)" Created on 19 Dec 2022, 00:41:48 hrs PST8PDT Bugs fixed: 14219141, 22162072, 27092156, 27494830, 27917085, 28064731, 28293236 28321248, 28375150, 28502013, 28531803, 28539108, 28553487, 28611527 28649123, 28687713, 28701011, 28740425, 28745877, 28818513, 28825772 28837603, 28844788, 28855761, 28860451, 28900212, 28951588, 28960047 Patch 33575402 : applied on Tue May 02 01:09:20 IRST 2023 Unique Patch ID: 24505881 Patch description: "DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)" Created on 16 Nov 2021, 09:32:52 hrs PST8PDT Bugs fixed: 30086914, 31547458, 31554751, 31862202, 32153618, 32435386, 33403356 --- --- --- OPatch succeeded.