OGG-02028 Failed to attach to logmining server Error code 27144, error message: ORA-27144: attempt to kill process failed

Hi,

Goldengate Extract process is abended with ” OGG-02028 Failed to attach to logmining server Error code 27144, error message: ORA-27144: attempt to kill process failed ” error.

 

Details of error are as follows.

 

2020-03-13 14:50:29 INFO OGG-02248 Logmining server DDL filtering enabled.

Source Context :
SourceModule : [er.redo.oraxo]
SourceID : [/scratch/jkrath/view_storage/jkrath_ogg1220fbo/oggcore/OpenSys/src/app/er/redo/oracle/redooraix.c]
SourceFunction : [REDOORAIX_attach(UString &, errmsg_t &)]
SourceLine : [1648]

2020-03-13 14:51:19 ERROR OGG-02028 Failed to attach to logmining server Error code 27144, error message: ORA-27144: attempt to kill process failed.

2020-03-13 14:51:19 ERROR OGG-01668 PROCESS ABENDING.

 

 

This error is something like a Goldengate bug, to solve this problem, roll back Goldengate extract process and modify extract begin time as follows.

 

GGSCI (msddbadm01) 12> alter MSD00PR1 begin 2020-03-12 06:40:24

 

Once you start Goldengate extract process, wait a 15-30minutes, then Extract process will continue to roll forward.

GGSCI (msddbadm01) 11> info MSD00PR1

EXTRACT    MSD00PR1  Last Started 2020-02-12 15:11   Status ABENDED
Checkpoint Lag       31:24:07 (updated 00:43:44 ago)
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2020-03-12 06:50:24
                     SCN 3852.3954672046 (16548168696238)


GGSCI (msddbadm01) 12> alter MSD00PR1 begin 2020-03-12 06:40:24 
ERROR: Not logged into database, use DBLOGIN.


GGSCI (msddbadm01) 14> dblogin userid GGS_ADMIN@MSDB, password AACAAAAAAAAAAAIAXETGCCSCYFRAAAOG, encryptkey default
Successfully logged into database.

GGSCI (msddbadm01 as GGS_ADMIN@MSDB_1) 15> alter MSD00PR1 begin 2020-03-12 06:40:24 
EXTRACT altered.


GGSCI (msddbadm01 as GGS_ADMIN@MSDB_1) 16> info MSD00PR1

EXTRACT    MSD00PR1  Initialized   2020-03-13 15:02   Status STOPPED
Checkpoint Lag       32:21:58 (updated 00:00:10 ago)
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2020-03-12 06:40:24
                     SCN 0.0 (0)


GGSCI (msddbadm01 as GGS_ADMIN@MSDB_1) 17> start MSD00PR1

Sending START request to MANAGER ...
EXTRACT MSD00PR1 starting


GGSCI (msddbadm01 as GGS_ADMIN@MSDB_1) 18> info MSD00PR1

EXTRACT    MSD00PR1  Initialized   2020-03-13 15:02   Status STARTING
Checkpoint Lag       32:21:58 (updated 00:00:21 ago)
Process ID           36963174
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2020-03-12 06:40:24
                     SCN 0.0 (0)

GGSCI (knctdp01) 41> info EKN00PR1
EXTRACT    EKN00PR1  Last Started 2020-03-13 15:04   Status RUNNING
Checkpoint Lag       29:28:07 (updated 00:00:00 ago)
Process ID           36963174
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2020-03-12 10:56:22
                     SCN 3853.200363347 (16548709354835)

GGSCI (msddbadm01) 40>

 

Gap is closing now, problem has been solved.

 

 

 

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/