Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Archive for the 'DB Patch' Category

Apply Patching Oracle Database 19C release Update on OCT 2024 19.25 (p36916690) On Grid Infrastructure Standalone Server.

Posted by Mir Sayeed Hassan on 12th February 2025

Apply Patching Oracle Database 19C release Update on OCT 2024 19.25 (p36916690) On Grid Infrastructure Standalone Server. Check the status of Database [oracle@Paymentdb ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Tue Feb 12 14:27:08 2025 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected… Read more..

Posted in DB Patch | No Comments »

APPLY THE LATEST OPTACH 6880880 (12.2.0.1.45) on Grid Infrastructure 19C DATABASE

Posted by Mir Sayeed Hassan on 11th February 2025

APPLY THE LATEST OPTACH 6880880 (12.2.0.1.45) ON Grid Infrastructure 19C DATABASE Check the status of database SQL> select instance_name, version, open_mode from v$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————————————— ora19ctdb1 19.0.0.0.0 READ WRITE Check existing OPatch applied. [oracle@payment-dbs… Read more..

Posted in DB Patch | No Comments »

Apply the Latest DB RU Patch_19.25 36912597 for Oracle Database 19C

Posted by Mir Sayeed Hassan on 4th February 2025

Apply the Latest DB RU Patch_19.25 36912597 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 —————- ———————————— ora19cdb 19.0.0.0.0 READ WRITE SQL> show pdbs CON_ID… Read more..

Posted in DB Patch | Comments Off on Apply the Latest DB RU Patch_19.25 36912597 for Oracle Database 19C

Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233126) On Grid Infrastructure Standalone Server

Posted by Mir Sayeed Hassan on 29th May 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… Read more..

Posted in DB Patch | Comments Off on Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233126) On Grid Infrastructure Standalone Server

Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database

Posted by Mir Sayeed Hassan on 29th May 2024

Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database Check the status of Database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- ———————— peptestdb 19.0.0.0.0 READ WRITE Verify… Read more..

Posted in DB Patch | Comments Off on Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database

Patching Oracle Database 19C Grid Infrastructure on Standalone server for Patch_19.22 (p35940989)

Posted by Mir Sayeed Hassan on 19th May 2024

Patching Oracle Database 19C Grid Infrastructure on Standalone server for Patch_19.22 (p35940989) Check the status of Database [oracle@stagdb1 ~]$ sqlplus / as sysdba SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE —————- ————————— DBSTAGE … Read more..

Posted in DB Patch | Comments Off on Patching Oracle Database 19C Grid Infrastructure on Standalone server for Patch_19.22 (p35940989)