So, now that I have completed my series on OpenLDAP for Oracle Net Service Name resolution, my next little adventure will be exploring the possibilities of zero downtime upgrades for Oracle 11gR2 and 12cR1. This is an area that I don’t have a lot of experience with, so, I’ll be pretty much starting at ground zero.
Oracle’s suggested solution is GoldenGate. (Oracle also has a near-zero downtime upgrade ability using Logical Standby, but, my understanding is that there are some datatype limitations with that solution.) So, my goal last month, in attending Oracle Openworld, was to learn about GoldenGate, and what it can do. However, I also learned about another product, by a company called dbvisit, that claims to offer the same functionality in replication and (near)zero downtime upgrade abilities.
I’ve just been handed control of two VMware guests (4 cores, 32 GB RAM, running OL6.3). So, I’ll be installing Oracle 11gR2 (18.104.22.168.0) on both servers, and then I’ll configure replication using Oracle GoldenGate. Once that’s done, I’ll attempt an upgrade to Oracle 12cR1 (22.214.171.124.0). Finally, I’ll do a game reset on the two database servers, get them back to 11gR2, and try the same exercise using the dbvisit Replicate software. I’ll be blogging about my experience with each of these products, and my thoughts about usability, performance, any problems or issues I run into along the way.
Stay tuned for the next blog posting, in the next week or so, (near)Zero Downtime Upgrades for Oracle 11g/12c — GoldenGate installation and configuration.