PROBLEM:
---------------
After you have installed you goldengate on 12C database,while starting replicat process replicat process may abended.
In my case source database is 11G,destination database is 12C.
After hit this error,I examined the ggserr.log is below:
[oracle@ahebsfin1 ggs_core]$ tail -100f ggserr.log
#################################################################################
2015-06-09 04:07:38 ERROR OGG-02091 Oracle GoldenGate Delivery for Oracle, rep1.prm: Operation not supported because enable_goldengate_replication is not set to true.
#################################################################################
SOLUTION:
----------------
enable_goldengate_replication is new parameter in 12C.
You have to enable this parameter for starting replicat process.
SQL> sho parameter goldengate
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
We set this parameter to TRUE.
SQL> alter system set enable_goldengate_replication=TRUE;
System altered
This is dynamic parameter.Set to TRUE,then replicat can start wihout any problem.
GGSCI (ahebsfin1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1 00:00:00 00:20:15
GGSCI (ahebsfin1) 3> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (ahebsfin1) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:04:29 00:00:01
Tray
