| Windows Service Oracle AQ Problem [message #568651] |
Mon, 15 October 2012 08:21  |
 |
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  |
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
