Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Streams APPLY process in RAC environment

Re: Streams APPLY process in RAC environment

From: Ravi Gaur <ravigaur1_at_gmail.com>
Date: Fri, 17 Aug 2007 12:54:08 -0500
Message-ID: <289232290708171054o53423c27p1b77b0ae994b49aa@mail.gmail.com>


Hi Pete,
The source is at 10.2.0.2 (our core ERP app runs there). The downstream is also 10.2.0.2 but I guess we can easily upgrade that. I'm not sure where the issue is but dba_apply_error doesn't show any errors etc.

On 8/17/07, Pete Sharman <peter.sharman_at_oracle.com> wrote:
>
> Ravi
>
>
>
> Just as a matter of interest, why are you still on 10.2.0.2?
>
>
>
> I've setup downstream capture in a RAC environment source and target
> both 10.2.0.3 but it seems you've got an intermediate level in there
> from the description below? So what you're trying to do is go from source
> -> downstream -> target? Not sure what value there is in the downstream and
> target being different, or is that just because of the OS differences?
>
>
>
> Pete
>
>
>
> "Controlling developers is like herding cats'"
>
> Kevin Loney, Oracle DBA Handbook
>
>
>
> "Oh no, it's not, it's much harder than that!"
>
> Bruce Pihlamae, long term Oracle DBA
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ravi Gaur
> *Sent:* Saturday, 18 August 2007 2:19 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* Streams APPLY process in RAC environment
>
>
>
> Hi all,
> We've a working streams process using the downstream approach. Now we are
> trying to move our Target database to a 2-node RAC environment. I've tried
> setting up a queue-to-queue propagation but its not working so far. If
> anyone has done that, mind sharing the steps? The documentation is a bit
> hard to understand. I've an open SR on this but its not moving at the right
> pace.
>
> Here's the setup from a high-level --
> SOURCE: 10.2.0.2 database on Unix (Solaris 8)
> DOWNSTREAM: 10.2.0.2 database on Unix (Solaris 8) where capture and
> propagation are running (logs from source manually registered)
> TARGET: 10.2.0.3 database on a 2-node RAC cluster running Linux (RHEL 4)
> where apply is running
>
> TIA,
> - Ravi Gaur
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 17 2007 - 12:54:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US