2020 has been a tough year. Nobody would have imagined the devastation from COVID-19. But Hong Kongers knew. Since the SARS days, the trickery, the propaganda, and the hypocrisy have never been more clear. Ironically, something happened in this pandemic to my advantage. With this post, I’m hoping not to brag, but to document the…
Read morePatching 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 moreDatabase 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 moreOracle 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 moreOracle Enterprise Manager 13c Ports Dissected
Oracle’s documentation of Oracle Enterprise Manager’s ports is very minimal. This short article documents my findings in clarifying each of these ports with Oracle Support. Hopefully by documenting this, companies who are very stringent on security, such as those who deal with compliance, can use this as a reference.
Read moreStep-by-step Guide for ODA Release 18.3 Installation
I got these circumstances where puppet mucked with uid/gid of files and directories. Consequently, the clusterware on one node won’t come up anymore. 2 weeks interacting with Oracle Support to no avail. Unbelievable… Ultimately they suggested to remove the nodes from the cluster and add them back. That is exhaustive enough that I may as…
Read moreMass Updating OEM Target Attributes
Have you ever added your RAC cluster to OEM, thinking that you entered all the target properties at the right places? But after it’s done, you realize that there are still targets that have their properties left unset? The problem is more prevalent with Exadata, since it has many more targets. Or have you ever…
Read more