Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Intro Post for Farhan Ali 12+ Years as an Enterprise Oracle DBA | Cloud | DR | Performance Enterprise Database Leadership With over 12 years of experience as a Database …
Read More »Intro Post for Farhan Ali
Yearly Archives: 2026
Intro Post for Ibrahim Khalil
Intro Post for Ibrahim Khalil I’m an experienced Oracle & Cloud Database Engineer with over 8 years of expertise in database administration, high availability, and enterprise-scale performance optimization. This blog is where I share practical lessons, real-world …
Read More »Implementing Oracle Discrete Manufacturing in Apparel Industry
Implementing Oracle Discrete Manufacturing in Apparel Industry Introduction Garment manufacturing is one of the most operationally complex discrete manufacturing domains. Unlike traditional discrete industries, apparel production must simultaneously manage size-based …
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 »Datapump
Check Directories ================== SQL> desc DBA_DIRECTORIES; SQL> select * from dba_directories where directory_name=’DATA_PUMP_DIR’; =================================================================== Change datapump directory =================================================================== SQL> CREATE OR REPLACE DIRECTORY “DATA_PUMP_DIR” as ‘/app/oracle/product/11.2.0/dbhome_1/rdbms/log/’; …
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 »