Stack Overflow
Stack Overflow

Questions tagged [oracle-aq]

Oracle Advanced Queuing (OracleAQ) provides database-integrated message queuing functionality.

Oracle Advanced Queuing (OracleAQ) is the Oracle database's queue management feature.

  • AQ provides a message queuing infrastructure as an integral part of the Oracle server engine.
  • It provides an API for enqueing/dequeing messages to database queues.
  • These messages can be dequeued for asynchronous processing.
  • Oracle AQ also provides functionality to preserve, track, document, correlate, and query messages in queues.

Oracle Streams Advanced Queuing User's Guide:

156 questions
26
votes
2 answers

How to clear a queue in Oracle AQ

I've been testing Oracle AQ for the first time. I have managed to create 2000 rows of test inserts into the queue I created. Now, I'd like to clear those out. As I was teaching myself, I set the expiry time to be a month. I can't wait that long. …
jeph perro
  • 6,242
  • 26
  • 90
  • 124
8
votes
2 answers

Where to get Oracle jar files for 11.2.0.3 - xdb, aq, i18n, xmlparser

I'm trying to update a legacy Java application to be compatible with Oracle 11g version 11.2.0.3. The application was running on Oracle 10g version 10.2.0.4 and uses Oracle Advanced Queues. It has Maven dependencies declared for: aq 10.2.0.4.0 xdb…
Rich Cowin
  • 668
  • 1
  • 8
  • 17
7
votes
2 answers

Start oracle dequeue on startup

I got the following error of Oracle, ORA-25226: dequeue failed, queue string.string is not enabled for dequeue And the following is the Cause and Action for it from the official document: Cause: The queue has not been enabled for dequeue. Action:…
Geln Yang
  • 902
  • 2
  • 20
  • 36
7
votes
1 answer

Oracle AQ same message is delivered twice

I created a AQ in oracle and wrote 2 JMS consumers in Java to listen to the queue. I have observed sometimes that if I produce some message in to queue; the count of dequeued messages from queue is greater than what enqueued. It means that some…
dinesh028
  • 2,137
  • 5
  • 30
  • 47
6
votes
2 answers

dbms_aq.dequeue_array, first message is returned twice

Introduction I'm facing a very strange behaviour on my Oracle SQL Server (exactly: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production) when using the Oracle Advanced Queueing methods. The problem The error is that I enqueue…
bratkartoffel
  • 1,127
  • 1
  • 13
  • 37
5
votes
1 answer

Oracle AQ - Queue Message replication

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g. We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far as we know. For Persistent queue, we have…
Ahsan Shah
  • 3,931
  • 1
  • 34
  • 48
5
votes
2 answers

How to enqueue a JMS message into Oracle AQ using Java

I have an Oracle AQ with the queue type of SYS.AQ$_JMS_TEXT_MESSAGE. What I'm trying to do is to insert a text into the mentioned queue from a java application. The equivalent SQL query is declare r_enqueue_options DBMS_AQ.ENQUEUE_OPTIONS_T; …
Humungus
  • 575
  • 2
  • 5
  • 16
4
votes
2 answers

LDAP: error code 49 - cannot bind the principalDn

I'm a newbie to ApacheDS.I just created a new partition in ApcheDS. When i try to register my connection factory i get above error..(with OracleAQ ) My code is; // ldap settings env.put(Context.INITIAL_CONTEXT_FACTORY,…
Ratha
  • 9,434
  • 17
  • 85
  • 163
4
votes
1 answer

How to delete (drop) an Oracle AQ queue?

I wish to drop an Oracle AQ queue and the table associated with it. What are the commands needed to perform this operation?
Evandro Pomatti
  • 13,341
  • 16
  • 97
  • 165
4
votes
3 answers

Oracle Advance Queue - Dequeue not working

I can't seem to find the solution to my problem, I've been stuck at this for hours. I'm usings Oracle AQs: Dbms_Aqadm.Create_Queue_Table(Queue_Table => 'ITEM_EVENT_QT', Queue_Payload_Type =>…
SaintLike
  • 9,119
  • 11
  • 39
  • 69
3
votes
2 answers

Oracle Advanced Queuing and Jakarta namespace

I am using Oracle AQ in my Java Spring Boot application. I have Oracle JMS implementation AQAPI as dependencies. Recently I had tried to update the application to Spring Boot 3.x which is build on Jakarta, not Javax namespace. However my code is no…
Ev.Rei.
  • 251
  • 2
  • 8
3
votes
0 answers

How to access an Oracle queue with another user?

I have a schema that owns some queues and an application that connects to that schema and uses the queues. For security reasons I want to create a user schema that can access the queue and I want the application to use the user schema from now on. I…
Dinu Nicolae
  • 1,019
  • 2
  • 17
  • 42
3
votes
1 answer

ORA-00932: inconsistent datatypes: expected SYS.AQ$_JMS_TEXT_MESSAGE got SYS.AQ$_JMS_TEXT_MESSAGE

With newer version of Oracle DB (12.2.0.1) we start to receive ORA-00932, for the code which works well with older DB server. Moreover the driver reports strange detail of exception: ORA-00932: inconsistent datatypes: expected…
Marek-A-
  • 474
  • 12
  • 29
3
votes
2 answers

Programmatically check if Oracle AQ Queue exists

We have a messaging system based on Oracle AQ - it works very well, enqueing and dequeing without any problems. Now we got a request to add some sanity checks before startup and during runtime, for example "check if the queue actually exists for the…
Scorpio
  • 2,309
  • 1
  • 27
  • 45
3
votes
2 answers

How to stop & start a queue in Oracle AQ

What are the commands that I have to use to STOP or START an Oracle AQ Queue? I need to STOP the queue in order to perform maintenance and analysis, and later START the queue once the analysis is complete.
Evandro Pomatti
  • 13,341
  • 16
  • 97
  • 165
1
2 3
…
10 11