ORA-25321: enqueue failed, user property specified but queue string.string is not an 8.1 style queue

ORA-25321: enqueue failed, user property specified but queue string.string is not an 8.1 style queue

Cause: user properties can only be specified when enqueueing into 8.1 style queues.

Action: Specify an 8.1 style queue or pass user property as NULL.

ORA-25316: Late in the current transaction to begin an Enqueue or Dequeue operation

ORA-25316: Late in the current transaction to begin an Enqueue or Dequeue operation

Cause: Check if the Enqueue or Dequeue operation is performed via triggers on Materialized Views which isn t supported.

Action: Triggers on materialized views aren t supported. Workarounds are on-demand materialized views or execution of trigger code within an autonomous txn.

ORA-25315: unsupported configuration for propagation of buffered messages

ORA-25315: unsupported configuration for propagation of buffered messages

Cause: An attempt was made to propagate buffered messages with the database link pointing to an instance in the destination database which is not the owner instance of the destination queue.

Action: Use queue to queue propagation for buffered messages.

ORA-25314: a commit-time queue table cannot be migrated to 8.0

ORA-25314: a commit-time queue table cannot be migrated to 8.0

Cause: An attempt was made to migrate a commit-time queue table to an unsupported compatibility level.

Action: Provide an appropriate compatibility level, and retry the operation.

ORA-25313: a queue may not subscribe to itself for propagation

ORA-25313: a queue may not subscribe to itself for propagation

Cause: The specified subscriber had a NULL name and an address equal to the queue name.

Action: Provide a valid subscriber and retry the operation.

ORA-25312: Cannot specify nonzero sender protocol

ORA-25312: Cannot specify nonzero sender protocol

Cause: Sender protocol was specified during an enqueue operation.

Action: Specify the enqueue sender protocol as null or zero.

ORA-25311: %s not supported for non-persistent queue

ORA-25311: %s not supported for non-persistent queue

Cause: Specified QOS is not supported for non-persistent queues.

Action: Specify the right QOS.

ORA-25310: Subscriber is Notification only; dequeue not supported

ORA-25310: Subscriber is Notification only; dequeue not supported

Cause: Notification only subscribers are not allowed to dequeue.

Action: Recreate subscriber if necessary.

ORA-25307: Enqueue rate too high, flow control enabled

ORA-25307: Enqueue rate too high, flow control enabled

Cause: Subscribers could not keep pace with the enqueue rate.

Action: Try enqueue after sleeping for some time.

ORA-25306: Cannot connect to buffered queue s owner instance

ORA-25306: Cannot connect to buffered queue s owner instance

Cause: cannot connect to the owner instance of the buffered queue

Action: set listener information in REMOTE_LISTENERS or LOCAL_LISTENERS initialization parameter.

ORA-25305: enqueue failed, expiration must be zero for queue string.string

ORA-25305: enqueue failed, expiration must be zero for queue string.string

Cause: An attempt was made to enqueue to a buffered queue with expiration greater than zero seconds.

Action: Set expiration to zero.

ORA-25304: Cannot use priority order queues for capture LCRs

ORA-25304: Cannot use priority order queues for capture LCRs

Cause: Capture LCRs can only use commit time or enqueue time ordered queues.

Action: Use the appropriate type of queue for captured LCRs.

ORA-25303: Buffered operation allowed only on the owner instance

ORA-25303: Buffered operation allowed only on the owner instance

Cause: Operation was not performed on the owner instance.

Action: Perform operation on the owner instance.

ORA-25302: Operation not possible for non-buffered queue string

ORA-25302: Operation not possible for non-buffered queue string

Cause: Last enqd or ackd message is only supported for buffered queues

Action: The operation is not supported.

ORA-25301: Cannot enqueue or dequeue user buffered messages to a database with version lower than 10.2

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.

ORA-25300: Cannot drop buffer for queue with buffered subscribers

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-25299: Invalid message delivery_mode

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-25298: Only immediage visibility mode supported for buffered message enqueue or dequeue

ORA-25298: Only immediage 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-25296: Queue Table string has a buffered queue string

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-25295: Subscriber is not allowed to dequeue buffered messages

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-25294: Cannot propagate user buffered messages to a database with version lower than 10.2

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-25293: Lob attributes must be null for buffered operations

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-25292: Buffer operations are not supported on the queue

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-25291: Buffer does not exist for the specified queue

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-25290: Cannot complete operation on queue string with existing messages

