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

Problem:

The extract EXT1 stops immediatelly in Golden Gate environment:

GGSCI (stbyrac1.example.com as ggcw@orcl1) 4> start ext1

Sending START request to MANAGER …
EXTRACT EXT1 starting

GGSCI (stbyrac1.example.com as ggcw@orcl1) 5> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:52:17
REPLICAT RUNNING REP1 00:00:00 00:00:02

Troubleshoot:

/GG_HOME/home_1/ggserr.log file contains the following error:

2019-01-08T23:05:11.364+0000 ERROR OGG-02022 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server does not exist on this Oracle database.
2019-01-08T23:05:11.364+0000 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.

Solution:

Register the extract:

GGSCI (stbyrac1.example.com as ggcw@orcl1) 8> register extract ext1 database

2019-01-08 23:10:54 INFO OGG-02003 Extract EXT1 successfully registered with database at SCN 2126943.

Verify:

GGSCI (stbyrac1.example.com as ggcw@orcl1) 9> start ext1

Sending START request to MANAGER …
EXTRACT EXT1 starting

GGSCI (stbyrac1.example.com as ggcw@orcl1) 10> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:58:38
REPLICAT RUNNING REP1 00:00:00 00:00:04

Advertisement

About Mariami Kupatadze
Oracle Certified Master Linkedin: https://www.linkedin.com/in/mariami-kupatadze-01074722/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: