ORA-24028: cannot create a reciever non-repudiable single consumer queue

Cause : Tride toc reaet a ercieevr nno-reupdialbe sniglec onsmuer uqeue

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

Thi sfeautre si no tsupoprted

update : 19-08-2017

ORA-24028 - cannot create a reciever non-repudiable single consumer queue
ORA-24028 - cannot create a reciever non-repudiable single consumer queue

  • ora-14323 : cannot add partition when DEFAULT partition exists
  • ora-12354 : secondary object being dropped
  • ora-02063 : preceding stringstring from stringstring
  • ora-29366 : invalid CONSUMER_GROUP argument specified
  • ora-31506 : duplicate subscription name string
  • ora-09941 : Version of orapasswd or installer is older than file.
  • ora-26093 : input data column size (number) exceeds the maximum input size (number)
  • ora-39059 : dump file set is incomplete
  • ora-28579 : network error during callback from external procedure agent
  • ora-02827 : Invalid file number
  • ora-19589 : %s is not a snapshot or backup control file
  • ora-29955 : error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine
  • ora-33084 : (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
  • ora-16811 : apply instance not recorded by the Data Guard broker
  • ora-10917 : TABLESPACE GROUP cannot be specified
  • ora-01030 : SELECT ... INTO variable does not exist
  • ora-07716 : sksachk: invalid device specification for ARCHIVE
  • ora-30085 : syntax error was found in overlaps predicate
  • ora-27513 : parameter string contains invalid value string
  • ora-02303 : cannot drop or replace a type with type or table dependents
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-33247 : (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-16174 : user requested thread/sequence termination of managed recovery
  • ora-30043 : Invalid value 'string' specified for parameter 'Undo_Management'
  • ora-12037 : unknown export format
  • ora-38713 : Flashback Database logging is already turned on.
  • ora-02764 : Invalid package mode
  • ora-22860 : object type expected
  • ora-00604 : error occurred at recursive SQL level string
  • ora-15109 : conflicting protection attributes 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.