Solution of Time Since chkpt display unknown in Ogg

1, abnormal phenomenon

[Oracle@localhost ~]$ Ggsci

Oracle Goldengate Command Interpreter for Oracle

Version 11.1.1.0.0 Build 078

Linux, x64, 64bit (optimized), Oracle 28 2010 13:21:11

Copyright (C) 1995, the Oracle and/or its affiliates. All rights reserved.

Ggsci (localhost.localdomain) 1> info All

Program Status Group Lag time Since chkpt

MANAGER RUNNING

EXTRACT RUNNING EXT-ECP 00:00:00 Unknown

EXTRACT RUNNING ext-eds 00:00:00 Unknown

EXTRACT RUNNING ext-xz 00:00:00 Unknown

EXTRACT RUNNING p-eds 00:00:00 Unknown

EXTRACT RUNNING p-xz 00:00:00 Unknown

Replicat RUNNING Rep-bos 00:00:00 Unknown

2. Attempt to turn off exception process restart

Ggsci (Localhost.localdomain) 2> stop *

Sending STOP request to EXTRACT EXT-ECP ...

Error:sending message to EXTRACT EXT-ECP (Timeout waiting for message).

Sending STOP request to EXTRACT ext-eds ...

Error:sending message to EXTRACT ext-eds (Timeout waiting for message).

Sending STOP request to EXTRACT ext-xz ...

Error:sending message to EXTRACT ext-xz (Timeout waiting for message).

Sending STOP request to EXTRACT p-eds ...

Error:sending message to EXTRACT p-eds (Timeout waiting for message).

Sending STOP request to EXTRACT p-xz ...

Error:sending message to EXTRACT p-xz (Timeout waiting for message).

Sending STOP request to Replicat Rep-bos ...

Error:sending message to Replicat Rep-bos (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 EXT-ECP 00:00:00 Unknown

EXTRACT RUNNING ext-eds 00:00:00 Unknown

EXTRACT RUNNING ext-xz 00:00:00 Unknown

EXTRACT RUNNING p-eds 00:00:00 Unknown

EXTRACT RUNNING p-xz 00:00:00 Unknown

Replicat RUNNING Rep-bos 00:00:00 Unknown

Ggsci (Localhost.localdomain) 5> kill EXT-ECP

Error:manager not currently running.

Ggsci (Localhost.localdomain) 6> kill Ext-eds

Error:manager not currently running.

Ggsci (localhost.localdomain) 7> info All

Program Status Group Lag time Since chkpt

MANAGER STOPPED

EXTRACT RUNNING EXT-ECP 00:00:00 Unknown

EXTRACT RUNNING ext-eds 00:00:00 Unknown

EXTRACT RUNNING ext-xz 00:00:00 Unknown

EXTRACT RUNNING p-eds 00:00:00 Unknown

EXTRACT RUNNING p-xz 00:00:00 Unknown

Replicat RUNNING Rep-bos 00:00:00 Unknown

Ggsci (Localhost.localdomain) 8> exit

--Using the stop process, the stop Mgr,kill process does not shut down these processes properly

3. System system level kill related Ogg process

[Oracle@localhost ogg]$ Ps-ef|grep/opt/ogg

Oracle 7479 1 0 Nov10? 00:03:31/opt/ogg/extract PARAMFILE/OPT/OGG/DIRPRM/EXT-ECP.PRM reportfile/opt/ogg/dirrpt/ext-ecp.rpt PROCESSID EXT-ECP Usesubdirs

Oracle 7480 1 0 Nov10? 00:02:30/opt/ogg/extract PARAMFILE/OPT/OGG/DIRPRM/EXT-EDS.PRM reportfile/opt/ogg/dirrpt/ext-eds.rpt PROCESSID Ext-eds Usesubdirs

More Wonderful content: http://www.bianceng.cn/database/Oracle/