OGG-02022 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server does not exist on this Oracle database
January 8, 2019 Leave a comment
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 startingGGSCI (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 startingGGSCI (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