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/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
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
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 more
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 more
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
Different people write SQL queries differently. More often than not, the approach reflects the person’s way of life. Some people draw all the relationships out in a diagram, then write the query adding one table at a time. Some people just write the queries out straight. There is also this other kind that dumps 20+…
Read more