Sharing Tips & Tricks from my Database Experience
Category: General DBA
Introduction: This Part 1 post will show you how to create a GoldenGate Free 23.3 (Hub) that connects to two Oracle Database Free 23.3 (I am calling them West and East). This is extremely easy if we take advantage of containers as I will describe it below. Part 2 will demonstrate how to automate the creation … Continue reading Part 1- Deploy GoldenGate 23c Free and two Oracle Database 23.3 on Docker in just a few Minutes
An essential consideration when configuring Oracle GoldenGate for bi-directional or multi-directional (active-active) data replication is the potential for data collision, which occurs when identical data is modified in distinct databases involved in the integration. GoldenGate includes an out-of-the-box capability to detect and resolve such conflicts. Automatic Conflict Detection and Resolution (ACDR) is configured at the … Continue reading Enable ACDR for all tables in a GoldenGate Bi-Directional Replication
From time to time you might need to find out where a particular transaction is in the redo logs. Most of the time if you want to look for an old transaction you will need to look into the archived logs history. This script will give you a good understanding of where the SCN for … Continue reading Find the Archived log from a SCN
Back from my archives, I thought to share this simple and decent script to monitor file systems. #!/bin/sh #set -x #:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: # Author: Alex Lima # Client: XXXXXXXXX. #:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ## #:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: # Shell script to monitor or watch the disk space # It will send an email to $ADMIN_EMAIL, if the (free available) percentage of … Continue reading Disk Space Alert Monitoring
Download the GoldenGate Free 23c image from Docker Hub for quick deployment. https://hub.docker.com/r/alexlima/goldengate-free Get Oracle GoldenGate up and running in less than 10 minutes with these 4 easy steps: 1- Download the image from Docker HUB docker pull alexlima/goldengate-free:latest 2- Create a custom network for internal communication docker network create \ --driver=bridge \ --subnet=172.1.0.0/16 \ … Continue reading GoldenGate Free 23c from Docker Hub
List of all running and not running containers: docker container ps -a
select pg_size_pretty(sum(pg_total_relation_size(inhrelid::regclass))) from pg_inherits where inhparent='<schema>.<table>'::regclass; pg_size_pretty ---------------- 4410 GB
Back in April 2023 I joined the Quantic Executive MBA Cohort July 2024. Quantic School of Business and Technology offers an online executive education program named the Quantic Executive MBA. Quantic is a cutting-edge educational platform that offers rigorous business education in a digital-first format. https://quantic.edu/executive-mba The Quantic Executive MBA is intended for experienced professionals … Continue reading Executive MBA me? Who would thought?
Oracle's fourth-quarter numbers are in, and here are a few key insights. It's impressive to watch how Oracle is gaining ground. All thanks to the confidence of our customers and the successful implementation of the plans made by our executives! Revenue increased by 17% year over year. Cloud services and licensing support increased by 23% … Continue reading Oracle Q422 Results are out and beat estimates
OCI goldenGate has come a long way in the last year or so. Below are the connections it currently supports. Lots of excitement in this area of the product. I can't wait to see what comes next. What do you think? What would you like to see? Drop a comment below. Here are some cool … Continue reading OCI GoldenGate Service (GGS) Connection Types
Don't be left behind. GoldenGate Migration Utility was created to help you migrate from Classic to Microservices architecture without many manual procedures. Check out the video DEMO available on the GoldenGate Youtube Channel: https://www.youtube.com/watch?v=PQktlsAuJYI&ab_channel=oraclegoldengate
We were pleased to announce the availability of Oracle GoldenGate Free 21c, the same robust Oracle GoldenGate that enterprises worldwide rely on, packaged for easy download, user-friendliness, and a feature-rich experience. It is the entire application portfolio delivered in an Oracle Docker container that is available for deployment anywhere – on-premises, in OCI, or on other … Continue reading GoldenGate Free 21c Deployment on Docker
Most of the time, when GoldenGate extract runs without a hitch, and the GoldenGate monitor displays no anomalies or slowness, we are unaware that a prolonged open transaction is holding a lock in the database, which can result in long pipeline latency. This issue can occasionally arise because an application has not properly cleaned up … Continue reading Check for Long Open Transactions with Python
Microservices Architecture is extremely better and Oracle strategic direction. Here are some high level comparison of the features. Start planing your migration today. Note the only "NO" in the Microservices column is the deprecation of the PUMP and that's because we replaced with the Distribution Path (Distribution Service) which is a multithreaded and more secure … Continue reading Key GoldenGate Microservices Benefits over Classic Architecture
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
alexlima.com 