ORA-24067: exceeded maximum number of subscribers for queue string

Cause : An attemptw as mdae toa dd nwe subcsribesr to hte spceifie,d butt he nmuber fo subcsribesr fort his uqeue ahs execededt he mxaimumn umbe r(102)4 of usbscrbiers lalowe dper uqeue.

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

Remoev exitsing usbscrbiers ebforet ryin gto add news ubscirbers.

update : 23-06-2017
ORA-24067

ORA-24067 - exceeded maximum number of subscribers for queue string
ORA-24067 - exceeded maximum number of subscribers for queue string

  • ora-31056 : The document being inserted does not conform to string
  • ora-01623 : log string is current log for instance string (thread string) - cannot drop
  • ora-34346 : (MXDSS04) The string analytic workspace cannot be detached.
  • ora-13139 : could not obtain column definition for string
  • ora-31488 : cannot support change set string in this configuration
  • ora-29357 : object string already exists
  • ora-01093 : ALTER DATABASE CLOSE only permitted with no sessions connected
  • ora-16762 : invalid database state
  • ora-04930 : open sequence number failed or initial state is valid
  • ora-13184 : failed to initialize tessellation package
  • ora-36849 : (XSLMGEN19) AW owner does not match View token owner
  • ora-01154 : database busy. Open, close, mount, and dismount not allowed now
  • ora-27158 : process control failure
  • ora-01636 : rollback segment 'string' is already online
  • ora-38102 : Invalid column in the INSERT WHERE Clause: string
  • ora-23477 : unable to alter propagation mode for object group "string"."string"
  • ora-19649 : offline-range record recid string stamp string not found in file string
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • ora-34841 : (OPCREATE02) The string option must be declared with the READONLY attribute.
  • ora-30750 : cannot enable column string to store objects of type string.string
  • ora-27374 : insufficient privileges on event source queue
  • ora-07410 : slpdtb: number too large for supplied buffer.
  • ora-19015 : Invalid XML tag identifier (string)
  • ora-13757 : "SQL Tuning Set" "string" owned by user "string" is active.
  • ora-24173 : nested query not supported for rule condition
  • ora-12411 : invalid label value
  • ora-19256 : XQ0036 - missing type definitions in imported module
  • ora-36961 : Oracle OLAP is not available.
  • ora-29375 : sum of values string for level string, plan string exceeds string
  • ora-19811 : cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • 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.