2 Replies Latest reply: Apr 23, 2012 7:50 AM by hitgon RSS

    oracle stream with rac

    user11969912
      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
          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
            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