Patching OEM 13.3 for ZDLRA Support

Our organization has decided to use Oracle’s ZDLRA, further embracing Oracle’s engineered systems to a greater extent. Oracle Sales was able to win the business over EMC Data Domain at a lower cost.  Data Domain’s DDBoost has been tedious to configure to a point that moving away is actually encouraging.

Read more

Database Migration and the Split-Brain Situation

  Database migration/upgrade is a way of life for any DBAs.  There can be many reason requiring data migration: data center move, hardware upgrade, software upgrade, etc.  The most ridiculous justification I’ve heard of is one of IT security compliance.  Whatever the reasons may be, DBAs can get really busy really fast, being swayed by…

Read more

Oracle Openworld 2019

This year was my 4th time going to Oracle Openworld at San Francisco.  The last time I went, it was 2017.  That year, Blue Angels were doing an exhibition and there was a bit more energy in the city.  This year, however, is a little quiet.  I took these pictures before and after the event,…

Read more

Virtualizing the RMAN Catalog

The Oracle Recovery Catalog(henceforth, the catalog) is used by Oracle’s RMAN backup utility to store backup metadata and is included by Oracle as best practice for backup and recovery.  In this article, I will discuss about the common dilemma of maintaining the catalog and the proposition of virtualizing it.

Read more

Oracle Database Standard Edition(SE): PROs and CONs

[Starting December 2015, SE and SE1 have been replaced by SE2 and have disappeared from Oracle’s Technology Price List.] With the advent of open source relational database platforms, many organizations must be looking at Oracle Enterprise Edition(EE) pricing and calling it outrageous.  Not to mention the drying up of budgets in this economy.  You can’t…

Read more

Oracle’s 32 Character Limit in Generating Histograms

Upon Oracle’s release of 11g and noticeably with 11g Release 2, Oracle’s functionality is pretty rock solid.  What I considered the most obvious weaknesses of the Oracle database engine are now resolved.  Namely, Adaptive Cursor Sharing resolves the problem of bind peeking, and SQL Plan Management resolves plan stability issues.  But one limitation still remaining…

Read more