GoldenGate Cloud Service (GGCS): How to run SSH Socks Proxy Server for Oracle GoldenGate (OGG)

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 […]

Oracle Data Integration Platform Cloud (DIPC): Configure VPN as a Service (VPNaaS) for On-Premises Connectivity

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 […]

GoldenGate Cloud Service (GGCS): Using VPN as a Service (VPNaaS) for Replication from On-Premises to Oracle Public Cloud (OPC)

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) using Virtual Private Network as a Service (VPNaaS). The VPNaaS is another way Oracle provides VPN connectivity between On-Premises and OPC. For a list of […]

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 […]

GoldenGate Cloud Service (GGCS): Enable SSL SQLNet on GGCS to connect to Oracle Database

Introduction This document will walk you through how to enable SSL SQLNet connection on GGCS to connect to an Oracle Database. Enabling SSL communication between GGCS and the Oracle database is achieved by configuring credential wallet on both GGCS and the database which will store certificates and by modifying the configuration files used for SQLNet […]

GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC) via Oracle Cloud Gateway VPN

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Oracle Cloud Gateway Virtual Private Network (VPN) using Corente Services Gateway. Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning […]

GoldenGate Cloud Service (GGCS): Network Connectivity Options for GGCS – On-Premises and Oracle Cloud

Introduction This article will discuss in high-level the different options available for network connectivity between Oracle GoldenGate (OGG) software running on-premises and GoldenGate Cloud Service (GGCS) instance running on the Oracle Cloud. The following topics are not included in the scope of this article: Installation and Configuration of Oracle GoldenGate (OGG) Software Provisioning of GoldenGate […]

GoldenGate Cloud Service (GGCS): How to provision GGCS in Oracle Public Cloud (OPC) via RESTful API

Introduction This document will walk you through how to provision GoldenGate Cloud Service (GGCS) in Oracle Public Cloud (OPC) via RESTful application programming interface (API). For the purpose of this article, it will be using “cURL” as the RESTful client software to demonstrate the RESTful API calls for provisioning GGCS. For checking the progress of […]

GoldenGate Cloud Service (GGCS): Replication from Amazon RDS MySQL Database to Oracle DBCS

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication from Amazon Relational Database Service (RDS) MySQL Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Oracle GoldenGate Cloud Service (GGCS). The following topics are not included in […]

GoldenGate Cloud Service (GGCS): Replication from Amazon RDS Oracle Database to Oracle DBCS

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication from Amazon Relational Database Service (RDS) Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Oracle GoldenGate Cloud Service (GGCS). The following topics are not included […]

GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC)

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via GoldenGate Cloud Service (GGCS). Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning of Oracle GGCS and DBCS are not […]

Integrating Oracle GoldenGate Cloud Service (GGCS) with Oracle Business Intelligence Cloud Service (BICS)

Introduction This article describes an overview of how to integrate Oracle GoldenGate Cloud Service (GGCS) in terms of populating or loading data into Oracle Business Intelligence Cloud Service (BICS) from On-Premises. Both GGCS and BICS are Platform as a Service (PaaS) services that runs in the Oracle Public Cloud (OPC). For GGCS to be integrated with […]

Oracle GoldenGate: How to Configure On-Premises to GoldenGate Cloud Services (GGCS) Replication with Corente VPN

Introduction Important Update as of 20171201: There’s a new article that covers an updated procedure on how to setup OPC Cloud Gateway VPN using Corente. The article’s title is This document will walk you through how to configure Oracle GoldenGate replication between On-Premises to GoldenGate Cloud Service (GGCS) on Oracle Public Cloud (OPC) via Virtual […]

Oracle GoldenGate: How to configure On-Premises to GoldenGate Cloud Service (GGCS) via DMZ Server

Introduction A DMZ (demilitarized zone) server is a public-facing computer host placed on a separate or isolated network segment. The intention of this DMZ server is to provide an additional layer of network security between servers in the trusted network and servers in the public network. In this article we shall discuss how to configure […]

Oracle GoldenGate Best Practices: Configuring Oracle GoldenGate Monitor 12c

Introduction Oracle GoldenGate provides data capture from transaction logs and delivery for heterogeneous databases and messaging systems. Oracle GoldenGate (OGG) provides a flexible, de-coupled architecture that can be used to implement virtually all database replication scenarios. Oracle GoldenGate Monitor provides secure viewing, management, and alerting capabilities for GoldenGate with end-to-end topology solution displays and customizable […]

Oracle GoldenGate: How to Force OGG Monitor Server to Use a Specific Network Address to Communicate to a Multihomed Monitor Agent

Introduction A multihomed machine is a type of host that uses multiple interfaces and contains two or more network addresses that can be attached to the same LAN segment or a separate LAN segment. Multihoming is a process or a technique widely used to eliminate single point of failure on the network, and provides alternate […]

Oracle GoldenGate Veridata – How To Configure Using Secured Shell (SSH) Tunneling Protocol

Introduction This document will walk you through how to configure Oracle GoldenGate Veridata with Secured Shell (SSH) tunneling protocol in a Linux environment. Main Article The example configuration in this document was done using 3 separate servers. A Veridata server (veridata-ole), a second server acting as a database source server (db-source-ole) running Veridata agent locally, […]

Oracle GoldenGate Best Practices: NFS Mount options for use with Oracle GoldenGate

Introduction The purpose of this document is to outline the file system mount options to use when configuring GoldenGate to run with NFS mounted file system. Main Article Unless IO buffering is OFF, NFS mounts should not be used when running any Oracle GoldenGate processes.  The danger occurs when one process registers the end of a trail file or transaction log […]

Oracle GoldenGate Best Practices: Oracle GoldenGate for ETL Tools

Introduction This document outlines the best practices for implementing Oracle GoldenGate real-time data integration solution to stage data for consumption by an ETL tool. The three different approaches that will be discussed are: Live Reporting database – The basic assumption with this approach is that there is already a Live Reporting database being maintained that can be […]