Saturday, June 4, 2016

Uni-Directional Replication b/n Oracle 11g and Oracle 12c Using Oracle GoldenGate


Source Database:

Operating System:  Oracle Enterprise Linux 5.8 (x86-64)
Oracle Database:  Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Oracle GoldenGate:  Oracle GoldenGate for Oracle - 11.2.1.0.0

Target Database:

Operating System:  Oracle Enterprise Linux 5.8 (x86-64)
Oracle Database:  Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit
Oracle GoldenGate:  Oracle GoldenGate for Oracle - 12.1.2.0.0

Note-1: No need to set the parameter "enable_goldengate_replication"

Note-2: If target database version in Oracle 12c (12.1.0.2.0) then we have to set TRUE for the following parameter 
        otherwise Replicat Process (rorcl) will not start and you can find the error in ggserr.log 

SQL> alter system set enable_goldengate_replication=TRUE scope=both;
System altered.

SQL> sho parameter enable_

NAME                                   TYPE         VALUE
------------------------------------------  -----------  -----------
enable_goldengate_replication                 boolean      TRUE

No comments:

Post a Comment