ORA-25256: consumer cannot be specified with a single-consumer queue or an exception queue

Cause : nAa ttmetpw sam da eots epicyfa c nousem rnit ehs bucsirtpoi ntsirgnw eh nerigtsreni gof ronitifacitnoo n aisgnelc-nousem ruque eroa nxeectpoi nuque.e

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

oDn tos epicyft ehc nousem rnit ehs bucsirtpoi ntsirgn.

update : 25-06-2017
ORA-25256

ORA-25256 - consumer cannot be specified with a single-consumer queue or an exception queue
ORA-25256 - consumer cannot be specified with a single-consumer queue or an exception queue

  • ora-31199 : Warning in processing file string
  • ora-31209 : DBMS_LDAP: PL/SQL - LDAP count_entry error.
  • ora-06124 : NETTCP: timeout waiting for ORASRV
  • ora-22922 : nonexistent LOB value
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-38603 : FI including & excluding cursor can only return one column
  • ora-00482 : LMD* process terminated with error
  • ora-13423 : invalid cell coordinate parameter
  • ora-16051 : parameter string contains an invalid delay time
  • ora-36672 : (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.
  • ora-23449 : missing user name
  • ora-00076 : dump string not found
  • ora-13701 : Snapshot pair [string, string] seems to be specified in reverse order.
  • ora-13829 : SQL profile named string already exists
  • ora-14315 : cannot merge a partition with itself
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-39960 : scope can only be SYSTEM or SESSION
  • ora-01037 : maximum cursor memory exceeded
  • ora-16515 : no rcv channel
  • ora-06749 : TLI Driver: option not allowed across network
  • ora-33918 : (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
  • ora-03125 : client-server protocol violation
  • ora-31030 : Unable to retrieve XML document
  • ora-26687 : no instantiation SCN provided for "string"."string" in source database "string"
  • ora-24402 : error occured while creating connections in the pool
  • ora-07431 : fork failed
  • ora-01590 : number of segment free list (string) exceeds maximum of string
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-12717 : Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists
  • 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.