oracle goldengate Archives

When Your Oracle LOBs Won’t Play Nice with Snowflake: A Real-World Solution

6 days ago in

CLOB to VARCHAR

This week, I found myself deep in a familiar challenge – helping a client navigate the complexities of replicating Oracle Large Objects (LOBs) to Snowflake using Oracle GoldenGate. What started as a seemingly straightforward data integration project quickly revealed the nuanced technical considerations that separate

Real-Time Oracle Database to Google BigQuery: Powering AI-Driven Analytics with Oracle GoldenGate 23ai

3 weeks ago in

AI Machine Learning

Modern AI and machine learning initiatives demand fresh data to deliver accurate predictions and actionable insights. While traditional batch ETL processes served us well in the past, today’s AI models require continuous data streams to maintain relevance and accuracy. The retail and supply chain industries

Oracle to Snowflake: Your Complete Guide to Real-Time Data Integration with Oracle GoldenGate

2 months ago in

database migration

“Our Oracle databases are drowning in decades of business data, and our analysts are spending more time waiting for reports than analyzing them. We need to get this data into Snowflake for real-time analytics, but we can’t afford any disruption to our production systems.” Sound

Different pipelines for the masses

2 years ago in

If you work in the IT industry long enough, you start to see messaging or wording of items to repeat itself. In the case, we are going to take a look at the term “pipeline”. But what exactly is a “pipeline”? What is its purpose?

Modern Data Platform with Oracle Cloud Infrastructure (OCI)

2 years ago in

Does data drive your organization? Have you started your transition to a Modern Data Platform? Does your organization understand what it means or takes to transition to a Modern Data Platform? Yes, these are questions that organizations think they know the answer to until they

Data Pipelines – What is a data pipeline?

2 years ago in

A data pipeline is a method in which raw data or unchanged data is ingested from various data sources and shipped to another data store, like a relational database, data lake, or a data warehouse; where the data is eventually used for analysis. Before data

Oracle GoldenGate 23c “Free” – What you need to know!

2 years ago in

Last week at Oracle Cloud World, the Oracle GoldenGate Product team announced the latest version of Oracle GoldenGate “Free”! This release of Oracle GoldenGate was produced to enable developers and small (under 20GB) production environments to build Oracle GoldenGate in an automated fashion – actually

Resolving OGG-02028 Errors

2 years ago in

GoldenGate

The error OGG-02028: Failed to attach to logmining server OGG$<extract_name> error #,### – ORA-01292 LogMiner for upstream capture cannot find log file – is an indication that the Oracle archive log file that is needed for the extract to start is missing. There are a

Manually purging trail files from OCI GoldenGate Service

2 years ago in

curl

Oracle GoldenGate Service is Oracle’s cloud offering to quickly use GoldenGate to move data within OCI as well as other clouds. Now network connection and bandwidth has a bit to do with the speed of data being processed, but it a quick service over all.

Using NGINX in unsecure mode for Oracle GoldenGate

2 years ago in

Sometimes, you just want to run NGINX in unsecure mode (over port 80) for internal environments. The steps here are similar to what I posted some time ago in this post -> here. I’ll put these steps here as well and highlight (bold) which steps

GoldenGate Parameter Files – Format and Logic

2 years ago in

GoldenGate

As we have done multiple engagements with Oracle GoldenGate and helped clients get the most out of their investment; we have realized that 90% of the parameter files we deal will are not structured in a way that makes sense. Traditionally, Oracle GoldenGate parameter files

Performance with Oracle GoldenGate

3 years ago in

database

Recently we have been talking with customers about their Oracle GoldenGate implementations and how these implementations can benefit their enterprise architecture. During these discussions, one thing that sticks out is the need for performance, performance tuning, and how that actually correlates to what is

Mimic GGSCI with Python

3 years ago in

ggsci

Since the release of Oracle GoldenGate 12.2 (Classic) and Oracle GoldenGate 12.3 (Microservices), users have been able to interact with Oracle GoldenGate using RESTful APIs. I’ve written about this interaction in previous posts. With the option to use RESTful APIs, the flexibility that is introduced

Configuring Nginx on RedHat Linux 7.9 for Oracle GoldenGate 21c

3 years ago in

When installed, Oracle GoldenGat (Microservices) will set up “services” that require a port number for access. For the first run of the Oracle GoldenGate Configuration Assistant (OGGCA), the assistant will create the ServiceManager (1 port) and the first deployment (5 ports). That means six ports would need

Patch Oracle GoldenGate Microservices using RESTful APIs

3 years ago in

In 2017, Oracle introduced the world to Oracle GoldenGate Microservices through the release of Oracle GoldenGate 12c (12.3.0.0.1). Upon the initial release, Oracle promoted the benefit of using the Microservices Architecture for new platforms and the ease of upgrading and patching. This document will show

Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c

3 years ago in

Clean up old Extracts

3 years ago in

dba_capture

For many using Oracle GoldenGate, there is a need to test out the desired configurations in a dev, test, or even a QA environment. This means there will be times where you will add, change, or delete different aspects of the Oracle GoldenGate processes. In

Minimize PMSRVR entries to /var/log – Oracle GoldenGate Classic

3 years ago in

/var/log/secure

Quick tip for Bug 30193036: If you are having a problem with error messages filling up /var/log/*, you can minimize this by simply editing the ogg-audit.xml file. Here is the solution: 1. Make a backup of $OGG_HOME/diretc/logging/ogg-audit.xml or comment out the line mentioned below. 2.

Installing Oracle GoldenGate Monitor Agent 12.2.1.2 – Silent

4 years ago in

This post is mostly for anyone at RheoData to use get a sense of how the Oracle GoldenGate Monitor Agent needs to be installed. The approach taken is to ensure that it is installed via the -silent process making it easier to install when looking

The transition has begun … Oracle GoldenGate merging into Oracle Database 21 (new features)

5 years ago in

News on the Oracle GoldenGate front!!!!! Over the years, Oracle has taken the Oracle GoldenGate product and have used it for a wide range of use-cases. In 2017, Oracle introduced the world to the next evolution of Oracle GoldenGate with the release of Oracle GoldenGate

Tag: oracle goldengate

Real-Time Oracle Database to Google BigQuery: Powering AI-Driven Analytics with Oracle GoldenGate 23ai

Oracle to Snowflake: Your Complete Guide to Real-Time Data Integration with Oracle GoldenGate

Different pipelines for the masses

Modern Data Platform with Oracle Cloud Infrastructure (OCI)

Data Pipelines – What is a data pipeline?

Oracle GoldenGate 23c “Free” – What you need to know!

Resolving OGG-02028 Errors

Manually purging trail files from OCI GoldenGate Service

Using NGINX in unsecure mode for Oracle GoldenGate

GoldenGate Parameter Files – Format and Logic

Performance with Oracle GoldenGate

Mimic GGSCI with Python

Configuring Nginx on RedHat Linux 7.9 for Oracle GoldenGate 21c

Patch Oracle GoldenGate Microservices using RESTful APIs

Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c

Clean up old Extracts

Minimize PMSRVR entries to /var/log – Oracle GoldenGate Classic

Installing Oracle GoldenGate Monitor Agent 12.2.1.2 – Silent

The transition has begun … Oracle GoldenGate merging into Oracle Database 21 (new features)

Articles

Resources

Products

Company