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 […]
For the latest patchset you’ll need access to MOS. At the time of writing the latest patchset is 22.214.171.124.12 and can be downloaded from here: Oracle GoldenGate 126.96.36.199.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 Command Interpreter for Oracle
Version 188.8.131.52.0 21381983 OGGCORE_184.108.40.206.0OGGBP_PLATFORMS_150728.2027_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Jul 29 2015 04:52:08
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (ggsrc) 1> stop manager
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y
Sending STOP request to MANAGER ...
GGSCI (ggsrc) 2>exit
Unzip the […]
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 […]
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 […]