Performance Metric Service – Classic Configuration

Almost a year ago, Oracle released Oracle GoldenGate 12c (12.3.0.1.x). At that time, there were two architectures released; Microservices and Classic. Both architectures provided the same enterprise level replication. The only difference was that one enabled a RESTful API interface with HTML5 page and the other was still command line driven.

The biggest change though was with the addition of the Performance Metric Service/Server that come bundled with the core product. (more...)

Build an Integrated Extract using JSON

Now that Oracle GoldenGate 12.3 Microservices have been out for about 9 month; there seems to be more and more discussions around how microservices can be used. The mircoservices architecture provides a faster way for users to build extract, replicats, distribution paths and many other items by using a JSON document and simply calling a REST end-point.

In this post, I’ll show you how to build an integrated extract using JSON and REST APIs. (more...)

Changing Security Role Password in Oracle GoldenGate 12.3 Microservices

One of the nice things about Oracle GoldenGate 12.3 Microserivces, is the flexibility we now have to interact with Oracle GoldenGate. Additionally, what comes with Oracle GoldenGate 12.3 Microservices is a new role based security frame work.

When you first setup Oracle GoldenGate 12.3 Microservices, you setup your ServiceManager and initial deployment. Upon setting this up, you will assign a new administrator to the frame work. This is a different user than (more...)

Start/Stop Extract/Replicat with REST API/JSON

Oracle GoldenGate Microservices Architecture is designed to allow the user to have three different ways of interacting with replication from anywhere. One of these approaches is to use the RESTful APIs that come bundled with release. By using RESTful APIs, an organization can orgistrate how they want GoldenGate to work within their environment.

In this post, you will take a look at how to start a pre-existing extract/replicat by using the RESTful API end points. (more...)

Managing the WINDOW_ID in Goldengate V11.2.1.0.33

