ERROR: No Checkpoint Table Specified For ADD REPLICAT

In this post, we are going to have look at Goldengate issue. While adding the replicate, you may get the below error. GGSCI (sec75-2) 2> add replicat LOYTSTR, exttrail /ggatebss/oradata/RBM12C/R4 ERROR: No checkpoint table specified for ADD REPLICAT. Solution: Checkpoint table needs to be created on the replication side. 1. Login to ggsci with dblogin […]

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

Setting Up Table Replication In Oracle Goldengate

Today we are going to learn about the steps use for Setting Up Table Replication In Oracle Goldengate. In this below tutorial, we will setup one-way goldengate replication for below two tables from database SRCDB to TRGDB. DBACLASS.EMP; DBACLASS.DEPT; SOURCE  TARGET  HOST 172.65.47.32 172.20.21.56 DB_NAME SRCDB TEGAB GG PROCESS EXT1(extract) EXT1P(extract pump) REPR1 (replicat) TABLES DBACLASS.EMP […]

Read More

Enable DDL Replication In Goldengate

In this below tutorial, we will enable DDL replication for a table, which is already part of goldengate replication and currently, only DML transactions are getting replicated. TABLE_NAME = APPLIANCE.CLASSTAB1 To enable DDL replication, We need to run few SQL scripts(provided under $GG_HOME)  on the source database. and update the extract parameter file. 1. Run role_setup.sql where […]

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-01028 Partial Record At Sequence Extract Abended

This post is about the error we face in golden gate. Here we have the condition when we face this issue, symptoms, cause, and solution of the error. Applies to: Oracle GoldenGate – Version: 11.1.1.1.0 and later [Release: 11.1.1 and later ] Information in this document applies to any platform. Symptoms Extract abends with below […]

Read More

Defgen Utility In Oracle Goldengate

Let’s have look at the Defgen Utility In Oracle Goldengate.  If the source and target table structures are different from source has then we need to use definition file in replicate file. Example: Here we will generate definition file of a table DBACLASS.EMPLOYEE from the source database and use it in target db.   1. Create defgen […]

Read More

ERROR: No Checkpoint Table Specified For ADD REPLICAT

We are going to learn about the solution which is used solve error we use While adding the replicate, you may get the below error. GGSCI (sec75-2) 2> add replicate LOYTSTR, exttrail /ggatebss/oradata/RBM12C/R4 ERROR: No checkpoint table specified for ADD REPLICAT. Solution:   Checkpoint table needs to be created on the replication side. 1. Login […]

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