Dhiraj Kumar's Blog

Category: oracle

  • 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…

  • ACFS Replication Based On Tagging

    ACFS tagging plays a crucial role in optimizing ACFS replication. Instead of duplicating an entire mount point tagging allows administrators to selectively replicate only specific files or directories. During the initial replication setup on the primary system, tags can be assigned to define the scope of data to be replicated. These tags can also be…

  • Oracle GoldenGate Microservices Failing to Start via XAG

    A few days back, I set up Oracle GoldenGate Microservices on: This database is vital for real-time data synchronization, and Oracle GoldenGate is the preferred solution for such requirements. It’s a very popular product nowadays for data replication and synchronization across environments. Personally, I appreciate and highly value Oracle GoldenGate for its robustness and capabilities…