ERROR OGG-01332 Oracle GoldenGate Collector for Oracle

Source side :

DB : 12.2

OGG : 18.1

GG Mode: Integrated Extract

Target side :

DB: 12.2

OGG: 12.2

GG Mode: Integrated Replicat

After GG upgrade on source side when trying to start the Replicat on target side we are getting below error

$ tail -f /goldengate/ggserr.log

2019-01-23 14:37:47  ERROR   OGG-01332  Oracle GoldenGate Collector for Oracle:  File /goldengate/dirdat/mydev/mydev/HP000000244, with compatibility level 6, is not compatible with the current software version's compatibility level of 5. Modify the file writer's parameter file to generate the appropriate format using the FORMAT LEVEL 5 option.

2019-01-23 14:37:47  ERROR   OGG-01668  Oracle GoldenGate Collector for Oracle:  PROCESS ABENDING.

Solution :

When we upgrade GG on source side we do an alter to pump to generate a new trail file on the Target machine so we need to start the replicat also by altering to the same SEQNO and RBANO if we not do alter and just start with same old trail file then we encounter the error above

To fix the issue alter the replicat (On target side) also along with extract and pump (on Source side)

GGSCI (myoradev.domain.com) 10> alter RDBDEV1 extseqno 245 extrba 0

2019-01-23 14:40:18  INFO    OGG-06594  Replicat RDBDEV1 has been altered through GGSCI. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start RDBDEV1 with NOFILTERDUPTRANSACTIONS option.

REPLICAT (Integrated) altered.

GGSCI (myoradev.domain.com) 11> info RDBDEV1

REPLICAT   RDBDEV1  Initialized   2019-01-23 14:40   Status STOPPED

INTEGRATED

Checkpoint Lag       00:00:00 (updated 00:00:09 ago)

Log Read Checkpoint  File /goldengate/dirdat/mydev/mydev/HP000245

                     First Record  RBA 0

GGSCI (myoradev.domain.com) 12> start RDBDEV1

Sending START request to MANAGER ...

REPLICAT RDBDEV1 starting

ggserr.log

2019-01-23 14:40:18  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): alter RDBDEV1 extseqno 245 extrba 0.

2019-01-23 14:40:18  INFO    OGG-06594  Oracle GoldenGate Command Interpreter for Oracle:  Replicat RDBDEV1 has been altered through GGSCI. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start RDBDEV1 with NOFILTERDUPTRANSACTIONS option.

2019-01-23 14:40:27  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info RDBDEV1.

2019-01-23 14:40:33  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start RDBDEV1.

2019-01-23 14:40:33  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 10.10.33.17:56242 (START REPLICAT RDBDEV1 ).

2019-01-23 14:40:33  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #5).

2019-01-23 14:40:33  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT RDBDEV1 starting.

2019-01-23 14:40:33  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  REPLICAT RDBDEV1 starting.

2019-01-23 14:40:33  INFO    OGG-03059  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Operating system character set identified as UTF-8.

2019-01-23 14:40:33  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2019-01-23 14:40:33  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Successfully set environment variable ORACLE_HOME=/opt/oracle/product/12.1.0.2.64.

2019-01-23 14:40:33  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Successfully set environment variable ORACLE_SID=mydev.

2019-01-23 14:40:34  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Successfully set environment variable ORACLE_HOME=/opt/oracle/product/12.1.0.2.64.

2019-01-23 14:40:34  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Successfully set environment variable ORACLE_SID=mydev.

2019-01-23 14:40:34  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Virtual Memory Facilities for: COM

    anon alloc: mmap(MAP_ANON)  anon free: munmap

    file alloc: mmap(MAP_SHARED)  file free: munmap

    target directories:

    /goldengate/dirtmp.

2019-01-23 14:40:34  INFO    OGG-02526  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Parameter FILTERDUPTRANSACTIONS is ignored by Integrated Replicat.

2019-01-23 14:40:34  INFO    OGG-02545  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.

2019-01-23 14:40:34  INFO    OGG-02527  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Integrated Replicat does not populate a trace table.

2019-01-23 14:40:35  INFO    OGG-02530  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  Integrated replicat successfully attached to inbound server OGG$RDBDEV1.

2019-01-23 14:40:35  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, RDBDEV1.prm:  REPLICAT RDBDEV1 started.

Check Similar issue :

http://chandu208.blogspot.com/2019/03/ogg-01416-oracle-goldengate-capture-for.html

Replicat Abends With ERROR OGG-01332 With Compatibility Level 6, Is Not Compatible With The Current software version's compatibility level of 5. (Doc ID 2385520.1)