3 Replies Latest reply: Apr 4, 2013 9:23 AM by rharland2012 RSS

SELECT STATUS FROM DBA_PROPAGATION WHERE PROPAGATION_NAME = Oracle query weirdness

rharland2012

Hey, folks....

 

got a 'simple' query that is driving me nuts!

Here's the deal - we're troubleshooting some occasional 'paused for flow control' issues on the live side of our Oracle implementation. We replicate all live data to our streams box for datamart stuff, etc.

Occasionally, we encounter problems when replication has an issue and the live side goes into a paused state for propagation.

 

To give us more info on this, we want to query the Oracle box about this state and have it kick an alert when the propagation state is anything other than its nominal status.

So we run this query:

SELECT STATUS FROM DBA_PROPAGATION WHERE PROPAGATION_NAME = (followed by the name of the DB in question).

When we run this query from SAM, we get the following error :

I'm not positive what I'm missing here - I'm a neophyte with Oracle and am just not sure if we need to stage the query differently from inside SAM.

 

Thanks for any info.