golden gate monitoring–command line

Over the last few years I’ve been working with Oracle Golden Gate (OGG) and the one thing that is an interesting topic with OGG is what is the best way to monitor the environment.  To be honest, there are a few different ways to monitor OGG; yet the simplest is from the command line.  (Yea, for command line junkies).  What I want to show you in this posting is a quick script that can be used to check all the associated objects with OGG.  Below is the script that I created to report on the status of all objects.

 

#!/bin/sh

#info_all.sh

export ORACLE_SID=<ora_SID>
export ORACLE_HOME=<oracle_home>
export ORACLE_BASE=<oracle_base>
export GGS_HOME=<ogg_home>
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:/usr/local/bin:/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

echo
echo “######################################################################”
echo `date +%d/%m/%Y\ %k:%M:%S`
echo
$GGS_HOME/ggsci <<EOF
info all
exit
EOF

Based on the script provided above, if ran, we will see all the relative information associated with OGG on the current host.  Monitoring OGG from the command line is simple and straight forward by using shell scripts.  Using the example provided, you should be able to create additional scripts that can meet your monitoring needs.

Enjoy!

twitter: @dbasolved

blog: http://dbasolved.com

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Julian Dontcheff's Database Blog

The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes

Martins Blog

Trying to explain complex things in simple terms

Oracle Data Warrior

Changing the world, one data model at a time. How can I help you?

Maaz Anjum's Blog

A life yet to be lived...

PeteWhoDidNotTweet

Stuff that interests me, if not you!

The Oracle Instructor

Explain, Exemplify, Empower

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Oracle Spin - Flimatech Blog

Sharing Our Database Experience

Oracle Scratchpad

Just another Oracle weblog

Follow

Get every new post delivered to your Inbox.

Join 1,556 other followers

%d bloggers like this: