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.
Can We replicate virtual column data via GG .
Yes, it can possible but after Oracle GG 12.2
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
Hi Naseem
Keep following the blog, we can soon post more on Oracle GG