I am using 32-bit Oracle 10gR2 on both source and the target systems and the operating system is 32-bit Redhat Linux AS 4. I have created sourcedb on sourcemachine and targetdb on targetmachine. I have made sure that I can access both databases from both machines through SQLPLUS.
The Oracle GoldenGate was downloaded from here.
Then a folden 'ggs' was created in ORACLE_HOME and it is the directory where the GoldenGate will be installed, I added the path '$ORACLE_HOME/ggs' to the shared library enviornment variable LD_LIBRARY_PATH.
I opened up the terminal window, made sure that the ORACLE_HOME, ORACLE_SID, and LD_LIBRARY_PATH variables are set and then copied the downloaded the zip GoldenGate software file to ORACLE_HOME/ggs and unzipped it there.
It produced a TAR file. I untarred it by doing:
$ tar -xvof
Then I changed directories to the GoldenGate directory and started GoldenGate by doing:
$ ggsci
GGSCI> CREATE SUBDIRS
GGSCI> START MANAGER
GGSCI> EDIT PARAMS MGR
It will open a parameter file for the manager process in the vi editor, insert following line in the file and save and quit:
PORT 7809
:wq
GGSCI> STOP MANAGER
GGSCI> START MANAGER
I installed Oracle GoldenGate and configured the Manager process on both source and the target systems.
Now I will create Extract Group on the Source system. I am using the SCOTT SCHEMA and replicating the table 'dept':
ADD EXTRACT ext, TRANLOG, BEGIN