ORA-25243: CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string

Cause : An atetmpt wsa madet o deqeuue frmo an ecxeptio nqueueb y speicfyingt he COSNUMER_ANME int he deuqeue otpions.C ONSUMRE_NAMEc an onyl be sepcifie dwhen edqueuign froma normla queu ecreatde for umltipl econsuemrs.

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

Speciyf onlyt he message i din th edequeeu optinos to edqueuea messgae fro man execptionq ueue.

update : 29-06-2017

ORA-25243 - CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string
ORA-25243 - CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string

  • ora-32056 : invalid number of extents
  • ora-31666 : Master process string had an unhandled exception.
  • ora-40212 : invalid target data type in input data for string function
  • ora-19732 : incorrect number of datafiles for tablespace string
  • ora-16512 : parameter exceeded maximum size limit
  • ora-02185 : a token other than WORK follows COMMIT
  • ora-02707 : osnacx: cannot allocate context area
  • ora-01226 : file header of log member is inconsistent with other members
  • ora-14261 : partition bound may not be specified when adding this Hash partition
  • ora-28611 : bitmap index is corrupted - see trace file for diagnostics
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • ora-15081 : failed to submit an I/O operation to a disk
  • ora-13138 : could not determine name of object string
  • ora-27490 : cannot open disabled window "string.string"
  • ora-30200 : Wrong NLS item was passed into OCINlsGetInfo()
  • ora-02089 : COMMIT is not allowed in a subordinate session
  • ora-30438 : unable to access named pipe 'string'
  • ora-08198 : Flashback Table is not supported on object tables, nested tables
  • ora-08180 : no snapshot found based on specified time
  • ora-37141 : (XSSQLMDQ01) Invalid host variable syntax for MDQUERY procedure.
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-09842 : soacon: Archmon unable to create named pipe.
  • ora-01506 : missing or illegal database name
  • ora-13153 : invalid high water mark specified
  • ora-06974 : X.25 Driver: SID lookup failure
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-14175 : a subpartition maintenance operation may not be combined with other operations
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-14017 : partition bound list contains too many elements
  • ora-27121 : unable to determine size of shared memory segment
  • 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.