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
Saturday, June 4, 2016
Uni-Directional Replication b/n Oracle 11g and Oracle 12c Using Oracle GoldenGate
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment