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:

[oracle@host01 ~]$ cd /stage
[oracle@host01 stage]$ ls
V40146-01.zip

[oracle@host01 stage]$ unzip V40146-01.zip

[oracle@host01 stage]$ ls -l
total 333952
drwxr-xr-x. 3 oracle oinstall 4096 Sep 25 19:59 fbo_ggs_Linux_x64_shiphome
-rw-r--r--. 1 oracle oinstall 144384 Oct 7 09:04 OGG_WinUnix_Rel_Notes_12.1.2.0.0.doc
-rw-r--r--. 1 oracle oinstall 282049 Oct 7 09:04 OGG_WinUnix_Rel_Notes_12.1.2.0.0.pdf
-rw-r--r--. 1 oracle oinstall 93696 Oct 7 09:04 Oracle-GoldenGate-12.1.2.0-README.doc
-rw-r--r--. 1 oracle oinstall 23528 Oct 7 09:04 Oracle-GoldenGate-12.1.2.0-README.txt
-rw-r--r--. 1 root root 341316447 Jan 26 17:13 V40146-01.zip

[oracle@host01 stage]$ ls fbo_ggs_Linux_x64_shiphome/Disk1
install response runInstaller stage

[oracle@host01 stage]$

Installing the Oracle GoldenGate software for the source

[oracle@host01 ~]$ mkdir -p /u01/app/oracle/product/ogg_src
[oracle@host01 ~]$ ls /u01/app/oracle/product
12.1.0 ogg_src
[oracle@host01 ~]$ cd /stage
[oracle@host01 stage]$ cd fbo_ggs_Linux_x64_shiphome/Disk1
[oracle@host01 Disk1]$ ls
install response runInstaller stage
[oracle@host01 Disk1]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 11011 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3967 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-01-24_12-19-47AM. Please wait ...

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.