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: [oracle@host01 ~]$ /u01/app/oracle/product/12.1.0/gg_12121/ggsci […]

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

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