GoldenGate: Oracle to Oracle GoldenGate Unidirectional Replication

Oracle to Oracle GoldenGate Unidirectional Replication 

In this article we will see    Oracle to Oracle GoldenGate Unidirectional Replication.

Prerequisites for Replication:

1.Create two Vm/s on your machine

2.Install Oracle Software and Create databases.

3.Make sure two Vm’s are pining each other

Node Details :

GG1 (SOURCE)

192.168.0.51   gg1.orcl.com   gg1

Database Name :PRIMARY

Instance Name : primary

GG2(TARGET)

192.168.0.61   gg2.orcl.com   gg2

Database Name :PRIMARY

Instance Name : primary

(I have taken same names on both machines)

Download Goldengate Binaries 

Download GoldenGate binaries from Oracle.com using below link

https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

Make sure that you are using the correct OS version of binaries.

GG1 :

Setting bash_profile

Export the path in the bash profile

vi  .bash_profile

Run the bash_profile file

Check instance info :

Create directory for gg home :

Create directory fo gghome

Copy the downloaded file to /opt location  Using Winscp

Unzip GoldenGate Software :

Check file in /opt dir :

Now do runinstaller as Oracle user :

[oracle@gg1 Disk1]$ ./runInstaller

Starting Oracle Universal Installer…

 

Checking Temp space: must be greater than 120 MB.   Actual 3551 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 7999 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-06-04_06-23-03PM. Please wait …

 

On step 1 choose version of your oracle software 

Click on Next

Browse  location for GG_HOME

Start Manager with any port number

Click on Next

Check summary

Click on Install

Installation will start

Finally GG will successfully installed on GG1

Click on Close 

Goto GGS_HOME and connect to ./ggsci

Give info all to check manager process is running or not

Open New terminal for SQL prompt  On GG1 :

Connect to database and create user and tables

Enable the parameter for GoldenGate replication

Create admin for GoldeGate

Now execute below Package for additional privs

Add supplemental logdata on columns

Check archive-log enabled or not

On  GGSCI terminal (GG1) :

Login with user credentials(ggadmin)

Add Trandata on which table you want to perform replication

Add extract using below command

Register extract process on database

Now add Exttrail file

Add datapump process

 

Add Remote trail file

Check info all

Two more extract process will added

Create wallet and add credentialstore  to make aliasname for userlogin

From now user can able to login with alias-name called ggadmin_src

Edit the parameter for extint

Edit the parameter for dpint

Check info all

Start both params extint and dpint

 

On GG2 Machine :

Export the path in the bash profile

vi  .bash_profile

Run the .bash_profile

Check the instance info 

Create directory for gg home :

Copy the downloaded file to /opt location  Using WinScp

Goto /opt dire and check for files

Now run ./runInstaller

Starting Oracle Universal Installer…

 

Checking Temp space: must be greater than 120 MB.   Actual 3551 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 7999 MB    Passed

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-06-04_06-23-03PM. Please wait …

 

On step 1 choose version of your oracle software 

Click on Next

Browse  location for GG_HOME

Start Manager with any port number

Click on Next

Check summary

Click on Install

Installation will start

 

 

Finally GG will successfully installed on GG2

Click on Close 

Goto GGS_HOME and run ./ggsci

Check Manager is running or not

Open New terminal for SQL prompt

Connect to database and create user and tables

Enable the parameter for GoldenGate replication

Create admin for GoldeGate

Now execute below Package for additional privs

Add supplemental logdata on columns

Check archive-log enabled or not

Open GGSCI GG2 terminal

Add REPLICAT process

Check info all

Edit the param RPINT

 

START RPINT

Now check the information of each process

Now do insert operation on GG1 SQL terminal

On GG1 GGSCI terminal 

check the stats of DPINT

Now check On GG2 terminal records are replicated are not

Please follow above steps for unidirectional GoldenGate replication for Oracle to Oracle.

If any suggestions or Issues please comment below

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

One thought on “GoldenGate: Oracle to Oracle GoldenGate Unidirectional Replication

Add Comment