while true do heredoc golden gate info all

While monitoring a Golden Gate Extract ‘catching up’ I got tired of typing ‘info all’ and a tail -f on the report rpt file gives me more information than I want. I’m just interseted in the status of my Extract and my ‘Lag at checkpoint’. …

Shell snippet below echoes ggsci info all output to my screen every 10 (sleep 10) seconds. …

while true
do
  ./ggsci <<EOF
info all
exit
EOF
  sleep 10
done



Use Ctrl^C to break out of the while loop …

GGSCI (********) 1>
Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EL****      13:45:11      00:00:08
EXTRACT     RUNNING     EP****      47:42:56      00:00:05


GGSCI (********) 2>
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.14 17547423 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_131022.0605
AIX 5L, ppc, 64bit (optimized), Oracle 11g on Oct 22 2013 09:35:16

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



GGSCI (********) 1>
Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EL****      13:43:13      00:00:10
EXTRACT     RUNNING    
Read more →

Add simple DDLERROR exception in Replicat to ingore certain ORA errors

Short braindump about adding a DDLERROR error exception in your Golden Gate REPLICAT configuration. …

In this scenario the goal is to prevent my replicat from abending over an ‘ORA-01432: public synonym to be dropped does not exist ‘ error. …

Check statuses for all OGG processes

GGSCI () 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    ABENDED     REPL1       00:00:06      96:57:06

%^(&* My REPL1 Replicat has been down for more than four days… Luckily it is a test site. …

Look up the error
First thing is finding the error that caused the REPLICAT to abend in the report file of the REPL1 Replicat; …

GGSCI () 4> view report REPL1 
.
.
2013-08-28 17:48:28  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [1432], ORA-01432: public synonym to be dropped does not exist SQL drop public synonym <synonym_name>  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
.

OK, the error is obvious. A public synonym did exist on the Extract database but NOT in the Replicat database. So, Golden Gate has captured the ‘drop public synonym’ statement from the Extract database logs and it expects to successfully execute this statement on the Replicat database.
This failed because, apparently, this public synonym is not present in the Replicat database. The result …

Read more →