GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

integrated replication monitoring with sql query

edited Nov 29, 2016 4:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hello Experts,

we are using golden gate Integrated replication on our three node RAC (source & target). we are configured golden gate high availability.

now we need to monitor golden gate process with sql query.

when extract is stopped,abended

when pump stopped, abended

when replicat is stopped, abened

when manager process is stopped or abended

lag is more than 30 min

then reason why i am asking, golden gate will run from one node always. when node is down, golden gate resources are failover to another node and running fine.

when failed node back online, my cron job on the node complain that golden gate is down, but that is not the case.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center