Dhiraj Kumar's Blog

Category: oracle

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

  • Failing to Start an Instance of a Oracle RAC Cluster

    I am unable to start one instance of a two-node RAC cluster after a reboot. However, the instance on Node 2 is functioning correctly. The issue arose due to an abrupt crash, as both machines were powered off from my ODA boxes. Symptoms Cause The root cause of the issue is an incorrect permission setting…