ORA-25290: Cannot complete operation on queue string with existing messages

Cause: Queue already has messages. Cannot complete operation

Action: Truncate the queue before adding or dropping a buffer

ORA-25289: Buffer Already Exists

ORA-25289: Buffer Already Exists

Cause: Buffer already exists for the specified queue.

Action: None

ORA-25288: AQ HTTP propagation encountered error, status-code number, string

ORA-25288: AQ HTTP propagation encountered error, status-code number, string

Cause: AQ propagation s HTTP request to the propagation servlet at the specified address encountered an error

Action: Specify a valid address in the connect string of the propagation destination dblink, the dblink user has the correct permissions, check if the AQ propagation servlet was properly installed.

ORA-25287: Invalid value string, string should be non-negative

ORA-25287: Invalid value string, string should be non-negative

Cause: An Invalid value or NULL was specified for the parameter.

Action: Specify a non negative integer.

ORA-25286: Invalid number of elements in the message properties array

ORA-25286: Invalid number of elements in the message properties array

Cause: Number of elements in the message properties array do not match the number of elements in the payload array.

Action: Create a message property array with one element (that applies for all the elements in the payload array) or create a message property array with the same number of elements as there are in the payload array.

ORA-25285: Invalid value string for array_mode

ORA-25285: Invalid value string for array_mode

Cause: An Invalid value or NULL was specified for the array_mode.

Action: Check the documentation for valid values.

ORA-25284: Invalid value string for string

ORA-25284: Invalid value string for string

Cause: An Invalid value or NULL was specified for the parameter.

Action: Check the documentation for valid values.

ORA-25283: either agent s name or address needed for non-repudiation

ORA-25283: either agent s name or address needed for non-repudiation

Cause: neither agent s name nor address provided for non-repudiation

Action: Provide the agent info.

ORA-25282: message id. not provided for non-repudiation

ORA-25282: message id. not provided for non-repudiation

Cause: message id. was not provided

Action: Provide the message id.

ORA-25281: complete reciever information not provided to non-repudiate reciever

ORA-25281: complete reciever information not provided to non-repudiate reciever

Cause: complete reciever information not provided to non-repudiate reciever

Action: Provide the complete reciever information

ORA-25280: complete sender information not provided to non-repudiate sender

ORA-25280: complete sender information not provided to non-repudiate sender

Cause: complete sender information not provided to non-repudiate sender

Action: Provide the complete sender information

ORA-25279: dequeue as select not supported before 8.2

ORA-25279: dequeue as select not supported before 8.2

Cause: Dequeue as select not supported before 8.2.

Action: Dont use select condition while dequeuing

ORA-25278: grantee name cannot be NULL

ORA-25278: grantee name cannot be NULL

Cause: An attempt was made to specify NULL for the grantee parameter.

Action: Specify a valid grantee parameter.

ORA-25277: cannot grant or revoke object privilege on release 8.0 compatible queues

ORA-25277: cannot grant or revoke object privilege on release 8.0 compatible queues

Cause: An attempt was made to grant or revoke object privilege on release 8.0 style queues.

Action: Convert the release 8.0 compatible queue table to release 8.1 compatible using DBMS_AQADM.MIGRATE_QUEUE_TABLE before granting or revoking object privilege.

ORA-25276: table specified is not a queue table

ORA-25276: table specified is not a queue table

Cause: An invalid queue table name is specified.

Action: Check the dictionary views to see if the table is a queue table.

ORA-25275: Test support for buffered queues

ORA-25275: Test support for buffered queues

Cause: internal use only

Action: none.

ORA-25274: AQ Buffered Queue event

ORA-25274: AQ Buffered Queue event

Cause: N or A.

Action: event used for AQ Buffered Queue mode.

ORA-25273: AQ QMN process alternate cleanup event

ORA-25273: AQ QMN process alternate cleanup event

Cause: N or A.

Action: event used for AQ QMN alternate cleanup mode.

ORA-25272: Signature does not exist for the given reciever and message id.

ORA-25272: Signature does not exist for the given reciever and message id.

