Dhiraj Kumar's Blog

Category: oracle

  • ASM Instance Termination After OCR Restore 19c/26ai

    After a storage migration activity, a two-node Oracle RAC environment experienced Oracle Cluster Registry (OCR) corruption. Although OCR was restored successfully on a newly provisioned disk, ASM instances repeatedly terminated with internal errors. Further investigation revealed that the issue was not related to Oracle software or OCR restore procedures, but to an underlying disk visibility…

  • Oracle Database 26ai – An AI-First Database Platform

    Oracle Database 26ai represents Oracle’s next-generation, AI-first database, where artificial intelligence capabilities are natively embedded into the database engine rather than delivered as external or bolt-on services. This is not just another version of the Oracle Database—it is better described as a learning and enablement platform for AI. Oracle Database 26ai is specifically designed for:…

  • Oracle Database Appliance (ODA) 19.29 Patching: Understanding the Two-Stage Patching Process

    Oracle Database Appliance (ODA) patching is a critical operational activity to ensure system stability, security, performance, and long-term supportability. With ODA 19.29, Oracle follows a two-stage patching procedure. In this article, we will walk through the two major stages of ODA 19.29 patching and provide the required commands. Why ODA Patching Is Divided into Two…

  • Oracle Grid Infrastructure (GI) 19c Installation and RU Patch 19.28

    Note:Please follow the steps below carefully.You can skip any step if it’s already completed in your environment.Modify paths and variables as per your setup. 1. Delete Existing Oracle Files and Directories Before starting a clean installation, remove any previous Oracle GI installation traces. 2. Create GI Software and Base Directories Create the necessary directories for…

  • Simplifying Oracle Database Appliance Configuration with odaconfigcli

    With the release of Oracle Database Appliance (ODA) software 19.26, Oracle introduced a brand-new utility: odaconfigcli. This tool is designed to make configuration collection and troubleshooting easier for administrators managing ODA deployments. What is odaconfigcli? Traditionally, ODA admins had to rely on a mix of logs, manual commands, and odacli outputs to capture system details…

  • Fixing High %IRQ and Disk Utilization in Oracle RAC Labs: Why I Moved from Windows 11 to Linux

    Introduction When I built my new desktop for Oracle RAC practice, I expected smooth sailing. Instead, I ran into persistent issues: high %irq, high %system CPU, and 100% disk utilization whenever I ran my RAC lab inside Oracle VirtualBox on Windows 11. Even simple RAC test workloads caused the VM guests to lag. Tools like…

  • Integrating SNMP with Oracle Direct NFS (dNFS): Why SNMPv3 Is Not Supported

    Oracle Direct NFS (dNFS) is widely used for high-performance NFS I/O between Oracle databases and storage systems. When using Hybrid Columnar Compression (HCC) with dNFS on Oracle ZFS Storage Appliance (ZFSSA) or similar devices, Oracle relies on SNMP queries to validate that the storage system supports the required features. As organizations move toward stricter security…