Category Golden Gate

Oracle Golden Gate Initial Data Load between Source and Target

by Snehashish Ghosh

Scenario


 OS – Windows 7 32 bit

Oracle Database 11g R2

OGG ogg112101

Download OGG from oracle using the following link:

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

We shall replicate data from one schema of a oracle database to another schema in the same oracle database.

Source schema name – sender

Destination schema name – receiver

 Install Oracle Golden Gate


1. Unzip the Oracle Golden Gate installation file ogg112101_ggs_Windows_x86_ora11g_32bit.zip to d:\ogg folder.

             gg_ins1

2.  Open a command prompt,go to golden gate installation folder and run create subdirs.

 d:\ogg>ggsci

 Oracle Golden Gate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

Windows (optimized), Oracle 11g on Apr...

Read More