Check Active-Active Configuration

REST API Admin Client

Note: The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work.

#!/bin/bash

# ----------------------------------------------------------------------------------------------------
# --
# -- Create USERIDALIAS to connection from GoldenGate to the Databases
# --
# ----------------------------------------------------------------------------------------------------

echo " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- GoldenGate Instance NORTH: Status of Extract (EXTN), DistPath (DPNS), and Replicat (REPS) "
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "

echo "Extract EXTN status:"
curl -s -k -X GET https://north:9001/services/v2/extracts/EXTN                                            \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "Extract EXTN lag:"
curl -s -k -X POST https://north:9001/services/v2/extracts/EXTN/command                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command": "GETLAG", "isReported": true}' | jq '.response.reply'                                \
      | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Extract EXTN statistics:"
curl -s -k -X POST https://north:9001/services/v2/extracts/EXTN/command                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Replicat REPS status:"
curl -s -k -X GET https://north:9001/services/v2/replicats/REPS                                           \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "DistPath DPNS status:"
curl -s -k -X GET https://north:9002/services/v2/sources/DPNS                                             \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

curl -s -k -X GET https://north:9002/services/v2/sources/DPNS/stats                                       \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
      | jq '.response' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Replicat REPS lag:"
curl -s -k -X POST https://north:9001/services/v2/replicats/REPS/command                                  \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command": "GETLAG", "isReported": true}' | jq '.response.reply'                                \
      |  sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Replicat REPS statistics:"
curl -s -k -X POST https://north:9001/services/v2/replicats/REPS/command                                  \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- GoldenGate Instance NORTH: Status of Extract (EXTN), DistPath (DPNS), and Replicat (REPS) "
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "

echo "Extract EXTS status:"
curl -s -k -X GET https://south:9101/services/v2/extracts/EXTS                                            \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "Extract EXTS lag:"
curl -s -k -X POST https://south:9101/services/v2/extracts/EXTS/command                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command": "GETLAG", "isReported": true}' | jq '.response.reply'                                \
      | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Extract EXTS statistics:"
curl -s -k -X POST https://south:9101/services/v2/extracts/EXTS/command                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "DistPath DPSN status:"
curl -s -k -X GET https://south:9102/services/v2/sources/DPSN                                             \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

curl -s -k -X GET https://south:9102/services/v2/sources/DPSN/stats                                       \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
      | jq '.response' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Replicat REPN status:"
curl -s -k -X GET https://south:9101/services/v2/replicats/REPN                                           \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "Replicat REPN lag:"
curl -s -k -X POST https://south:9101/services/v2/replicats/REPN/command                                  \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command": "GETLAG", "isReported": true}' | jq '.response.reply'                                \
      |  sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Replicat REPN statistics:"
curl -s -k -X POST https://south:9101/services/v2/replicats/REPN/command                                  \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

exit

# --
# -- Connect the GoldenGate Deployment depl_north
# --
CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_26ai !

INFO  EXTRACT extn
SEND  EXTRACT extn, GETLAG
STATS EXTRACT extn, TOTAL, TOTALSONLY *.*

INFO DISTPATH  DPNS
STATS DISTPATH DPNS

INFO  REPLICAT reps
SEND  REPLICAT reps, GETLAG
STATS REPLICAT reps, TOTAL, TOTALSONLY *.*

# --
# -- Connect the GoldenGate Deployment depl_south
# --

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_26ai !

INFO  EXTRACT exts
SEND  EXTRACT exts, GETLAG
STATS EXTRACT exts, TOTAL, TOTALSONLY *.*

INFO  DISTPATH DPSN
STATS DISTPATH DPSN

INFO  REPLICAT repn
SEND  REPLICAT repn, GETLAG
STATS REPLICAT repn, TOTAL, TOTALSONLY *.*

DISCONNECT

After creating the OBEY file, create a shell script to run in Admin Client:

echo "obey check_replication_ActiveActive.oby" | adminclient