Deep dives for
serious Oracle
engineers
Production-grade Oracle DBA insights from a practising ACE Apprentice. Oracle 9i to 23ai, Exadata, RAC, AWR, GoldenGate, OCI — the hard problems, solved in writing.
Part 3 of 3: Updating the Agents from RU5 to RU8, One Estate, One Version, via the OEM patching tool..
The final post in the OEM 24ai RU5 to RU8 upgrade series, the mass agent update via OEM Agent Patching, off-peak batching across DEV, UAT, and PROD, and the validation queries that confirm every host in the estate is on the new RU.
Part 2 of 3: Upgrading the OMS to 24.1.0.8 using ZDT, Three Tools, One Window, No Downtime..
This is the 2nd part of the upgrade guide for OMS to 24ai R1 RU8 which just released this April.
Part 1 of 3: From RU5 to RU8, Upgrading OEM 24ai the Right Way , Start With the Foundation, Patching the OMR Database on OCI
This will be your only detailed guide to upgrade your OEM RU5 to RU8 correctly without making huge downtime.
Oracle Enterprise Manager 24ai, An Old Friend Got a Serious Update..
Do you know about the new features in 24ai, absolutely Yes, but have you tried it, it worths your time to do so...
AWR is Talking, Are You Actually Listening? A Practical Guide to Reading What Matters
How to read an AWR report as a conversation rather than a symptom lookup — context, load profile, wait-event patterns, SQL and segments.
Moving from DBCS to ExaCS — The Things Nobody Puts in the Migration Guide!!
Lessons from migrating production Oracle databases from DBCS to Exadata Cloud Service — the things the official guide skips.
gc buffer busy acquired: The RAC Wait Event That Ruined My Weekend
A RAC gc buffer busy acquired war story — how an application optimisation concentrated hot blocks and doubled transaction times.
How to Partition a Large Table Online in Oracle Without Downtime (DBMS_REDEFINITION)
Converting a 20TB monolithic table to range-interval partitioned IOT with LOB compression — online, using DBMS_REDEFINITION.
I just became an Oracle ACE Apprentice! Here's how you can join the club
A personal note on joining the Oracle ACE program as an Apprentice and how the four-level path works for DBAs at any career stage.
Oracle RMAN Backup Progress Monitoring: Scripts & V$SESSION_LONGOPS
Two practical SQL scripts for monitoring RMAN backup progress — compression ratio, percent complete, and estimated finish time.
Configuring Bidirectional Replication using Oracle GoldenGate 12c
Step-by-step GoldenGate 12c bidirectional replication setup on Oracle 12.1 and Solaris 11.2 SPARC — Extract, DataPump and Replicat.
Enabling/Disabling Database Options in Oracle Enterprise Edition with chopt
Use the chopt utility to disable unlicensed Oracle Enterprise Edition options and avoid licensing surprises on 11.2 and later.
Fix ORA-01017: ASMSNMP User Missing After Grid Infrastructure Install
Why DBCA fails with ORA-01017 after an 11.2.0.4 Grid Infrastructure install — the ASMSNMP user is missing, and here is how to create it.
Search OraDiscuss and docs.oracle.com in one place. Look up any
ORA- error code and get the official Message, Cause, and Action.
Database administration, migrations to OCI and ExaCS, performance and health assessments — production-grade work by an Oracle ACE Apprentice.
Distilled.
Deep technical posts on Oracle performance, RAC, Exadata, and AI-assisted DBA workflows.