How to fix the Oracle error ORA-27373: unknown or illegal event source queue?

In this post, you’ll learn more about the Oracle ErrorORA-27373: unknown or illegal event source queue with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-27373: unknown or illegal event source queue

Reason for the Error ORA-27373: unknown or illegal event source queue

The source queue specified for the event based job or event based schedule was either not found or was of the wrong type.

How to fix the Error ORA-27373: unknown or illegal event source queue ?

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

Check if the queue exists. If it does make sure it is a multiple consumer queue and it is a post 8.1 compatible queue. Single consumer queues and old-style queues cannot be used as event source queues.

Tags :

Leave Your Comment