Preparing Environment for Oracle Golden Gate Extract and Replication Following Steps should be done to use Oracle Golden Gate Extract and Replication. Two Servers : 1 for extract and 1 for replicat. Oracle Installation in both Server [I am using Oracle 12C Release 2] Database Creation in both Servers Listener Configuration Oracle Golden Gate Installation […]
Category: GOLDENGATE
Oracle Golden Gate Components
Oracle Golden Gate Oracle GoldenGate offers a real-time, log-based replication software platform to meet the needs of today’s transaction-driven applications. The software provides capture, routing, transformation, and delivery of transactional data across heterogeneous databases in real time. Components in Oracle Golden Gate : Following Components are used in Oracle Golden Gate to perform its tasks. Extract […]
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 Replicate. All steps mention the way to replication […]
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 […]
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 […]
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 […]
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 […]
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 […]
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: [oracle@host01 ~]$ /u01/app/oracle/product/12.1.0/gg_12121/ggsci […]
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 oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2 INSTALL_OPTION=ORA12c SOFTWARE_LOCATION=/u01/app/oracle/ggs START_MANAGER=true MANAGER_PORT=7809 DATABASE_LOCATION=/u01/app/oracle/product/12.1.0/dbhome_1 INVENTORY_LOCATION=/u01/app/oraInventory UNIX_GROUP_NAME=oinstall Installing GoldenGate After creating the response the […]