How to fix the Oracle error JMS-00144: JMS queue cannot be created in multi-consumer enabled queue tables?

In this post, you’ll learn more about the Oracle ErrorJMS-00144: JMS queue cannot be created in multi-consumer enabled queue tables with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

JMS-00144: JMS queue cannot be created in multi-consumer enabled queue tables

Reason for the Error JMS-00144: JMS queue cannot be created in multi-consumer enabled queue tables

Cause: An attempt was made to create a JMS queue in a multi-consumer queue table

How to fix the Error JMS-00144: JMS queue cannot be created in multi-consumer enabled queue tables ?

You can fix this error in Oracle by following the below steps

Action: JMS queues can only be created in queue tables that are not multiconsumer enabled