Cause: Signature does not exist for the given reciever and message id.

Action: Check the message id. and the reciever s information

ORA-25271: queue table not found for the given queue

ORA-25271: queue table not found for the given queue

Cause: The queue table does not exist for the given queue

Action: Provide the right queue name

ORA-25270: sender info does not match with the actual sender of the message

ORA-25270: sender info does not match with the actual sender of the message

Cause: The sender info. and the message id. do not match

Action: Try dequeue again without the signature in dequeue options

ORA-25269: cant specify sognature with get signature option

ORA-25269: cant specify sognature with get signature option

Cause: The signature is not required for the dequeue with get signature option

Action: Try dequeue again without the signature in dequeue options

ORA-25268: didnt dequeue in browse mode with get signature option

ORA-25268: didnt dequeue in browse mode with get signature option

Cause: The dequeue was not performed in browse mode with get signature option

Action: Try dequeue again in browse mode

ORA-25267: didnt specify the signature for a reciever non-repudiable queue

ORA-25267: didnt specify the signature for a reciever non-repudiable queue

Cause: The signature was not specified for a reciever non-repudiable queue

Action: Try dequeue again along with the signature

ORA-25266: didnt try to dequeue by message id. with the signature

ORA-25266: didnt try to dequeue by message id. with the signature

Cause: The signature was specified for a queue, but the dequeue was not done by message id.

Action: Try dequeue again by message id.

ORA-25265: specified signature for a queue which does not support reciever non-repudiation

ORA-25265: specified signature for a queue which does not support reciever non-repudiation

Cause: An attempt was made to dequeue the message from a queue which does not support reciever non-repudiation, but the signature was specified for verification

Action: Try dequeue again without the signature

ORA-25264: cant get signature for this queue

ORA-25264: cant get signature for this queue

Cause: An attempt was made to dequeue the signature from this queue, which is not reciever non-repidiable.

Action: Try dequeue again without the get signature option

ORA-25263: no message in queue string.string with message ID string

ORA-25263: no message in queue string.string with message ID string

Cause: An attempt was made to dequeue a message with a specific message ID, but no such message exists in the queue.

Action: Try dequeue again with a valid message ID.

ORA-25262: agent name cannot be NULL if address is a multi-consumer queue

ORA-25262: agent name cannot be NULL if address is a multi-consumer queue

Cause: The name for the agent in the LISTEN call was not specified when the agent address was a multi-consumer queue.

Action: Specify a non-NULL name for the agent.

ORA-25261: JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation

ORA-25261: JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation

Cause: AQ Propagator encountered a setting for JOB_QUEUE_PROCESSES that is insufficient for AQ propagation.

Action: Set the number of JOB_QUEUE_PROCESSES to at least 2 for AQ propagation.

ORA-25260: AQ latch cleanup testing event

ORA-25260: AQ latch cleanup testing event

Cause: N or A.

Action: event used for AQ statistics latch cleanup testing.

ORA-25259: cannot specify protocol for agent

ORA-25259: cannot specify protocol for agent

Cause: The user specified the protocol attribute for an agent in the agent list.

Action: Do not specify the protocol attribute of the agent object type.

ORA-25258: cannot register for notifications on an 8.0 style exception queue

ORA-25258: cannot register for notifications on an 8.0 style exception queue

Cause: An attempt was made to specify an 8.0 style exception queue in the subscription string of OCIRegister.

Action: Specify a normal queue or a non-persistent queue.

ORA-25257: consumer must be specified with a multi-consumer queue

ORA-25257: consumer must be specified with a multi-consumer queue

Cause: An attempt was made to register on a multi-consumer queue without specifying a consumer in the subscription string.

Action: Specify a consumer in the subscription string.

ORA-25256: consumer cannot be specified with a single-consumer queue or an exception queue

ORA-25256: consumer cannot be specified with a single-consumer queue or an exception queue

Cause: An attempt was made to specify a consumer in the subscription string when registering for notification on a single-consumer queue or an exception queue.

Action: Do not specify the consumer in the subscription string.

ORA-25255: incorrect subscription string string

ORA-25255: incorrect subscription string string

Cause: An incorrect subscription string was specified with OCIRegister.

Action: Specify a subscription string using the (CONSUMER:(SCHEMA.QUEUE form.