Dhiraj Kumar's Blog

Category: oracle

  • Storage AFD:UNMAP Protocol With ASM Disk

    In Oracle storage environments using ASM (Automatic Storage Management) with AFD (ASM Filter Driver), the UNMAP protocol plays a key role in space reclamation—especially when you’re using thin-provisioned storage such as SSDs or SAN systems that support SCSI UNMAP or NVMe deallocation. What is the UNMAP Protocol? The UNMAP protocol is a SCSI command (or…

  • Installing ASM Library Version 3.1 (ASMLib V 3.1) for Oracle 19c on Linux 8.3 or later in aarch64

    ASM Library (ASMLib) is a support library for the Oracle Automatic Storage Management (ASM) feature. It simplifies storage management and enhances Oracle ASM functionality. Prerequisites Required Packages In this demonstration, I installed the ASMlib V3 package on Oracle Linux 8.9 with the aarch64 architecture. Therefore, you need to download the package that matches your Linux…

  • Getting ORA-02097 and ORA-15014 On Setting asmcmd dsset ‘AFD:*’ In Oracle RAC

    I was attempting to migrate Oracle ASM UDEV-managed disks to Oracle ASM Filter Driver (AFD). Although I followed all the documented steps for migrating the disks, I encountered the following error when trying to set the disk strings: This error occurred specifically during the step where I attempted to configure the ASM disk discovery string.…

  • OPatchAuto Bootstrapping Failure with Error Code 255 and Resource Temporarily Unavailable

    OPatchAuto execution fails during the bootstrap phase with error code 255.The failure prevents successful patching operations. Symptom Getting issue while running the Opatchauto on my Oracle Restart Envioment: Cause Based on the analysis, it came to know that on my system bash ,zip package was not installed Also perl was not found on the location…

  • Multiple Database Services Are Not Constant Across the Scan Listeners In Two Nodes RAC

    In a Real Application Cluster (RAC) setup, the SCAN listener running on Node 1 was able to register only the local instances, but failed to register remote instances from other nodes. In contrast, the SCAN listener on Node 2 functioned as expected and was able to register instances from both Node 1 and Node 2.…

  • Oracle Restart ASM Diskgroups Dismounted Automatically

    Recently, we encountered a critical issue in one of our Oracle Restart environments (version 19.26 RU) where the SUNDNELLY database suddenly stopped working and all the ASM diskgroups were dismounted. We had two diskgroups configured: Problem Summary Upon initial investigation, ASM appeared to be running fine. However, when attempting to manually mount the DATA diskgroup,…

  • Steps to Restore Oracle Grid Infrastructure (GI) Home on a Bad Node

    Note: Modify the paths according to your environment. Ensure that permissions, ownership, and group settings match the good node for consistency. Step 1: Create a Tarball of Grid Home from a Good Node On the good node, create a compressed tar archive of the Oracle Grid Infrastructure (GI) home as per below command: Step 2:…