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/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *