Home » Server Options » Streams & AQ » Windows Service Oracle AQ Problem (Oracle Advanced Queuing)
Windows Service Oracle AQ Problem [message #568651] Mon, 15 October 2012 08:21 Go to next message
drdexter33
Messages: 2
Registered: October 2012
Location: United States
Junior Member
We've identified a problem we are having with an Oracle Advanced Queue, however cannot seem to find a resolution with Oracle.

Here's the issue:

• We've written a multi-threaded Windows service that uses a specific db connection to an Oracle schema called schema_X through an Oracle database instance called IVRSD1.
• When testing the service, a tester is connected to the same schema (schema_x) through a different Oracle instance called IVRSD2 using TOAD.
• The tester updates a table.
• This UPDATE triggers a call to a stored procedure which copies the respective updated record to a queue.
• Our windows service (using the IVRSD1 instance) should see the queue entry and dequeue it and process it.
• Since the tester is connected to the IVRSD2 instance and the service is connected to the IVRSD1 instance, it does not.
• If the tester stipulates the IVRSD1 instance (and is in turn connected to the IVRSD1 instance), the service will recognize that the queue has a record pushed onto it and it will process the record accordingly.

This seems to be a problem on the Oracle and we have an open ticket with Oracle support, but still cannot find a resolution.

Thanks in advance for any help

doug

[Updated on: Mon, 15 October 2012 08:32]

Report message to a moderator

Re: Windows Service Oracle AQ Problem [message #569019 is a reply to message #568651] Thu, 18 October 2012 13:27 Go to previous message
drdexter33
Messages: 2
Registered: October 2012
Location: United States
Junior Member
Rac doesn't work with AQ..

Bug 3830972 - DBMS_AQ.LISTEN ON RAC CLUSTER DOES NOT SEE NEW ENQUEUE MESSAGES


[EDITED by LF: removed contents copied from My Oracle Support. Drdexter33, next time - instead of violating copyright - just post a link to a document you found helpful.]

[Updated on: Sat, 20 October 2012 15:15] by Moderator

Report message to a moderator

Previous Topic: Capture logminer process very slow
Next Topic: oracle streams global_names
Goto Forum:
  


Current Time: Thu Mar 28 10:46:24 CDT 2024