Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

info all not showing running process

SiddhuMkMay 13 2019 — edited Jun 7 2019

Hi All,

DB version: 11.2.0.4
GG version:11.2.1.0.20

I have one extract (ext1) and two pump (spump1,spump2) process setup on the source node, but When I log into ggsci and issue "info all" it only shows manager process running.

GGSCI (node1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

GGSCI (node1) 2>

whereas, if I issue individual "info" its shows process as running and RBA is changing.

GGSCI (node1) 1> info ext1

EXTRACT    ext1     Last Started 2019-03-08 17:22   Status RUNNING

Checkpoint Lag       00:00:01 (updated 00:00:10 ago)

Log Read Checkpoint  Oracle Redo Logs

                     2019-05-13 13:57:59  Thread 1, Seqno *****, RBA 247088192

                     SCN 664.1994113046 (2853852397590)

Log Read Checkpoint  Oracle Redo Logs

                     2019-05-13 13:57:58  Thread 2, Seqno *****, RBA 5652480

                     SCN 664.1994112952 (2853852397496)

Even at the os level it shows process are running.

13:57:51 # ps -ef | grep ggs

oracle    12987  31470  0 13:57 pts/2    00:00:00 grep ggs

oracle    16820      1  0 Mar08 ?        01:19:10 /home/oracle/ggs/extract PARAMFILE /home/oracle/ggs/dirprm/SPUMP2.prm REPORTFILE /home/oracle/ggs/dirrpt/SPUMP2.rpt PROCESSID SPUMP2 USESUBDIRS

oracle    55107      1  0 12:52 ?        00:00:00 ./mgr PARAMFILE /home/oracle/ggs/dirprm/MGR.prm REPORTFILE /home/oracle/ggs/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRS

oracle    66922  66857  0 13:01 pts/4    00:00:00 ./ggsci

oracle    76576  55107  0 13:12 ?        00:00:02 /home/oracle/ggs/extract PARAMFILE /home/oracle/ggs/dirprm/SPUMP1.prm REPORTFILE /home/oracle/ggs/dirrpt/SPUMP1.rpt PROCESSID SPUMP1 USESUBDIRS

oracle   113996      1  0 Mar08 ?        05:20:49 /home/oracle/ggs/extract PARAMFILE /home/oracle/ggs/dirprm/EXT1.prm REPORTFILE /home/oracle/ggs/dirrpt/EXT1.rpt PROCESSID EXT1 USESUBDIRS

Trail files are generating and shipping to target as intended, but  "info all" at the source node is not showing all the process. Can anyone help me on this please?

Thanks,
Sid

This post has been answered by K.Gan on May 14 2019
Jump to Answer
Comments
Post Details
Added on May 13 2019
11 comments
997 views