GOLDEN GATE STATUS MONITORING SCRIPT

cat run_monitoring_Gg.sh

./monitoring_gg.sh TEST /u01/gg_home/12.2.0.1

./monitoring_gg.sh TESTP /u01/gg_home/12.2.0.1

cat DBNAME _monitoring_gg.log

cat DBNAME _monitoring_gg.log

rm DBNAME _monitoring_gg.log

rm DBNAME _monitoring_gg.log

-    Monitoring.sh -

cat monitoring_gg.sh

#!/bin/ksh

# Script      : monitoring_gg.sh

# Version     : 1.0

# Purpose     : To monitor Goldengate processes and latency

# Usage       : monitoring_gg.sh ORACLE_SID GOLDENGATE_HOME

# Example     : monitoring_gg.sh DBNAME /u01/app/goldengate/11.2.1.0.17

#

# Parameters:

#   1. ORACLE_SID: Database Instance name. This parameter is used to set the appropriate DB environment variables. (NOTE: This is the Instance name not Database name.)

#   2. GOLDENGATE_HOME: Home directory of Goldengate installation

#

# ******************

# Functions

# ******************

# Usage function.

function show_usage {

    echo " "

    echo "Usage: $PWD/monitoring_gg.sh ORACLE_SID GOLDENGATE_HOME"

    echo "   ORACLE_SID  : Name of the Database instance that is configured for Goldengate replication. "

    echo "   GOLDENGATE_HOME : Directory where Goldengate is installed. "

    echo "   LAG_THRESHOLD   : Lag threshold in minutes"

    echo "Example: $PWD/monitoring_gg.sh DBNAME GOLDENGATE_HOME "

    echo " "

    exit 1

}

# **************************************

# Input parameter validation

# **************************************

if [ "$1" ]

then

   ORACLE_SID=`echo $1 | tr "[a-z]" "[A-Z]" `; export ORACLE_SID

else

   show_usage

fi

if [ "$2" ]

then

   GOLDENGATE_HOME=`echo $2`; export GOLDENGATE_HOME

else

   show_usage

fi

# **************************************

# Setting up the environment

# **************************************

ORAENV_ASK=NO; export ORAENV_ASK

. /usr/local/bin/oraenv

ORAENV_ASK= ; export ORAENV_ASK

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$GOLDENGATE_HOME

export PATH=$GOLDENGATE_HOME:$PATH

# **************************************

# Gather Goldengate information

# **************************************

cd $GOLDENGATE_HOME

$GOLDENGATE_HOME/ggsci -s << EOF > /optware/oracle/${ORACLE_SID}_monitoring_gg.log

info all

exit

EOF