AQ Subscriber not reciving notification after database restart
552305Jun 23 2009 — edited Jun 25 2009Hi All,
I am currently working on moving some code from two synchronous processes to be asynchronous (not part of critical code path), to do this I have been using one Advanced Queue with two PLSQL registered subscribers.
when we first moved the code into test it was working fine and the data would be processed from the queue quite quickly.
however we then had to restart the database for another reason and after that I noticed that queue was slowly building up with nothing moving from the "READY" state.
having a look at aq$<queue_table>s the two subscribers are still shown and it appears like the user id still has the correct grants and priviledges. I have also checked to make sure that the aqtm_processes is still > 0 and that the QMNC and EMN0 backgroud processes are in v$bgprocess.
Can anybody else suggest what i might have missed? I do not want to have to drop and recreate the queue and subscribers whenever the database needs to come down.
Also I know if the subscriber was down and then bought back up it would not process the backlog but is there anyway of getting it to do this?
almost forgot to mention we are running:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Cheers,
Chris