Wednesday, March 1, 2017

Logmining server does not exist on this Oracle database.

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)

1 comments:

Unknown said...

Hi

I tired to configure the Goldengate, I got below error.
Oracle DB version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Oracle GG version: 122022 fbo ggs Linux x64 shiphome
Before i logged admin user in GG. ogg is sysdba privilege
register extract ext1 database
GGSCI (ggprod as ogg@proddb) 49> register extract ext1 database
2018-07-24 16:08:14 ERROR OGG-06535 Extract does not support the database compatible setting 12.2.0.

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED DP1 00:00:00 03:57:16
EXTRACT STOPPED EXT1 00:00:00 06:19:16

can you help me. how to resolve.

Post a Comment

Auto Scroll Stop Scroll