Apply the latest DB RU Patch_19.19 (35042068) on Oracle Database 19C Check the status of Database SQL> select instance_name, version, open_mode from v$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- —————– ——————– oemswdb 19.0.0.0.0 READ WRITE Verify the lastest… Read more..

Apply the Latest DB RU Patch 34419443 onOracle Database 19c Check the status of Database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE ——————————————— proddb 19.0.0.0.0 READ WRITE Download the Patch from below link https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=ym4c1dobw_120&_afrLoop=189225645173189 Transfer… Read more..

Apply the Latest OPatch (12.2.0.1.34) Nov-2022 for Oracle Database 19c Check the status of Database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- ————– oemswdb 19.0.0.0.0 READ WRITE Check the last updated OPatch [oracle@PROD-DB ~]$ $ORACLE_HOME/OPatch/opatch… Read more..

Find the Useful OPATCH Commands for Oracle Database List inventory details of patch. [oracle@miroradb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc OPatch… Read more..

How to apply the Oracle PATCH’S AT OS & Database Level The below patch are applied to one of our production database, due to the wrong result at standby level compare to primary database. Download the OPatch (OS LEVEL) p6880880_112000_Linux-x86-64.zip Download the patch to be applied (DB LEVEL)