ORA-25257: consumer must be specified with a multi-consumer queue

Cause : An attempt was made to register on a multi-consumer queue without specifying a consumer in the subscription string.

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

Specify a consumer in the subscription string.

update : 29-06-2017
ORA-25257

ORA-25257 - consumer must be specified with a multi-consumer queue
ORA-25257 - consumer must be specified with a multi-consumer queue

  • ora-16523 : operation requires the client to connect to instance "string"
  • ora-01875 : time zone minute must be between -59 and 59
  • ora-09958 : IMON: two processes with the same ORACLE pid are active
  • ora-09747 : pw_detachPorts: server call pws_detach failed.
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-29516 : Aurora assertion failure: string
  • ora-23427 : deferred purge queue argument string out of range
  • ora-33448 : (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.
  • ora-27545 : Fail to prepare buffer for remote update
  • ora-16252 : Rebuild operation not permitted
  • ora-12432 : LBAC error: string
  • ora-10654 : Table is of type temporary or external
  • ora-25015 : cannot perform DML on this nested table view column
  • ora-22345 : recompile type string.string before attempting this operation
  • ora-12526 : TNS:listener: all appropriate instances are in restricted mode
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-19001 : Invalid storage option specified
  • ora-10944 : trace name context forever
  • ora-04065 : not executed, altered or dropped string
  • ora-02293 : cannot validate (string.string) - check constraint violated
  • ora-16657 : reinstatement of database in progress
  • ora-25010 : Invalid nested table column name in nested table clause
  • ora-16790 : the value of the configurable property is invalid
  • ora-19162 : XP0004 - XQuery type mismatch: invalid argument types 'string', 'string' for function 'string'
  • ora-00405 : compatibility type "string"
  • ora-04043 : object string does not exist
  • ora-06002 : NETASY: port read failure
  • ora-14253 : table is not partitioned by Composite Range method
  • ora-12048 : error encountered while refreshing materialized view "string"."string"
  • ora-01493 : invalid SAMPLE size specified
  • 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.