Orchestrating Oracle GoldenGate 23ai (Part 1 of 3)

|| Part1 || Part 2 || Part 3 ||

By Vlad Grigorian, an #Oracle #GoldenGate #23ai and #RedHat #Ansible #Automation | #Orchestration afficionado

Dedicated to Oracle GoldenGate DBAs all around this universe and beyond. Happy GoldenGating and be safe out there!        

First, on the difference between Automation and Orchestration. Both terms are used interchangeably, but they are not the same. Automation is the process of programming a task to be executed without human intervention, while Orchestration is the process of coordinating multiple, sometimes already automated tasks into a single workflow. Automation is often used for repetitive tasks or tasks that are complex and precise, and can help reduce the chance of human error. Orchestration can involve multiple applications, clouds, and technologies, and its goal is to ensure that all automated tasks are executed seamlessly and in harmony to achieve a goal.

Meet Bill. No, not that Bill, the other Bill, but this one is just as happy. Here he is. Look at him. Not a care in the world.

You see, Bill uses the free version of Oracle GoldenGate 23ai in OCI. The replication software does the job perfectly, broadcasting live inventory data from the main office. Bill doesn't have to maintain anymore. These days all the maintenance is done for him, automatically.

But you are not Bill (you wish you were, though). You are a Program Manager for a blue chip company. Unlike the Bill there, your GoldenGate fleet is enormous. Different parts of it belong to different, sometimes competing business units with disparate budgets. You have thousands of extracts and replicats, they are all multi-directional and heterogeneous. You have so many different OGG versions that are running on so many different operating systems - some need their OS patched before the actual Oracle work can be done. Others (even worse!) have been in drift or de-supported for years. Some are on-prem, others are in Azure or AWS, but most of your Oracle reside in the Oracle Cloud and looks like this.

... and this:

But there is even worse news. There is an $20mln licensing overlap now, which is very, very bad news for you, as a Program Manager. So, no wonder you don't look like the happy Bill at all. You wish you did. Here is what you look like, actually.

Because it isn't an asset inventory laptop screen you are shouting into. It is six months of blood, sweat and tears (and possibly a mild heart attack to boot). The automation that helped the happy Bill won't help you. You have to orchestrate. Now.

|| Part1 || Part 2 || Part 3 ||

Next, in parts 2 and 3, we will unleash the power of RedHat Ansible to provision and maintain Oracle GoldenGate 23ai. Stay tuned!

Happy GoldenGating, folks!

Vlad Grigorian .

By Vlad Grigorian, an #Oracle #GoldenGate #23ai and #RedHat #Ansible #Automation | #Orchestration afficionado