Goldengate: ERROR OGG-08221 – Cannot Register Or Unregister EXTRACT In Oracle GoldenGate

Introduction

Solution for OGG-08221 – Cannot Register Or Unregister EXTRACT In Oracle GoldenGate

Posted by: Sunilkumar

OGG-08221 – Cannot Register Or Unregister EXTRACT In Oracle GoldenGate:

Supplemental logging wasn’t enable at the database level. Enable DB supplemental logging.

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

GGSCI (ggsource.doyensys.com) 2> dblogin userid gguser@ggsource, password *****
Successfully logged into database.

GGSCI (ggsource.doyensys.com) 3> register extract EXT1 database

2018-08-11 05:20:33 INFO OGG-02003 Extract EXT1 successfully registered with database at SCN 156672.

Recent Posts