aoflima

[aoflima]

Understanding SID_NAME in a PDB Setup

In an Oracle Multitenant configuration, the SID_NAME in a Pluggable Database (PDB) setup differs from traditional standalone databases. Here’s how it works in general: 1. Understanding SID_NAME in a PDB Setup The SID_NAME in listener.ora is always associated with the Container Database (CDB), not individual PDBs. Pluggable Databases (PDBs) do not have a unique SID. Instead, they are accessed…

[aoflima]

What is OpenTelemetry?

OpenTelemetry (OTel) is an open-source observability framework that enables monitoring and management of cloud-native applications. It provides tools for tracing, metrics collection, and logging, helping developers gain insights into distributed systems. By standardizing observability, OpenTelemetry assists in monitoring application health, troubleshooting issues, and analyzing microservice…

[aoflima]

Configuring Oracle GoldenGate with TLS to Securely Connect to the Oracle Database

For this week, #GoldenTuesday, I am playing with configuring Oracle GoldenGate (OGG) to use TLS for secure communication with an Oracle Database, which requires configuring both the GoldenGate and Database Server to use TCPS (TLS-encrypted communication).  Extract and Replicat are in the same database for demonstration purposes using two distinct schemas (SOURCE_HR and TARGET_HR). Ensure there…

[aoflima]

GoldenGate @STRRTRIM function example

Here’s a complex example of using the STRRTRIM function in Oracle GoldenGate. This example demonstrates removing multiple different trailing characters, using them inside a CASE statement, and applying them conditionally. Scenario: You are replicating data from a customer orders table, where some customer names in the source database have unwanted trailing characters, such as #, *, or spaces.…

[aoflima]

Cultivate a Growing Mindset

Developing a growth mindset is essential for personal and professional development. It’s about believing in your ability to learn and grow, rather than being limited by your perceived talents or intelligence. 1. Know Your True Self Growth starts with understanding your strengths and weaknesses. This involves: Brutal honesty: Being honest with yourself about your current abilities and areas for…

[aoflima]

Cultive uma Mentalidade de Crescimento

Desenvolver uma mentalidade de crescimento é essencial para o desenvolvimento pessoal e profissional. Trata-se de acreditar na sua capacidade de aprender e evoluir, em vez de se limitar pelos talentos ou inteligência percebidos. 1. Conheça Seu Verdadeiro Eu O crescimento começa com a compreensão de seus pontos fortes e fracos. Isso envolve: Honestidade brutal: Ser honesto consigo mesmo sobre…

[aoflima]

Deprecated and Desupported Features in GoldenGate 23ai

As Oracle GoldenGate is constantly improving, and with the exciting release of version 23ai, some features are being phased out or are no longer supported. It’s important for users to be aware of these changes to help ensure a seamless transition and prevent any hiccups along the way. I understand that it’s easy to forget to read through release notes, so I want to make things easier for you.…

[aoflima]

Oracle GoldenGate: Ensuring Data Safety in Transit and At Rest

In today’s world, where data security is a top priority, protecting information as it moves between databases and applications is critical.  Oracle GoldenGate, as a powerful real-time data replication platform, ensures that your data remains secure at rest, in transit, and during access. With its Microservices Architecture and comprehensive security controls, GoldenGate provides built-in…

[aoflima]

Master Docker: Key Commands to Know

Essential Docker Commands You Must Know Docker has revolutionized containerization, making it easier for developers and system administrators to build, deploy, and manage applications. Knowing the fundamental commands is crucial for efficiency, whether you’re new to Docker or an experienced user. This blog post covers the essential Docker commands that every developer should know. 1. Basic…

[aoflima]

Quickly Retrieve Oracle GoldenGate Service Ports with an Automated Script

Introduction Oracle GoldenGate is widely used for real-time data replication, but managing its network configurations across multiple deployments can be a little tricker for finding out. When troubleshooting, performing security audits, or setting up integrations, quickly retrieving the network listening ports of GoldenGate services can be a lifesaver. To simplify this, I’ve created an ad-hoc…

[aoflima]

OGG-03200  Replicat requires DB checkpoint

Starting on Oracle GoldenGate 23.7 Oracle – All Replicats without checkpoints are desupported. The creation of integrated and classic Replicat without checkpoint tables is not supported in Oracle Database. Additionally, any Replicats that were created without the checkpoint tables, will not start successfully. For existing Replicats to run successfully, you must alter the Replicat to add a…

[aoflima]

We need to fail!

Failure is an essential part of growth and success. While it can be challenging, it serves important purposes in personal, professional, and emotional development. Here’s why failure is essential: 1. Learning Opportunity Failure provides direct feedback on what didn’t work, helping us understand and avoid mistakes in the future. It often uncovers blind spots and areas of improvement that…

[aoflima]

What's the difference between Oracle Database Service for Azure and Oracle Database@Azure?

As I have been studying for the Oracle Cloud Infrastructure 2025 Multicloud Architect Professional exam (1Z0-1151-25), this question caused me to pause and test a few things! Both Oracle Database Service for Azure and Oracle Database@Azure allows you to use Oracle databases within the Azure ecosystem. Still, they differ in how they achieve this: Oracle Database Service for Azure Location: Your…

[aoflima]

The Evolution of Oracle Exadata: 2008 to X11M

In 2008, I attended Oracle OpenWorld, an event in the history of enterprise computing. That year, Oracle unveiled the first Exadata Database Machine, a revolutionary product that promised to redefine how businesses handled large-scale data processing. Witnessing the debut of Exadata V1 was like being at the launchpad of a technological rocket. Fast forward to this week, 17 years later, and the…

[aoflima]

Deploy Oracle GoldenGate on Kubernetes with Helm

If you are looking to set up Oracle GoldenGate on a Kubernetes cluster using a Helm chart, you will need to define the configuration in a way that Helm understands. Helm charts are a great way to manage Kubernetes applications because they let you package all the necessary resources and settings together in one place. Here is a simple example of a basic Helm chart structure for deploying Oracle…

[aoflima]

What is "HANDLECOLLISIONS" all about in GoldenGate?

HANDLECOLLISIONS is a handy parameter in Oracle GoldenGate that helps you manage data conflicts when replicating data. It’s especially useful when both the source and target databases are being updated at the same time. This feature comes in really handy for initial data loads and in scenarios where both databases can make changes simultaneously, like in active-active setups. It makes the whole…

[aoflima]

Creating a Custom Profile for Extract and Replicat

Here is another example how to create a custom profile for your Extract or Replicat and make it the default. echo "############################" echo "## Creating Custom Profile" echo "############################" curl -k -X POST 'https://'$ogg_ip':'$ogg_port'/services/'$conn_name'/adminsrvr/v2/config/types/ogg:managedProcessSettings/values/ogg:managedProcessSettings:'$conn_name'-profile' \ -H…