Sharing Tips & Tricks from my Database Experience
Category: General DBA
Our Spring Summit will be a 4hr webinar packed with the latest updates about Oracle GoldenGate and Stream Analytics, featuring customer stories, live demos, and a roadmap for the future of Data Fabric and Data Mesh architectures. We look forward to hosting you at this highly informative event. Zoom Event for EMEA Wednesday March 29, … Continue reading Oracle GoldenGate 2023 Virtual Customer Summit
I took some time this past weekend to play around with automating GoldenGate with Python and the REST APIs. Below, find the source code of a #Python script that gives you some extract and replicat statuses in a given deployment. I look forward to enhancing this with multiple deployments. I wish everyone that has already … Continue reading GoldenGate Automation with REST API and Python
If you need to set your TNSNAMES.ora file in the new GoldenGate 21c Microservices, how do you find the location? Simple, In the service manager, click on your deployment (West in this case below) and click on the configuration. Note that when you create your credential, instead of using the tnsnames.ora in the TNS_ADMIN location, … Continue reading Where is the TNS_ADMIN in GoldenGate Microservices 21c?
Join Glen Hawkins (@hawkinsg1) and me as we kick off the @OracleMAA Never Down Series on 8/23 at 11 AM PT to learn more about the latest @OracleDatabase and #MAA capabilities around configuring Hybrid Cloud Disaster Recovery in OCI using both #Oracle Data Guard and OGG. #GoldenGate Register Here: go.oracle.com/LP=129345
Full post can be found here: https://blogs.oracle.com/dataintegration/post/goldengate-microservices-initial-load-instantiation-with-webui
More often than not, I get a question about REST API documentation for GoldenGate and how we can use it to build automation, monitoring, and rest calls. Well, the first part it's not difficult, we can always get all the REST API latest information from the documentation available at: https://docs.oracle.com/en/middleware/goldengate/core/21.3/oggra/ We can also use "set … Continue reading How can we build our REST API calls from Goldengate adminclient?
This is a quick setup of a goldenGate HUB in Docker with an Extract from a 12.2 Oracle database and a Replicat to a 19.1 Oracle Database. The assumption is that you already have 1 or 2 databases that you can use for source and target and you have a GoldenGate HUB installed and configured. … Continue reading Quick GoldenGate WebUI HUB Replication Configuration
When debugging data issues with GoldenGate one of the first things I like to do, is to check if the source and target tables are the same. There are several different ways we can do that, but I find the easiest and quickest way to check this is using SQL Developer in conjunction with SQLcl … Continue reading SQL Developer / SQLcl “info+” command
The purpose of this post is to simply demonstrate how we can automate the GoldenGate Microservices replication from connecting the remote databases to create extract and replicat. For demonstration purposes the GoldenGate is installed as a HUB configuration, connecting to a source 12c database to a Target 19c database. To simplify the demo, there will … Continue reading Demo – How to Quick Automate GoldenGate Microservices Replication
https://youtu.be/PZy-3r86kr4 To download the GoldenGate Migration Utility 21c log in to MOS: Patch 33565581 Also, please visit my colleague Juliana Gomes's post on the same subject: https://www.linkedin.com/pulse/oracle-goldengate-21c-migration-utility-juliana-a-gomes/
GoldenGate 21c was released back in May 2021 and has introduced some very exciting new features, I wanted to share with you my top 5. Although it was a hard decision to pick 5, I felt those below were most relevant based on my experiences with clients' requests and pain points. I am focusing this … Continue reading My Top 5 favorite GoldenGate 21c New Features
This Thanksgiving weekend, I wanted to create an easy and repeatable process to instantiate a GoldenGate Docker container for different versions. I wanted to be able to create a working container in under 5 minutes, for those quick calls when you need to test something, show someone a feature or etc. To achieve that, I … Continue reading Create GoldenGate 21c Microservices Docker Container under 5 min
The Oracle GoldenGate product team is pleased to announce the general availability of Oracle GoldenGate for Big Data 21.4.0.0.0. Figure 1 – Snowflake Delivery New Features Enhanced Snowflake Stage & Merge DeliveryDelivery into Snowflake has been dramatically improved in this release. It is now easier to set up with a pre-built properties template to automate … Continue reading New Release Oracle GoldenGate for Big Data 21.4.0.0.0
There were INFO messages from the adminsrvr, recsrvr, distsrvr for each deployment filling up the /var/log/secure file. Editing this file and restarting each deployment have fixed it: /u01/app/ogg/ogg_19c/lib/utl/logging/ogg-audit.xml Modified from <level value="info"/> to <level value="warn"/> UPDATE: If you want to complete turn off the logging you can do this: <level value="info"/> to <level value="off"/> Issue … Continue reading GoldenGate PMSRVR log entries filling up /var/log/secure
alexlima.com 