ORA-26947: Oracle GoldenGate replication is not enabled

When I’m trying to setup OGG On my Linux Machine after finished installing (Installation Steps) when I start my extract process it got ABENDED with the below Error message and when I see the ORA error in the error log and after researching some docs then I realized Oracle introduced a new OGG parameter in order to enable OGG replication

ERROR:

2014-08-15 18:00:38  WARNING OGG-01423  No valid default archive log destination directory found for thread 1.

2014-08-15 18:00:38  INFO    OGG-01515  Positioning to begin time Aug 15, 2014 5:44:29 PM.

----output Trimmed

2014-08-15 18:00:59  ERROR   OGG-00446  Opening ASM file +FRADG/gsource/archivelog/2014_08_15/thread_1_seq_7.302.85568

4013 in DBLOGREADER mode: (26947) ORA-26947: Oracle GoldenGate replication is not enabled.

Not able to establish initial position for begin time 2014-08-15 17:44:29.

2014-08-15 18:00:59  ERROR   OGG-01668  PROCESS ABENDING.

Solution:

For Oracle DB versions 11.2.0.4 and 12.1.0.2 there will be a new init.ora parameter called ENABLE_GOLDENGATE_REPLICATION.  In order for some of the Oracle GoldenGate functionality to work, this parameter must be set to true.

SQL> ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE   SCOPE=BOTH;

System altered.

No need to Bounce the database instance

Referrence : ENABLE_GOLDENGATE_REPLICATION database parameter (Doc ID 1568417.1)