Oracle Database Errors or Warnings from Error ORA-25291 to ORA-25301

SQLServerF1

ORA-25291: Buffer does not exist for the specified queue
Cause: Buffer does not exist for the specified queue
Action: Operation on the buffer cannot be performed. create the buffer
ORA-25292: Buffer operations are not supported on the queue
Cause: Buffer operations are not supported on the specified queue type
Action: Buffered operations are only supported on to 8.1 style queues, which do not have transaction grouping.
ORA-25293: Lob attributes must be null for buffered operations
Cause: Enqueue of a buffered message with a non-null lob attribute was attempted
Action: Set the lob attributes to null before enqueuing the buffered message

ORA-25294: Cannot propagate user buffered messages to a database with version lower than 10.2
Cause: Propagation of user buffered messages was attempted to a database with version lower than 10.2.
Action: Do not propagate buffered messages to the database.
ORA-25295: Subscriber is not allowed to dequeue buffered messages
Cause: Subscriber is only allowed to dequeue persistent messages
Action: Drop the subscriber and re-create it, or dequeue only persistent messages for the subscriber
ORA-25296: Queue Table string has a buffered queue string
Cause: Buffered message was enqueued by specifying delay or sequence deviation.
Action: Do not specify delay of sequence deviation when enqueuing buffered messages.

ORA-25298: Only immediate visibility mode supported for buffered message enqueue or dequeue
Cause: A visibility of dbms_aq.ON_COMMIT was supplied with the buffered message enqueue or dequeue
Action: Supply a visibility of dbms_aq.IMMEDIATE
ORA-25299: Invalid message delivery_mode
Cause: Invalid value was specified for delivery mode
Action: Specify dbms_aq.BUFFERED or dbms_aq.PERSISTENT during Enqueue or dbms_aq.BUFFERED, dbms_aq.PERSISTENT or dbms_aq.PERSISTENT_OR_BUFFERED during Dequeue and Listen.
ORA-25300: Cannot drop buffer for queue with buffered subscribers
Cause: Cannot drop buffer for queue with buffered subscribers
Action: Either drop buffered subscribers or forcibly drop the buffer
ORA-25301: Cannot enqueue or dequeue user buffered messages to a database with version lower than 10.2
Cause: Enqueue or dequeue of user buffered messages was attempted to queues in a database with version lower than 10.2.
Action: Do not attempt to enqueue or dequeue user buffered messages.

Above are list of Oracle Database Errors or Warnings from Error ORA-25291 to ORA-25301 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *