ERROR OGG-02022 Oracle GoldenGate Capture for Oracle, ext.prm: Logmining server does not exist on this Oracle database.

Solution:

set the correct DB environment and register OGG extract

GGSCI (oracledev.domain.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     STOPPED     EXT      00:00:00      00:33:03

EXTRACT     STOPPED     PUMP      00:00:00      00:56:48

GGSCI (oracledev.domain.com) 5> register Extract EXT database

2017-02-28 16:32:46  ERROR   OGG-08216  ERROR: Cannot register or unregister EXTRACT EXT because no database login was provided. Use DBLOGIN to establish a connection.

GGSCI (oracledev.domain.com) 6> dblogin useridalias ggadmin

Successfully logged into database.

GGSCI (oracledev.domain.com as GGADMIN@demodb) 7> register Extract EXT database

2017-02-28 16:37:40  INFO    OGG-02003  Extract EXT successfully registered with database at SCN 324129978306.

GGSCI (oracledev.domain.com as GGADMIN@demodb) 16> start EXT

Sending START request to MANAGER ...

EXTRACT EXT starting

GGSCI (oracledev.domain.com) 8> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXT      00:00:00      00:00:02

EXTRACT     STOPPED     PUMP      00:00:00      00:59:18

Reference:

Chandu (2019) ERROR OGG-02022 Logmining server does not exist on this Oracle database. (Doc ID 1525272.1)