My Goldengate Integrated extract got ABENDED because of below error
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
Oracle GoldenGate Capture for Oracle, ext.prm: PROCESS
ABENDING.
Solution:
set the correct DB env and register goldengate 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:
ERROR OGG-02022 Logmining server does not exist on this Oracle
database. (Doc ID 1525272.1)
0 comments:
Post a Comment