Error Sending Message To Replicat
Contents |
Oracle Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21 Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. GGSCI (localhost.localdomain) 1> info all Program Status Group
Error Sending Message To Replicat (timeout Waiting For Message)
Lag Time Since Chkpt MANAGER RUNNING error sending message to extract EXTRACT RUNNING
Timeout Waiting For Message In Golden Gate
EXT12345 00:00:00 unknown EXTRACT RUNNING EXT67889 00:00:00 unknown EXTRACT RUNNING PUMP1234 00:00:00 oracle goldengate timeout waiting for message unknown EXTRACT RUNNING PUMP5678 00:00:00 unknown REPLICAT RUNNING REP12345 00:00:00 unknown 2) Tried to close the abnormal process restart GGSCI (localhost.localdomain) 2> stop * Sending STOP request to EXTRACT EXT12345 ... ERROR: sending message to EXTRACT EXT12345 (Timeout waiting for message). Sending STOP request to EXTRACT EXT67889 ... ERROR: sending message to EXTRACT EXT67889 send replicat force stop (Timeout waiting for message). Sending STOP request to EXTRACT PUMP1234 ... ERROR: sending message to EXTRACT PUMP1234 (Timeout waiting for message). Sending STOP request to EXTRACT PUMP5678 ... ERROR: sending message to EXTRACT PUMP5678 (Timeout waiting for message). Sending STOP request to REPLICAT REP12345 ... ERROR: sending message to REPLICAT REP12345 (Timeout waiting for message). GGSCI (localhost.localdomain) 3> stop mgr! Sending STOP request to MANAGER ... Request processed. Manager stopped. GGSCI (localhost.localdomain) 4> info all Program Status Group Lag Time Since Chkpt MANAGER STOPPED EXTRACT RUNNING EXT12345 00:00:00 unknown EXTRACT RUNNING EXT67889 00:00:00 unknown EXTRACT RUNNING PUMP1234 00:00:00 unknown EXTRACT RUNNING PUMP5678 00:00:00 unknown REPLICAT RUNNING REP12345 00:00:00 unknown GGSCI (localhost.localdomain) 5> kill EXT12345 ERROR: Manager not currently running. GGSCI (localhost.localdomain) 6> kill EXT67889 ERROR: Manager not currently running. GGSCI (localhost.localdomain) 7> info all Program Status G
SERVICESCLOUD Office365Microsoft SurfaceORACLE RESELLERABOUT US PortfolioHow We WorkMeet Our TeamCareersBLOGCONTACT US Previous Next View Larger Image Goldengate Integrated Extract - Identifying and resolving extract process hang issue Goldengate extract process can
Send Replicat Logend
hang for various reasons. It is very important to have send replicat handlecollisions a process in place to monitor goldengate process and detect hanging issues. I recently encountered
Goldengate Time Since Chkpt Increasing
Goldengate Extract Hang issue. Below is how I resolved this issue: Copy the following SQL and save to file - dba_capture_info.sql: col CAPTURE_NAME for a20; col QUEUE_NAME http://zaakeroracledba.blogspot.com/2015/03/golden-gate-time-since-chkpt-unknown.html for a15; col START_SCN for 9999999999; col STATUS for a10; col CAPTURED_SCN for 9999999999; col APPLIED_SCN for 9999999999; col SOURCE_DATABASE for a10; col LOGMINER_ID for 9999999; col REQUIRED_CHECKPOINTSCN for a30; col STATUS_CHANGE_TIME for a15; col ERROR_NUMBER for a15; col ERROR_MESSAGE for a10; col START_TIME for a30 col CAPTURE_TYPE for a10; SELECT http://princetonits.com/blog/goldengate/goldengate-integrated-extract-identifying-and-resolving-extract-process-hang-issue/ CAPTURE_NAME, QUEUE_NAME, START_SCN, STATUS, CAPTURED_SCN, APPLIED_SCN, SOURCE_DATABASE, LOGMINER_ID, REQUIRED_CHECKPOINT_SCN, STATUS_CHANGE_TIME, ERROR_NUMBER, ERROR_MESSAGE, CAPTURE_TYPE, START_TIME FROM DBA_CAPTURE; 1. Execute the following Query to identify the status of capture and identified that there is a dis-connect between DB and GG Process. SQL> @dba_capture_info.sql CAPTURE_NAME QUEUE_NAME START_SCN STATUS CAPTURED_SCN -------------------- --------------- ----------- ---------- ------------ APPLIED_SCN SOURCE_DAT LOGMINER_ID REQUIRED_CHECKPOINT_SCN STATUS_CHANGE_T ----------- ---------- ----------- ----------------------- --------------- ERROR_NUMBER ERROR_MESS CAPTURE_TY START_TIME ------------ ---------- ---------- ------------------------------ OGG$CAP_ED_APP_B OGG$Q_ED_APP_B 5008875962 DISABLED 5061564126 5061564118 NUTRIQA 13 5061564118 04-NOV-15 LOCAL OGG$CAP_ED_APP_A OGG$Q_ED_APP_A 5007741372 ENABLED 5061668324 5061668314 NUTRIQA 12 5061668314 04-NOV-15 LOCAL 2. I tried doing normal stop. Normal stop did not work as the process was just hanging.
GGSCI (localhost as ggadmin@PQADB2) 3> stop ED_APP_B
Sending STOP request to EXTRACT ED_APP_B ...
ERROR: sending message to EXTRACT ED_APP_B (Timeout waiting for message).
3. As the process was hanging, I did "kill" the extract process.
GGSCI
Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING ZWDDLEXT 00:00:00 00:00:00 EXTRACT RUNNING ZWEXT 00:00:00 00:00:02 EXTRACT RUNNING ZWEXTA 00:00:00 00:00:00 EXTRACT RUNNING ZWEXTB http://blog.mchz.com.cn/?p=5323 00:00:00 00:00:01 EXTRACT RUNNING ZWEXTHIS 00:00:00 00:00:09 EXTRACT RUNNING ZWNEWEXT 00:00:00 00:00:09 REPLICAT RUNNING ZWDDLREP 00:00:00 00:00:01 REPLICAT RUNNING ZWNEWREP 15:34:56 01:32:31 GGSCI (p570quer) 5> send zwnewrep status Sending STATUS request to REPLICAT ZWNEWREP … ERROR: sending message to REPLICAT ZWNEWREP (Timeout waiting error sending for message). -select * from v$sqlarea where sql_id in (select sql_id from v$session where module like ‘%ZWNEWREP%') SQL:DELETE FROM "ZJUINV1O"."ACC_CHARGE_201110" WHERE "REGION_ID" = :b0 AND "ROWID_ID" = :b1 SQL_ID:876bmqjxz1nm1 -select * from table(dbms_xplan.display_cursor(‘876bmqjxz1nm1′)) Plan Table Output SQL_ID 876bmqjxz1nm1, child number 0 ------------------------- DELETE FROM error sending message "ZJUINV1O"."ACC_CHARGE_201110" WHERE "REGION_ID" = :b0 AND "ROWID_ID" = :b1 Plan hash value: 3172440838 ------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------- | 0 | DELETE STATEMENT | | | | 91172 (100)| | | | | 1 | DELETE | ACC_CHARGE_201110 | | | | | | | | 2 | PARTITION RANGE SINGLE| | 83788 | 7364K| 91172 (1)| 00:21:17 | KEY | KEY | |* 3 | TABLE ACCESS FULL | ACC_CHARGE_201110 | 83788 | 7364K| 91172 (1)| 00:21:17 | KEY | KEY | ------------------------------------------------------------------------- Predicate Information (identified by operation id): ---------------------------------- 3 - filter(("ROWID_ID"=:B1 AND "REGION_ID"=:B0)) -全表扫描 GGSCI (p570quer) 7> stop zwnewrep! Sending FORCESTOP request to REPLICAT ZWNEWREP … ST