Latest Posts
Deinstalling Oracle Grid Home in Oracle 23ai: Step-by-Step Guide
In Oracle 23ai, the procedure for deinstalling an Oracle Home or Grid Infrastructure Home has not changed compared to previous releases. The standard deinstall utility is still used, and the process remains straightforward. In this article, I will walk through the real procedure I followed to remove an Oracle Grid Home in Oracle 23ai and…
Out-of-Place GI Patching Using gridSetup.sh in Oracle 23ai / 26ai
Before performing Out-of-Place Grid Infrastructure (GI) patching, it is strongly recommended to read the following MOS document: Step by Step Out of Place Grid Infrastructure Patching Through gridSetup.sh in Silent Mode(Doc ID 2853839.1) Although this MOS document was written for GI 19.x, it is still largely applicable to Oracle 23ai / 26ai. However, the document…
Understanding Disk Rebuilds After Replacement in Exadata Compute Nodes
When a disk fails in an Exadata compute node, it should be replaced as soon as possible. Compute node disks are typically configured with RAID-5, which can tolerate only one disk failure. ⚠️ Important: RAID-5 does not create two copies of your data. It stores only one copy, with parity distributed across the other disks…
Partitioning in PostgreSQL vs Oracle
A customer who had migrated from Oracle to PostgreSQL several years ago recently reported a serious performance regression. A critical table—now holding over 700 million rows—had become extremely slow when filtering by date. As an DBA, I approached this from an Oracle perspective: partition pruning, local indexes. PostgreSQL partitioning is broadly similar to Oracle’s, but…
Something went wrong. Please refresh the page and/or try again.
Oracle DBA Insights 