Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2006
    Posts
    11

    Unanswered: Oracle Streams Dequeue

    Currently i want to build a application that read oracle redo log.
    I know it is rocket science to read it directly.
    So i find Oracle Streams.
    I will start a Capture Process where redo log resides, and i set up a JMS application to read the Queue.
    But i am failed to build this system, i wonder if it is possible to use JMS application to read Capture Process queue, or I must create Apply Process in the same database, then create DML/DDL handler?

  2. #2
    Join Date
    Sep 2006
    Posts
    11
    I wonder does anybody know what i mean?

    architecture : Capture Process => Queue => JMS application

    does it possible?


    Or i must use this architecture instead?

    Capture Process => Queue => Apply Process => DML/DDL Handler => User Application


    Any ideas?

  3. #3
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Have you read about Oracle's LogMiner ?

  4. #4
    Join Date
    Sep 2006
    Posts
    11
    What are you supposed to mean?
    Do you know Oracle's Streams?

    Read it before you post reply.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >What are you supposed to mean?
    >Do you know Oracle's Streams?
    >Read it before you post reply.

    It seems you have all the answer.

    Best Wishes & report the results (positive or not) so others can learn.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Sep 2006
    Posts
    11
    Quote Originally Posted by anacedent
    It seems you have all the answer.

    Best Wishes & report the results (positive or not) so others can learn.
    Not really.

    I create the capture process in my source database, also i create the AQ agent, and monitor the capture process with following results.

    Capture Session Total
    Process Session Serial Redo Entries LCRs
    Number ID Number State Scanned Enqueued
    ------- ------- ------- ----------------- ------------ --------
    CP01 16 2 CAPTURING CHANGES 273755 10


    So i got 10 LCRs enqueued.

    and i build my Java JMS application trying to receive these LCRs.

    But it always saying there is no messages in the queue.

    I am sure it is the same queue that both capture process and JMS application.

    So, now, i wonder if it is possible to receive the LCRs from capture process queue? or it must create Propagation Process and Apply process?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •