Posted by Mir Sayeed Hassan on 1st November 2023
Apply the latest DB RU Patch_19.20 (35320081) 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 —————- —————————— testdb1 19.0.0.0.0 READ WRITE Verify the lastest OPatch… Read more..
Posted in DB Patch | Comments Off on Apply the latest DB RU Patch_19.20 (35320081) on Oracle Database 19C
Posted by Mir Sayeed Hassan on 31st October 2023
Apply the Latest OPatch (12.2.0.1.40) 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 ———————————————- testdb1 19.0.0.0.0 READ WRITE Check the last updated OPatch [oracle@test19cdb… Read more..
Posted in DB Patch | Comments Off on Apply the Latest OPatch (12.2.0.1.40) for Oracle Database 19c
Posted by Mir Sayeed Hassan on 19th July 2023
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..
Posted in DB Patch | Comments Off on Apply the latest DB RU Patch_19.19 (35042068) on Oracle Database 19C
Posted by Mir Sayeed Hassan on 6th December 2022
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..
Posted in DB Patch | Comments Off on Apply the Latest DB RU Patch 34419443 on Oracle Database 19c
Posted by Mir Sayeed Hassan on 6th December 2022
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..
Posted in DB Patch | Comments Off on Apply the Latest OPatch (12.2.0.1.34) Nov-2022 for Oracle Database 19c
Posted by Mir Sayeed Hassan on 2nd May 2022
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..
Posted in DB Patch | Comments Off on Find the Useful OPATCH Commands for Oracle Database