Dhiraj Kumar's Blog

Category: oracle

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

  • Deconfigure and reconfigure the Oracle Restart environment for GI version 19.26.

    I would like to share my experience from a month ago when I upgraded my operating system from RHEL 7 to RHEL 8 on a system running the Oracle Restart environment with Grid Infrastructure (GI) version 19.26. Following the upgrade, I encountered an issue where I was unable to start the High Availability Services (HAS).…

  • Clusterware Active Version In ‘ROLLING PATCH DURING ROLLING UPGRADE’

    I would like to share my experience regarding the new scenarios I encountered while patching up a two-node test cluster in Oracle RAC. I had tried an upgrade to 23ai which was backed out and good to know why the patching failed. After extensive troubleshooting, I was able to resolve the issue successfully. However my…