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 to the Oracle GoldenGate instance simulating the replication source and one dedicated to the Oracle GoldenGate instance simulating the replication target. The replication source instance manager will use the TCP/IP network port 7809, while the  replication target instance manager will use the TCP/IP network port 7909.

In summary, the environment is:

Host Name OS User Mgr Port Source Install Directory
host01 Linux 64-bit oracle 7809 /u01/app/oracle/product/ogg_src
host01 Linux 64-bit oracle 7909 /u01/app/oracle/product/ogg_trg

When two hosts are configured, the /u01/app/oracle/product directory on host01 will contain the directories 12.1.0 and ogg_src. The /u01/app/oracle/product directory on host02 will contain the directories 12.1.0 and ogg_trg.

Software
    • Oracle Database 12c on Oracle, Linux-64, version 12.1.0.2.
    • Oracle GoldenGate on Oracle, Linux-64 ( Oracle Software Delivery Cloud ), version 12.1.2.0.0, part number V40146-01. This is the part number for 64-bit Linux.

Expanding the Oracle GoldenGate software

The Oracle GoldenGate software bundle is delivered as a zip file (V40146-01.zip ) You must expand the zip file using the unzip command before you can install the software.

Open a terminal window. Use the oracle user (the default user) to change directory to the /stage directory. Unzip the Oracle GoldenGate software bundle:

Installing the Oracle GoldenGate software for the source

Same steps need to be done for installing goldengate on destination side.

In the next article we install oracle goldengate with silent method.

Comments

  1. naseem shaik

    I’m new to oracle golden gate so could you please let me know some of the issues in oracle golden gate and tips to solve it

Leave a Reply