When we import data into the landing schema on a Dat Warehouse via Goldengate, we add 3 fields to each record detailing when and how the record got loaded. This can be found in the *.inc files under $GG_HOME/dirinc on the target GG installation. An example of this is:
map xxx.DBA_GGCUTOVER_TEST, TARGET YYY.DBA_GGCUTOVER_TEST,  INSERTALLRECORDS, IGNOREDELETES
COLMAP (
USEDEFAULTS,
WINDOW_ID = @STRCAT(@GETENV(“RECORD”, “FILESEQNO”), @STRNUM(@GETENV(“RECORD”, “FILERBA”), RIGHTZERO, 10)),
OPER_TYPE = @GETENV (“GGHEADER”, “OPTYPE”),
CDC_LOAD_TIMESTAMP= (more...)

Troubleshoot Oracle GoldenGate Using Exception Handler

By default, a Replicat process ABENDS when the data being modified doesn’t exist in the target database. Learn how to troubleshoot Oracle GoldenGate Using Exception Handler mechanism. When this happens you need to troubleshoot the issue and correct it before the Replicat process can proceed. But this wouldn’t be easy, as sometimes it can take […]

The post Troubleshoot Oracle GoldenGate Using Exception Handler appeared first on VitalSoftTech.

OGG-02060: ENABLE_GOLDENGATE_REPLICATION is not set to true for Integrated Extract

When creating the GoldenGate Integrated Extract why do I get the message "ENABLE_GOLDENGATE_REPLICATION is not set to true"?

The post OGG-02060: ENABLE_GOLDENGATE_REPLICATION is not set to true for Integrated Extract appeared first on VitalSoftTech.

OGG-02060 The Oracle Mining Database is not Configured Properly to Support Integrated Capture.

When creating the GoldenGate Integrated Extract I get the OGG-02060 error. How do I resolve it?

The post OGG-02060 The Oracle Mining Database is not Configured Properly to Support Integrated Capture. appeared first on VitalSoftTech.

Want to SPEED Up Your Database Tasks? DBMS_PARALLEL_EXECUTE to the rescue!

Use DBMS_PARALLEL_EXECUTE to divide one huge task into multiple small tasks that can be executed at the same time. See how many ways are there to divide.

The post Want to SPEED Up Your Database Tasks? DBMS_PARALLEL_EXECUTE to the rescue! appeared first on VitalSoftTech.

GoldenGate Not Keeping Up? Split the Process Using GoldenGate Range Function

In most environments one set of GoldenGate process (1 Extract & 1 Replicat process) is sufficient for change data synchronization. But if your source database generates a huge volume of data then a single process may not be sufficient to handle the data volume. In such a scenario there may be need to split the […]

The post GoldenGate Not Keeping Up? Split the Process Using GoldenGate Range Function appeared first on VitalSoftTech.

GoldenGate Active-Active Database Replication with Conflict Detection and Resolution

Bi-Directional Replication also known as Active-Active Replication, is a configuration where both databases are used as an active site and applications perform DML/DDL activities on both Databases. The OGG processes is configured to replicate the transaction data of both the source databases back and forth to each other. 1. Advantages Bi-directional GoldenGate Replication can be […]

The post GoldenGate Active-Active Database Replication with Conflict Detection and Resolution appeared first on VitalSoftTech.

Oracle GoldenGate Data Transformation

Oracle GoldenGate supports data mapping and manipulation. It is done by using options of Table (Extract) and Map (Replicat) parameters. By default OGG assumes that SOURCE and TARGET table definitions are same that part of replication.

The post Oracle GoldenGate Data Transformation appeared first on VitalSoftTech.

Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox

If you have your Oracle VM VirtualBox setup and running there is a possibility that you may need to setup the network for the Virtual Machine to make it accessible from the host machine (Desktop or Laptop). This may be needed when you want to connect your local applications to the database running on the VM VirtualBox.

The post Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox appeared first (more...)

How to Provision Oracle VM VirtualBox using Pre-Built Developer VMs

The post How to Provision Oracle VM VirtualBox using Pre-Built Developer VMs appeared first on VitalSoftTech.

Learn GoldenGate – The Index

Learn about GoldenGate Extract, Pump, Replicat, GGSCI, Logdump, Troubleshooting and Upgrade.

The post Learn GoldenGate – The Index appeared first on VitalSoftTech.

Oracle GoldenGate 11gr2 Upgrade

This article demonstrates the steps to perform an in-place Oracle GoldenGate 11gr2 Upgrade (11.2.0.2). Expectations and Requirements There should be NO DATA LOSS. There should be NO database downtime. Oracle GoldenGate processes names will remain unchanged. Oracle GoldenGate replication will be DOWN for the period of OGG upgrade activity. Upgrade Oracle GoldenGate binaries Source and […]

The post Oracle GoldenGate 11gr2 Upgrade appeared first on VitalSoftTech.

50 Oracle GoldenGate Interview Questions and Answers

Read GoldenGate Interview Questions Learn GoldenGate – The Index Simple Replication • GoldenGate Replication Pre-requisites • GoldenGate Manager • GoldenGate Classical Extract • GoldenGate Pump • GoldenGate Replicat • Uni-directional Replication Summary Advanced Replication • Configure GoldenGate DDL Replication • GoldenGate Integrated Extract 12c Upgrade • Upgrade Classic Extract to Integrated Capture • Goldengate upgrade […]

The post 50 Oracle GoldenGate Interview Questions and Answers appeared first on VitalSoftTech.

Oracle GoldenGate 12c: Silent Install

Starting with GoldenGate 12c, Oracle has moved the installation mechanism into the familiar Oracle Universal Installer, GUI framework. It's a good move not only in terms of ease of use but also for the uniformity of the install process across all Oracle products.

The post Oracle GoldenGate 12c: Silent Install appeared first on VitalSoftTech.

GoldenGate: OGG Commands III

Cataloged here are some very important, common commands that are used via the GGSCI interface during the GoldenGate configuration and for troubleshooting. Related Links • GGSCI Commands I • GGSCI Commands II GGSCI Command Series • GoldenGate: GGSCI Commands I • GoldenGate: GGSCI Commands II • GoldenGate: GGSCI Commands III LogDump Command Series • Goldengate […]

The post GoldenGate: OGG Commands III appeared first on VitalSoftTech.