Database Blog

Fixing FRM-92101 Error After Re-Enabling a Custom Concurrent Program in Oracle EBS

Introduction During a recent Oracle E-Business Suite (EBS) maintenance activity, we needed to re-enable a custom concurrent program that had been disabled for a long time. Although the concurrent program…

Read More

Resolving PDB PLUG IN VIOLATION Wallet Key Needed Error When Opening Encrypted PDB

Introduction When attempting to open a plugged-in pluggable database (PDB) that contains encrypted tablespaces, the following error is raised: “TEST(5):ALTER PLUGGABLE DATABASE OPEN” detects that an encrypted tablespace has been restored but…

Read More

ORA-01000: Maximum Open Cursors Exceeded – Causes and Solutions

Introduction ORA-01000: maximum open cursors exceeded is a common Oracle Database error encountered when a session opens more cursors than allowed by the OPEN_CURSORS initialization parameter. A cursor is a memory structure…

Read More

ORA-04021: Timeout Occurred While Waiting to Lock Object – How to Find the Blocker

Introduction ORA-04021: timeout occurred while waiting to lock object occurs when Oracle tries to get a lock on an object, but another session is already using or holding that object. Oracle…

Read More

Azure Availability Sets vs Availability Zones Choosing the Right High Availability Solution

When we deploy applications in Azure, one of the first things we think about is availability. Nobody wants an application to go down because a physical server fails or Azure…

Read More

Azure Resource Locks: Preventing Accidental Deletion

Introduction If you’ve worked in Azure for any length of time, you’ve probably experienced that moment of panic after clicking Delete on the wrong resource—or at least worried that it…

Read More

Text Chunking in Oracle AI Database 26ai: A Practical DBA Guide

Artificial Intelligence is becoming a core capability of Oracle Database, and one of the first concepts you’ll encounter while exploring AI Vector Search is text chunking.  Whether you’re planning to build Retrieval-Augmented Generation (RAG) applications, semantic…

Read More

What Happens When You Corrupt the Wrong Block: Lessons from Oracle 26ai’s Transaction Quarantine

Introduction  I run a single-instance Oracle AI Database 26ai lab on my own VM, and I keep a running list of new features I want to actually get my hands…

Read More

Deploying a SQL Server database to a Microsoft Azure SQL database

Introduction / Issue   Organizations often need to migrate SQL Server databases from on-premises environments to Microsoft Azure SQL Database to leverage cloud-based features such as high availability, scalability, automated…

Read More

Migration from On-Premises SQL Server to Azure SQL Database Using a BACPAC File

Introduction / Issue   Organizations migrating from on-premises SQL Server environments to Microsoft Azure SQL Database often encounter challenges because Azure SQL Database does not support traditional SQL Server migration…

Read More