Goldengate ERROR: sending message to EXTRACT (Timeout waiting for message)

Hi,

My pump process was hang and it was not go ahead.

 

When I try to stop it, i got the following error.

GGSCI (msddp01.deveci.local) 3> stop P01MSD1
Sending STOP request to EXTRACT P01MSD1 ...
ERROR: sending message to EXTRACT P01MSD1 (Timeout waiting for message).

 

 

To solve this problem, kill the related process then start it again.

 

GGSCI (msddp01.deveci.local) 4> kill P01MSD1
Sending KILL request to MANAGER ...
Killed process (243210) for EXTRACT P01MSD1

GGSCI (msddp01.deveci.local) 6> start P01MSD1
Sending START request to MANAGER ...
EXTRACT P01MSD1 starting

GGSCI (msddp01.deveci.local) 8> info P01MSD1
EXTRACT    P01MSD1  Last Started 2020-03-26 13:18   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:01 ago)
Process ID           59294
Log Read Checkpoint  File ./dirdat/knnpro3/kn000000019
                     2020-03-25 17:53:20.000000  RBA 220002954

GGSCI (msddp01.deveci.local) 8> info P01MSD1
EXTRACT    P01MSD1  Last Started 2020-03-26 13:18   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:01 ago)
Process ID           59294
Log Read Checkpoint  File ./dirdat/knnpro3/kn000000019
                     2020-03-26 13:53:20.000000  RBA 220002954

 

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.

One comment

  1. thank you salih you are lifesaver

Leave a Reply

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