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)
