ORA-27373: unknown or illegal event source queue

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

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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.

update : 23-06-2017
ORA-27373

ORA-27373 - unknown or illegal event source queue
ORA-27373 - unknown or illegal event source queue

  • ora-34179 : (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.
  • ora-07265 : sppst: semop error, unable to increment semaphore.
  • ora-13345 : a compound polygon geometry has fewer than five coordinates
  • ora-23373 : object group "string"."string" does not exist
  • ora-35023 : (QFCHECK09) The analytic workspace and EIF file definitions of workspace object have incompatible partition definitions.
  • ora-38856 : cannot mark instance string (redo thread string) as enabled
  • ora-12696 : Double Encryption Turned On, login disallowed
  • ora-07592 : sspgprv: Error obtaining required privileges
  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • ora-38309 : object not purgable
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • ora-16171 : RECOVER...FINISH not allowed due to gap for thr string, seq string-string
  • ora-06505 : PL/SQL: variable requires more than 32767 bytes of contiguous memory
  • ora-12682 : Login failed: the SecurID card is in next PRN mode
  • ora-28165 : proxy 'string' may not specify password-protected role 'string' for client 'string'
  • ora-13118 : invalid node_id [string]
  • ora-29841 : invalid option for ALTER INDEXTYPE
  • ora-19697 : standby control file not found in backup set
  • ora-30765 : cannot modify scope for an unscoped REF column
  • ora-40321 : invalid bin number, is zero or negative value
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-39018 : master process received invalid message number string
  • ora-29301 : wrong DBMS_PITR package function/procedure order
  • ora-14168 : only one subpartition may be modified
  • ora-14288 : index is not partitioned by Composite Range method
  • ora-00332 : archived log is too small - may be incompletely archived
  • ora-28021 : cannot grant global roles
  • ora-06815 : TLI Driver: could not link SPX and IPX streams
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-12925 : tablespace string is not in force logging mode
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.