This discussion is archived
2 Replies Latest reply: Apr 23, 2012 5:50 AM by hitgon RSS

oracle stream with rac

user11969912 Newbie
Currently Being Moderated
hi ,

I’m trying to configure oracle stream one direction ( tables level )..
my source and destination database is 10.2.0.4 and destination in rac (three nodes)
source database is one node

please help if there is some configuration required in rac
  • 1. Re: oracle stream with rac
    Boochi Journeyer
    Currently Being Moderated
    The only change needed for streams in RAC environment is use the service name including all the nodes RAC in tnsnames.ora while creating the DB links.
  • 2. Re: oracle stream with rac
    hitgon Expert
    Currently Being Moderated
    Hello

    Please find the Oracle RAC Specific Configuration while implementing Oracle Bidirectional streaming Setup

    #Propagation
    queue_to_queue parameter

    -- Assign Primary / Secondary Instance IDs
    dbms_aqadm.alter_queue_table(queue_table => 'capture_srctab',
    primary_instance => 1,
    secondary_instance => 2);

    dbms_aqadm.alter_queue_table(queue_table => 'apply_srctab',
    primary_instance => 1,
    secondary_instance => 2);

    All Streams processing is done at the owning instance of the queue used by
    the Streams client. To determine the owning instance of each ANYDATA queue
    in a database, run the following query:

    SELECT q.OWNER, q.NAME, t.QUEUE_TABLE, t.OWNER_INSTANCE
    FROM DBA_QUEUES q, DBA_QUEUE_TABLES t
    WHERE t.OBJECT_TYPE = 'SYS.ANYDATA' AND
    q.QUEUE_TABLE = t.QUEUE_TABLE AND
    q.OWNER = t.OWNER;

    #tbsnames.ora
    Service_name=global_name=db_name


    Please find the metalink document
    10gR2 Streams Recommended Configuration [ID 418755.1]


    Regards
    Hitgon

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points