Fixing HTTP Service Issue After Sudden Power Shutdown of Oracle EBS 12.2 Application Server Overview Recently, I faced an issue in an Oracle E-Business Suite 12.2 environment after a …
Read More »txkCfgUtlfileDir.pl Error in getUtlFileDir Mode
Fixing txkCfgUtlfileDir.pl Error in getUtlFileDir Mode After Restoring Oracle EBS 19c Database Recently, after restoring an Oracle E-Business Suite database backup on Oracle Database 19c, I faced an issue …
Read More »Copy Password File from Primary to Standby ASM
Copy Password File from Primary to Standby ASM Recently, while working on an Oracle 19c Data Guard environment, I came across a requirement where the password file from the …
Read More »Corrupted Undo Tablespace in an Oracle RAC Database
Corrupted Undo Tablespace in an Oracle RAC Database Overview Recently, I came across an issue in one of the Oracle RAC database environments where the undo tablespace became problematic and …
Read More »Step-by-Step Guide to Convert Physical Standby to Snapshot Standby
Complete Step-by-Step Guide to Convert Physical Standby to Snapshot Standby Introduction Recently, I had to work on a requirement where the standby database needed to be opened in read-write …
Read More »How to Move SPFILE from ASM to File System
How to Move SPFILE from ASM to File System Recently, I faced a requirement where I had to move the Oracle database SPFILE from ASM to the file system, …
Read More »Dataguard Switchover And Failover Using DGMGRL
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 »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner