Dhiraj Kumar's Blog

Category: oracle

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

  • Oracle AI in Oracle CloudWorld: Transforming the Future of Enterprise AI

    Oracle has been at the forefront of enterprise AI innovation, integrating cutting-edge artificial intelligence (AI) capabilities into its cloud offerings. At Oracle CloudWorld, the company unveiled groundbreaking advancements in Oracle AI, reinforcing its commitment to empowering enterprises with intelligent, scalable, and secure AI-driven solutions. At the latest Oracle CloudWorld, the company introduced several AI-powered innovations,…

  • Oracle 23ai Features

    Oracle Database 23ai, the latest long-term support release from Oracle, introduces over 300 new features designed to enhance database performance, developer productivity, and artificial intelligence (AI) integration. Here are some of the most notable enhancements Oracle Database 23ai introduces AI Vector Search, a breakthrough technology that enables searching for documents, images, patterns, and data that…