ERROR: This EXTRACT EXT1 is already registered with the database.

Problem:

Trying to register ext1 extract and getting the error:

GGSCI> register extract ext1 database

2019-01-03 20:48:26 ERROR OGG-08241 ERROR: This EXTRACT EXT1 is already registered with the database.

Troubleshooting:

GGSCI> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

Solution:

Unregister extract first:

GGSCI> unregister extract ext1 database

2019-01-03 20:51:24 INFO OGG-01750 Successfully unregistered EXTRACT EXT1 from database.

Reregister again:

GGSCI> register extract ext1 database

2019-01-03 20:52:15 INFO OGG-02003 Extract EXT1 successfully registered with database at SCN 1643626.