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.
Leave Your Comment