ORA-24063: cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers

Cause : Ana ttmeptw asm ad etod owgnraed teh qeuuet abel wehn hter eweer qeuue sonw hihc rlue abse dsusbcrbier sar edeifne.d

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

Reomvet her ul ebaesd usbsrcibres ofr lal uqeuse i nthsi qeuuet abel adn rtery.

update : 28-06-2017

ORA-24063 - cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
ORA-24063 - cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers

  • ora-00274 : illegal recovery option string
  • ora-32128 : setDataBuffer called after fetch has started
  • ora-06790 : TLI Driver: poll failed
  • ora-21524 : object type mismatch
  • ora-27146 : post/wait initialization failed
  • ora-13373 : invalid line segment in geodetic data
  • ora-00256 : cannot translate archive destination string string
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
  • ora-01344 : LogMiner coordinator already attached
  • ora-02038 : define is not allowed for array type
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-24365 : error in character conversion
  • ora-31604 : invalid string parameter "string" for object type string in function string
  • ora-29364 : plan directive string, string already exists
  • ora-00303 : cannot process Parallel Redo
  • ora-09805 : conversion of category number to string failed.
  • ora-31499 : null value specified for required parameter string
  • ora-16605 : unable to delete template, template is in use
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-24078 : cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL
  • ora-28011 : the account will expire soon; change your password now
  • ora-32002 : cannot create SPFILE already being used by the instance
  • ora-32621 : illegal aggregation in UNTIL iteration condition
  • ora-24912 : Listener thread failed. string
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-27215 : skgfgsmcs: sbtinfo2 returned unknown file
  • ora-28174 : Kerberos ticket not provided by proxy
  • ora-02082 : a loopback database link must have a connection qualifier
  • ora-32150 : Cannot perform operation on a null timestamp
  • 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.