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...
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 presented in this article are for educational purposes only. They are not supported by...
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...
Introduction The Oracle GoldenGate (OGG) Passive-Alias Extract may be used for data replication between source databases located on servers in untrusted...
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 for data capture and delivery to the trusted zone database server. The concepts, scripts, and information...
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...
Introduction In this article we shall discuss how to configure and run Secure Shell (SSH) Socks Proxy server needed for Oracle GoldenGate (OGG) replication...
Introduction In this article we shall discuss how to configure and run Secure Shell (SSH) Socks Proxy server needed for Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) in the Oracle Public Cloud (OPC). The SSH Socks Proxy server is required in GoldenGate replication between On-Premises and OPC, only if there's no VPN connectivity between the two sites, and the only connection allowed to the replication target on the OPC is via SSH....
Introduction In this article we shall discuss how to configure and run Secure Shell (SSH) Socks Proxy server needed for Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud...
Introduction This paper provides guidance and examples for setting up downstream extraction from an Oracle DataGuard Standby system that has been configured...
Introduction This paper provides guidance and examples for setting up downstream extraction from an Oracle DataGuard Standby system that has been configured with cascading redo logs. We outline how to configure the cascade log shipping from the standby to the mining database as well has how to configure the extract process on the mining server to fetch necessary data from the DataGuard standby system. Instantiation of target systems from an DataGuard standby has special...
Introduction This paper provides guidance and examples for setting up downstream extraction from an Oracle DataGuard Standby system that has been configured with cascading redo logs. We outline how...
Introduction This document will walk you through how to configure Virtual Private Network as a Service (VPNaaS) with Oracle Data Integration Platform Cloud...
Introduction This document will walk you through how to configure Virtual Private Network as a Service (VPNaaS) with Oracle Data Integration Platform Cloud (DIPC) for connectivity between On-Premises Oracle database and Oracle Public Cloud (OPC). One major requirement for DIPC to be configured with VPNaaS is; DIPC must be provisioned to use IP Network instead of a Shared Network. Managing and configuration of OPC's IP Networks are not discussed in this article. It is assumed...
Introduction This document will walk you through how to configure Virtual Private Network as a Service (VPNaaS) with Oracle Data Integration Platform Cloud (DIPC) for connectivity between On-Premises...
Introduction Apache Flume is a distributed, reliable, and available system for efficiently collecting, aggregating and moving large amounts of log data from...
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 Sink. In this article we will setup the Oracle GoldenGate Big Data Flume Handler and configure data apply from Oracle 12c...
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...
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...
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 GoldenGate Big Data Apache Handler configuration settings to create secure connections. This document covers...
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...
Introduction Apache Kafka is a distributed, partitioned, replicated commit log service that provides the functionality of a Java Messaging System. The Oracle...
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 Kafka Handler, configure data apply from Oracle 12c tables, and show examples of the different big data...
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...
Introduction Oracle GoldenGate for Big Data provides runtime, pluggable functionality into the Oracle GoldenGate Java Delivery framework in order to stream...
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 into Apache HDFS. This document covers functionality present in Oracle...
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,...
