GoldenGate Replication Check Script

#!/bin/bash
#Check Oracle GoldenGate replication by counting rows in a small table in Source and Target DBs, and check with adminclient "lag replicat <replicat>"
#chmod 700 thisscript due to password.

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db
export PATH=/usr/bin:/bin:/usr/sbin:/sbin:$ORACLE_HOME/bin

#The following 35 or so lines can be used as a template to create another block to check another replication. If you have many checks, it's better to create a function.

RECIPIENT=myemail
SRCDB=mysrcdb; TGTDB=mytgtdb #source and target DB connect identifiers
REP=myrepname; TGTHST=mytgthost #replicat name and target hostname (assume port 9100 as shown later)
#Check 1: sample table row count
SRCCNT=$(sqlplus -S system/mypassword@$SRCDB <<EOF
set pages 0 head off feed off
select count(*) from myschema.mytable;
exit
EOF
)
SRCCNT=$(echo $SRCCNT) #remove leading spaces
TGTCNT=$(sqlplus -S system/mypassword@$TGTDB <<EOF
set pages 0 head off feed off
select count(*) from myschema.mytable;
exit
EOF
)
TGTCNT=$(echo $TGTCNT)
if (( SRCCNT == TGTCNT )); then
  echo "Good: Table myschema.mytable row count in both Source $SRCDB and Target $TGTDB: $SRCCNT"
else
  echo "Bad: Table myschema.mytable row count: Source $SRCDB: $SRCCNT; Target $TGTDB: $TGTCNT"
  echo "Table myschema.mytable row count: Source $SRCDB: $SRCCNT; Target $TGTDB: $TGTCNT" | mail -s "GoldenGate replication problem" $RECIPIENT
fi
#Check 2: OGG replicat lag
LAG=$(OGG_VAR_HOME=/tmp /u01/app/oracle/goldengate/bin/adminclient <<EOF
connect http://$TGTHST:9100 as oggadmin, password mypassword
lag replicat $REP
EOF
)
if [[ $LAG =~ "At EOF, no more records to process" ]]; then
  echo "Good! Replicat $REP on host $TGTHST has caught up."
else
  echo "Bad: Replicat $REP on host $TGTHST did not catch up"
  echo "Replicat $REP on host $TGTHST did not catch up" | mail -s "GoldenGate replication problem" $RECIPIENT
fi