Oracle Database Errors or Warnings from Error ORA-24009 to ORA-24018


ORA-24009: invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
Cause: Invalid queue type parameter
Action: Valid values are NORMAL_QUEUE for normal queue and EXCEPTION_QUEUE for exception queue.
ORA-24010: QUEUE string does not exist
Cause: The specified queue does not exist.
Action: Specify a valid queue. Query USER_QUEUES for all the valid queues.
ORA-24011: cannot drop QUEUE, string should be stopped first
Cause: The queue has not been stopped i.e. either enqueue or dequeue is still enabled.
Action: Stop the queue first using the STOP_QUEUE command and disable it from both enqueueing and dequeueing.

ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped
Cause: A queue exists in the queue table which has not been dropped. All queues need to be dropped first.
Action: Drop all queues belonging to this queue table using the drop_queue() command. Be sure to stop the queues appropriately before dropping them. Alternately, use the force option in drop_queuetable.
ORA-24013: invalid value string, RETRY_DELAY should be non-negative
Cause: A negative value was specified for RETRY_DELAY.
Action: Specify a non-negative value for RETRY_DELAY.
ORA-24014: invalid value string, RETENTION_TIME should be FOREVER or non-negative
Cause: Queue retention was specified, but the retention time was specified to be less than zero.
Action: Specify the retention time to be non-negative or FOREVER. Alternately don’t specify retention.

ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
Cause: An invalid QUEUE_PAYLOAD_TYPE specified during create_queue_table.
Action: The QUEUE_PAYLOAD_TYPE should be RAW or an object type that already exists in the database.
ORA-24016: cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
Cause: An invalid object type specified for QUEUE_PAYLOAD_TYPE during create_queue_table.
Action: The user should have execute priviliges on the object type specified for the queue.
ORA-24017: cannot enable enqueue on QUEUE, string is an exception queue
Cause: User tried to enable enqueueing to an exception queue.
Action: None
ORA-24018: STOP_QUEUE on string failed, outstanding transactions found
Cause: There were outstanding transactions on the queue, and WAIT was set to false, so STOP_QUEUE was unsucessful in stopping the queue.
Action: Set WAIT to TRUE and try STOP_QUEUE again. It will hang till all outstanding transactions are completed.

Above are list of Oracle Database Errors or Warnings from Error ORA-24009 to ORA-24018 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.

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 *