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 : 24-08-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-23400 : invalid materialized view name "string"
  • ora-16217 : prepare to switchover has not completed
  • ora-29861 : domain index is marked LOADING/FAILED/UNUSABLE
  • ora-09311 : slsleep: error temporarily suspending process
  • ora-15124 : ASM file name 'string' contains an invalid alias name
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-27508 : IPC error sending a message
  • ora-06261 : NETNTT: nrange() failed
  • ora-24197 : JAVA stored procedure throws JAVA exceptions
  • ora-14126 : only a may follow description(s) of resulting partitions
  • ora-16608 : one or more databases have warnings
  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-09712 : orasrv: log archiver already connected.
  • ora-00070 : command string is not valid
  • ora-31512 : name cannot contain double quotation marks
  • ora-01949 : ROLE keyword expected
  • ora-09818 : Number is too large
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-13777 : invalid list of attribute names
  • ora-30445 : workload queries not found
  • ora-00381 : cannot use both new and old parameters for buffer cache size specification
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-29704 : cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release
  • ora-13045 : invalid compatibility flag
  • ora-01595 : error freeing extent (string) of rollback segment (string))
  • ora-39065 : unexpected master process exception in string
  • ora-14026 : PARTITION and CLUSTER clauses are mutually exclusive
  • ora-30990 : insufficient privileges to change owner of resource string
  • ora-31405 : cannot make changes while change set string is advancing
  • 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.