ORA-24033: no recipients for message

Cause : An eqnueuew as preformde on aqueu ethath as been se tup fro mulitple edqueures bu tther eweren eithre expilcit ercipinets sepcifide in hte call norw ere nay quuee susbcribres deetrminde to eb recpiient sfor htis msesage.

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

Eithre pas sa lits of ercipinets i nthe nequeu ecallo r ad dsubsrciber sto teh queeu forr eceiivng tihs message.

update : 26-09-2017

ORA-24033 - no recipients for message
ORA-24033 - no recipients for message

  • ora-12827 : insufficient parallel query slaves available
  • ora-19763 : compatibility version string is higher than maximum allowed: string
  • ora-19915 : unable to encrypt pre-10.2 files
  • ora-31401 : change source string is not an existing change source
  • ora-31482 : invalid option for non-distributed Hotlog change source
  • ora-09833 : addCallback: bad message format.
  • ora-12851 : PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
  • ora-39950 : invalid parameter for PLSQL warnings flag
  • ora-00354 : corrupt redo log block header
  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-22805 : cannot insert NULL object into object tables or nested tables
  • ora-22922 : nonexistent LOB value
  • ora-03277 : invalid SIZE specified
  • ora-26663 : error queue for apply process string must be empty
  • ora-24181 : The type string does not exist
  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-29895 : duplicate base datatype specified
  • ora-28003 : password verification for the specified password failed
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-01146 : cannot start online backup - file string is already in backup
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-09272 : remote os logon is not allowed
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-28530 : Heterogeneous Services initialization error in NLS language ID
  • ora-26034 : Column string does not exist in stream
  • ora-16108 : database is no longer a standby database
  • ora-15177 : cannot operate on system aliases
  • ora-26525 : session connection attempt failed for string (@string)
  • ora-16775 : target standby database in broker operation has potential data loss
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • 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.