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 : 20-08-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-36269 : (XSCGMDLAGG10) 'workspace object' does not exist or is not a dimension.
  • ora-12161 : TNS:internal error: partial data received
  • ora-14326 : Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
  • ora-07750 : slemcr: fopen failure
  • ora-30558 : internal error [string] in function based index
  • ora-16103 : Logical Standby apply must be stopped to allow this operation
  • ora-25526 : bad format of _DB_MTTR_SIM_TARGET: string
  • ora-01117 : adding file 'string' with illegal block size: string; limit is string
  • ora-39147 : cannot migrate Data Pump queue table ownership to this instance
  • ora-14286 : cannot COALESCE the only subpartition of this table partition
  • ora-09262 : spdde: error terminating detached (background) process
  • ora-12171 : TNS:could not resolve connect identifier: string
  • ora-06776 : TLI Driver: error sending parms
  • ora-33218 : (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
  • ora-25232 : duplicate recipients specified for message
  • ora-06540 : PL/SQL: compilation error
  • ora-19160 : XP0003 - syntax error: invalid variable name string
  • ora-06534 : Cannot access Serially Reusable package string
  • ora-38609 : FI Not enough memory for tree counting, requires at least stringKB
  • ora-13798 : Parameter string cannot be NULL.
  • ora-19278 : Invalid value: (string) for type: (string)
  • ora-00477 : SNP* process terminated with error
  • ora-13115 : [string]_EDGE$ table does not exist
  • ora-19629 : no files in specified archivelog SCN range
  • ora-06604 : LU6.2 Driver: Unable to allocate session with remote LU
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-00127 : dispatcher string does not exist
  • ora-00341 : log string of thread string, wrong log # string in header
  • ora-00470 : LGWR process terminated with error
  • ora-04073 : column list not valid for this trigger type
  • 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.