Oracle Data Guard Broker Drill (19c): Switchover + Failover Using DGMGRL (End-to-End Runbook) This week I ran a Data Guard Broker DR drill for a client on Oracle 19c, covering …
Read More »Configuring Oracle Data Guard Broker
Configuring Oracle Data Guard Broker for High Availability How I recently standardized an existing Primary/Standby setup using Broker (DGMGRL) for simpler HA operations. In one of my recent HA/DR …
Read More »Copy Password File From Primary to Standby ASM
Copy Password File From Primary to Standby ASM If you’ve worked with Oracle Real Application Clusters (RAC) or Data Guard, you know that because the password file …
Read More »A Deep Dive into Huge Pages
A Deep Dive into Huge Pages Recently, was working on optimising an Oracle database server that was struggling with memory management overhead. The server was beefy, sporting …
Read More »ASM Command-Line Utility (ASMCMD) – Complete Guide
ASM Command-Line Utility (ASMCMD) – Complete Guide for Oracle DBAs Introduction Oracle ASM Command-Line Utility (ASMCMD) is a powerful and essential tool for Oracle DBAs and Grid Infrastructure administrators working …
Read More »Fixing OPP Concurrent Manager in System
Fixing OPP Concurrent Manager in System Hold Status Oracle E-Business Suite R12.1.3 (Out-of-Support Environment) While supporting an old customer still running Oracle E-Business Suite R12.1.3, an out-of-support release, I recently …
Read More »ORA-15041: Diskgroup DATA Space Exhausted
ORA-15041: Diskgroup “DATA” Space Exhausted — How to Diagnose & Fix the Issue When working in Oracle RAC/ASM environments, one of the common storage-related issues is ORA-15041: diskgroup space exhausted.This …
Read More »ADJRIINITPASSWD ORA-01031 Error in Oracle E-Business Suite
ADJRIINITPASSWD.sql ORA-01031 Error in Oracle E-Business Suite When running ADJRIINITPASSWD.sql, you may encounter an ORA-01031: insufficient privileges error. This typically occurs when Oracle EBS is unable to retrieve password information …
Read More »Troubleshooting Workflow Mailer Errors in Oracle E-Business Suite
Troubleshooting Workflow Mailer Errors in Oracle E-Business Suite The Workflow Mailer in Oracle E-Business Suite is a critical component for sending notifications and driving business processes. When it fails …
Read More »Oracle Optimizer: A Practical Guide For a Good Execution Plan
Oracle Optimizer: A Practical Guide For a Good Execution Plan Have you ever seen a critical SQL query run lightning fast one day and unbelievably slow the next—without a …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner