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/