Manual GI/DB Patching on Oracle Restart- 19.3 to 19.18 adminkahaniya Patching April 18, 2023 Pre- Requisites: Backup the GI Home and DB Home. Backup OLR file. Backup OraInventory. Backup the Database. Download and install the lastest Opatch utility +++Query the existing patches+++ As Oracle DB home owner: ======================== [oracle@testdb OPatch]$ opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) OPatch succeeded. [oracle@testdb OPatch]$   As GI home owner: ================= [grid@testdb OPatch]$ opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) 29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763) OPatch succeeded. [grid@testdb OPatch]$ +++Check the existing version of GI+++ [grid@testdb ~]$ crsctl query has releaseversion Oracle High Availability Services release version on the local node is [19.0.0.0.0]   [grid@testdb ~]$ crsctl query has softwareversion Oracle High Availability Services version on the local node is [19.0.0.0.0]   [grid@testdb ~]$ crsctl query has releasepatch Oracle Clusterware release patch level is [724960844] and the complete list of patches [29401763 29517242 29517247 29585399 ] have been applied on the local node. The release patch string is [19.3.0.0.0].   [grid@testdb ~]$ crsctl query has softwarepatch Oracle Clusterware patch level on node testdb is [724960844]. +++Check the existing version of DB and Patch details+++ SQL> set linesize 300 col VERSION for a10 col ACTION for a20 col NAMESPACE for a15 col COMMENTS for a47 col ACTION_TIME for a30 select ACTION_TIME, ACTION, NAMESPACE,VERSION,COMMENTS from dba_registry_history;   ACTION_TIME                    ACTION               NAMESPACE       VERSION    COMMENTS —————————— ——————– ————— ———- ———————————————–                                BOOTSTRAP            DATAPATCH       19         RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417 17-03-23 8:33:27.624362 PM     RU_APPLY             SERVER          19.0.0.0.0 Patch applied on 19.3.0.0.0: Release_Update – 1                                                                                90410122720 SQL> set linesize 300 col status for a10 col ACTION for a10 col ACTION_TIME for a30 col DESCRIPTION for a30 select PATCH_ID,PATCH_TYPE,ACTION,ACTION_TIME,SOURCE_VERSION, TARGET_VERSION,STATUS,description from dba_registry_sqlpatch order by ACTION_TIME;     PATCH_ID PATCH_TYPE ACTION     ACTION_TIME                    SOURCE_VERSION  TARGET_VERSION  STATUS     DESCRIPTION ———- ———- ———- —————————— ————— ————— ———- ——————————   29517242 RU         APPLY      17-03-23 8:33:41.098816 PM     19.1.0.0.0      19.3.0.0.0      SUCCESS    Database Release Update : 19.3                                                                                                            .0.0.190416 (29517242) +++Check the existing version of DB and Patch details+++ Unzip GI and DB Patches at respective locations. GI Patch location:  /patch/patch_GI_19.18 DB Patch location:  /patch/patch_DB_19.18 +++Check the consistency of inventory information for GI home and each database home +++ As Oracle User: ================ [oracle@testdb ~]$  /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/19.0.0/db_1/ Oracle Interim Patch Installer version 12.2.0.1.36 Copyright (c) 2023, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/app/oracle/product/19.0.0/db_1 Central Inventory : /u01/app/oraInventory    from           : /u01/app/oracle/product/19.0.0/db_1//oraInst.loc OPatch version    : 12.2.0.1.36 OUI version       : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_19-01-47PM_1.log Lsinventory Output file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2023-03-20_19-01-47PM.txt ——————————————————————————– Local Machine Information:: Hostname: testdb ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 19c                                                  19.0.0.0.0 There are 1 products installed in this Oracle Home. Installed Products (128): Assistant Common Files                                               19.0.0.0.0 BLASLAPACK Component                                                 19.0.0.0.0 Buildtools Common Files                                              19.0.0.0.0 Cluster Verification Utility Common Files                            19.0.0.0.0 Cluster Verification Utility DB Files                                19.0.0.0.0 Database Configuration and Upgrade Assistants                        19.0.0.0.0 Database Migration Assistant for Unicode                             19.0.0.0.0 Database SQL Scripts                                                 19.0.0.0.0 Database Workspace Manager                                           19.0.0.0.0 DB TOOLS Listener                                                    19.0.0.0.0 Deinstallation Tool                                                  19.0.0.0.0 Enterprise Edition Options                                           19.0.0.0.0 Expat libraries                                                       2.0.1.0.4 Generic Connectivity Common Files                                    19.0.0.0.0 Hadoopcore Component                                                 19.0.0.0.0 HAS Common Files                                                     19.0.0.0.0 HAS Files for DB                                                     19.0.0.0.0 Installation Common Files