Oracle Cloud Infrastructure (OCI) REST call walkthrough with curl

  Introduction This post will walkthrough the elements required, and purpose of each, to make a curl request to Oracle Cloud Infrastructure (OCI) REST services. While there are a variety of tools offered that make this task far easier than manually constructing a curl request, the purpose of this post is to provide an explanation […]

Oracle GoldenGate Services Architecture: Silent Install and Deployment

Introduction In many organizations, users are not permitted to run the graphical user interfaces used to install the Oracle GoldenGate software and create Oracle GoldenGate Microservices Architecture (OGG-SA) Deployments. In this article we shall review the two response files required to silently install the OGG-SA application code and create a new Deployment. The concepts, scripts, and information presented in […]

Oracle GoldenGate Services Architecture: Configure Deployment Via REST API

Introduction The Oracle GoldenGate Microservices Architecture (OGG-SA) REST API may be used to configure Extracts, Replicats, and Distribution Paths, as well as create new parameter files or modify existing ones for a Deployment. In this article we shall use the REST API to configure a replication path and perform common modifications to Deployments; such as changing OGG_HOME after […]

Getting Started Using Terraform with OCI

Introduction Standing up infrastructure requires building networks, servers and storage entailing complex build and configuration management processes. Traditionally done with scripts or even manually, Terraform gives you a new alternative. Using Terraform you can write a declarative description of your infrastructure. Using the Terraform “compiler” the declaration is converted to a build plan and then […]

Oracle GoldenGate: Monitoring “Things” That Affect Replication Stability

Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring their environments. In this article we’re going to discuss various areas that should be monitored regularly to avoid degradations in performance and unscheduled outages. The concepts, scripts, and information […]

Oracle GoldenGate: Passive-Alias Extract

Introduction The Oracle GoldenGate (OGG) Passive-Alias Extract may be used for data replication between source databases located on servers in untrusted security zones and target database servers in trusted security zones. In this article we’ll configure Alias Extracts on a trusted zone OGG instance that will interact with Passive Extracts on untrusted zone OGG instances […]

Oracle GoldenGate Microservices Architecture: Using Self-signed Certificates

Introduction Oracle GoldenGate Microservices Architecture (OGG-MA) provides functionality for securing Rest API calls and communications channels between the Distribution and Receiver Servers over Transport Layer Security (TLS). In order to activate this security protocol a SSL Certificate must be obtained from a Certificate Authority (CA) and installed on the server prior to creating the OGG-MA […]

Oracle GoldenGate Services Architecture: Monitoring Via REST API

Introduction The Oracle GoldenGate (OGG) REST API may be used to configure, manage, and monitor Oracle GoldenGate Microservices Architecture (OGG-MA) services and deployments. In this article we shall use REST API to monitor an existing OGG-MA deployment. The concepts, scripts, and information presented in this article are for educational purposes only. They are not supported by […]

Oracle GoldenGate: Migrate to Microservices Architecture

Introduction Oracle GoldenGate Microservices Architecture (OGG-MA) is a Restful API microservices based architecture that provides functionality for the configuration, installation, and management of Oracle GoldenGate services using a web-based user interface. In this article, we’ll migrate an existing Oracle GoldenGate Classic (OGG) instance to an OGG-MA deployment. The concepts, scripts, and information presented in this article are […]

Oracle GoldenGate: Apply to Apache Flume File Roll Sink

Introduction Apache Flume is a distributed, reliable, and available system for efficiently collecting, aggregating and moving large amounts of log data from many different sources to a centralized data store. The Oracle GoldenGate for Big Data Flume Handler is designed to stream change capture data from a Oracle GoldenGate trail to a Flume File Roll […]

Oracle GoldenGate Big Data Adapter: Establishing Secure Connections to Apache Kafka

Introduction When publishing data to Apache Kafka via the Oracle GoldenGate Big Data Kafka Handler, it is a good practice to establish secure connections in order to protect sensitive data from un-authorized snooping. The Oracle Big Data Kafka Handler leverages encryption and authentication features built-in to Apache Kafka. In this article we shall detail the Oracle […]

Oracle GoldenGate Big Data Adapter: Apache Kafka Producer

Introduction Apache Kafka is a distributed, partitioned, replicated commit log service that provides the functionality of a Java Messaging System. The Oracle GoldenGate for Big Data Kafka Handler acts as a Kafka Producer that writes serialized change capture data from an Oracle GoldenGate Trail to a Kafka Topic. In this article we will setup the Oracle GoldenGate Big Data […]

Oracle GoldenGate Big Data: Apply to Apache HDFS

Introduction Oracle GoldenGate for Big Data provides runtime, pluggable functionality into the Oracle GoldenGate Java Delivery framework in order to stream transactional data into big data systems, raising the quality and timeliness of business insights. In this article we shall setup the Oracle GoldenGate Apply mechanism (Replicat) to stream data captured from an Oracle 12c Multi-tenant Database […]

Setup Oracle API Gateway on OCI-Classic in Oracle Public Cloud

This blog provides steps to get Oracle API Gateway up and running on Oracle cloud- OCI Classic VM We will see following steps: 1. Create compute instance on Oracle Cloud Infrastructure Classic (OCI-classic) 2. Create Logical gateway in API management console and Assign grants to add nodes 3. Connect OCI-classic instance using SSH and copy […]

Oracle GoldenGate: DDL Replication To Oracle Targets With Dissimilar Data Structure

Introduction Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the source and target tables structures are the same. The challenge comes when the source and target tables have a dissimilar table structure; as may exist in a Data Warehouse or Reporting Database. In this […]

GoldenGate Cloud Service (GGCS): How to configure Oracle GoldenGate (OGG) SOCKS Proxy Server via HTTP Proxy Server

Introduction In this article we shall discuss how to configure Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) via HTTP Proxy Server. This discussion will include a sample configuration setup. This approach is very similar to configuring OGG Replication between On-Premises and GGCS via DMZ server, the only main difference is how […]

Oracle GoldenGate: Capture and Apply of Microsoft SQL Server DDL Operations

Introduction Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases only. Because of this, maintenance tasks for other databases require a lot of coordination and typically an extended OGG outage. In this article we shall discuss one option for automating the capture, delivery, and execution of DDL operations using OGG […]

Oracle GoldenGate: Integrated Heartbeat

Introduction Oracle GoldenGate (OGG) version 12.2 introduced an automatic heartbeat integrated into the application. In this article we shall demonstrate how to enable the OGG heartbeat in an Oracle to Oracle replication environment, demonstrate the additional information made available via heartbeat, and demonstrate how to manage and modify heartbeat across the replication environment. The concepts, scripts and information […]

Fusion Cloud IP-Whitelisting

Introduction With the increasing adoption of Oracle Cloud among customers, one of the key challenges the customers’ security teams face is managing network access for the newly purchased SaaS services. The security teams are firm on enforcing the rules and regulations around IT security that are already in place, and they expect their new SaaS […]

Oracle GoldenGate: Security Best Practices

Introduction Securing platforms, applications, and data from unauthorized access is of great importance to IT organizations. In this article we shall detail the product features and best practices for securing your Oracle GoldenGate environment. The concepts presented in this article are for educational purposes only. Before applying any changes presented in this article to your environment, […]