DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, July 14, 2017

OGG-02022 Logmining server does not exist on this Oracle database.

Logmining server does not exist on this Oracle database.


2017-02-28 16:27:56  ERROR   OGG-02022  Oracle GoldenGate Capture for Oracle, ext.prm:  Logmining server does not exist on this Oracle database.
2017-02-28 16:27:56  ERROR   OGG-01668  PROCESS ABENDING.

Solution:
set the correct DB env and register goldengate extract

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

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     STOPPED     EXT1      00:00:00      00:33:03
EXTRACT     STOPPED     DPUMP1      00:00:00      00:56:48

GGSCI (dbhost01.domain.com) 6> dblogin useridalias ggadmin
Successfully logged into database.

GGSCI (dbhost01.domain.com as gguser@ORAGG1) 7> register Extract EXT1 database

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


GGSCI (dbhost01.domain.com as gguser@ORAGG1) 16> start EXT1

Sending START request to MANAGER ...
EXTRACT EXT starting

GGSCI (dbhost01.domain.com as gguser@ORAGG1) 8> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EXT1      00:00:00      00:00:02
EXTRACT     STOPPED     PUMP      00:00:00      00:59:18

No comments: