Skip to content

How to Resolve OGG-01754 Cannot register or unregister EXTRACT

  • Oracle

OGG-01754

Saw error OGG-01754, when we tried to unregister an extract process from the database.

GGSCI (dbserver as ogg@orcl) 4> unregister extract e_erpapp database;

2023-12-17 09:00:03  ERROR   OGG-01754  Cannot register or unregister EXTRACT E_ERPAPP because the Extract is currently running. Stop the Extract and retry the command.

OGG-01754 means that the extract process is currently running, Oracle GoldenGate has no way to unregister it from the database.

Solution

You have to stop it first.

GGSCI (dbserver as ogg@orcl) 5> stop E_ERPAPP

Sending STOP request to EXTRACT E_ERPAPP ...
STOP request pending end-of-transaction (1 records so far).

GGSCI (dbserver as ogg@orcl) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     STOPPED     E_ERPAPP    00:00:02      00:00:11
EXTRACT     RUNNING     P_ERPAPP    00:00:00      00:00:10

Now you can unregister the extract safely.

Leave a Reply

Your email address will not be published. Required fields are marked *