COLS & COLSEXCEPT FILTER in goldengate

Introduction:-  We are going to have look at COLS & COLSEXCEPT FILTER in goldengate.  First, we have mentioned the technical definition of COLS & COLSEXCEPT FILTER. after completing, we are going to learn about the steps use ofCOLS & COLSEXCEPT FILTER in goldengate . These parameters are used to Replicat only specific columns from the Source to […]

Read More

Schema replication using oracle goldengate

Being a  DBA we are must aware of replication in DATA field.  In this tutorial, we will explain how to do schema replication in goldengate. Schema replication means, replicating all the tables of a schema. This table explains about the HOST IP , DB_NAME, Goldengate Process, SCHEMA To Repulicat. All steps mention the way to […]

Read More

Obey Command In Goldengate

Like we execute .sql file against SQL, we can write multiple golden gate commands inside a .oby file and execute it against GGSCI prompt using OBEY command. Use OBEY to process a file that contains a list of Oracle GoldenGate commands. OBEY is useful for executing commands that are frequently used in sequence. EXAMPLE: In the below […]

Read More

OGG-00665 OCI Error Describe For Query

In this post, we are going to have look at OGG-00665 OCI Error Describe For Query. Following steps mention about the steps which we use to solve OGG-00665. Problem:    In goldengate version 12, while starting the extract,it may abend with below error. 2016-04-11 12:31:10  ERROR   OGG-00665  OCI Error describe for query (status = 942-ORA-00942: table […]

Read More

OGG-01031 There Is A Problem In Network Communication

While starting the data pump in golden gate version 12.2.0, you may get an error. We are going to learn the steps which are used to solve this issue.   2016-04-14 15:14:39  ERROR   OGG-01031  There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) […]

Read More

Monitor Goldengate From OEM 12c Cloud Control

This article is about the steps which we use to monitor goldengate from OEM 12c Cloud Control. We can monitor goldengate processes like a manager, extract and replicate and also the lag from OEM 12c cloud control. We need three main things. Goldengate plugin to be deployed on the management server Goldengate plugin to be deployed […]

Read More

Patching Oracle GoldenGate 12c

For the latest patchset you’ll need access to MOS. At the time of writing the latest patchset is 12.1.2.1.12 and can be downloaded from here: Oracle GoldenGate 12.1.2.1.12 Patch Set Availability (Doc ID 1645495.1). we need to make sure that no processes are running out of the home that will be patched:

Unzip the […]

Read More

Oracle GoldenGate 12c: Silent Install

As we know installation of Oracle Goldengate is very easy with GUI mode. In this article we will look at Oracle GoldenGate 12c silent install. Preparing the Response File we can create our response file and save it with ggs.rsp

Installing GoldenGate After creating the response the file , now we need to invoke […]

Read More

Installing Oracle GoldenGate for Oracle 12c

Oracle GoldenGate features can be demonstrated using a single computer and a single database instance. In this case, Oracle GoldenGate replication occurs between two different database schemas running on the same database instance. To make this arrangement possible, the Oracle GoldenGate software must be installed twice on the same computer/VM, in different directories, one dedicated […]

Read More