Today, I am trying to enable ddl replication and enabling supplemental logging at schema level and failed with following error #
GGSCI (red.gg.ora.com) 3> dblogin userid ggsuser, password oracle
Successfully logged into database.
GGSCI (red.gg.ora.com) 4> ADD SCHEMATRANDATA delta
ERROR: Operation not supported because enable_goldengate_replication is not set to true.
-----### Later I logged into the database, Enabled the new parameter on new database :) 12.1.0.2
SQL> alter system set enable_goldengate_replication=true scope=both;
System altered.
SQL> show parameter enable_goldengate_replication
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean TRUE
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options
After Successfully Enabled supplemental logging at schema level #
[oracle@red goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
GGSCI (red.gg.ora.com) 1> dblogin userid ggsuser, password oracle
Successfully logged into database.
GGSCI (red.gg.ora.com) 2> ADD SCHEMATRANDATA delta
2016-06-21 00:54:49 INFO OGG-01788 SCHEMATRANDATA has been added on schema delta.
2016-06-21 00:54:49 INFO OGG-01976 SCHEMATRANDATA for scheduling columns has been added on schema delta.
-- Nikhil Tatineni --
-- GoldenGate 12c--
Errors Related to GoldenGate #
