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