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 : 21-07-2017
ORA-24067

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

  • ora-13122 : invalid topo_geometry specified
  • ora-02033 : a cluster index for this cluster already exists
  • ora-37026 : (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-01275 : Operation string is not allowed if standby file management is automatic.
  • ora-06138 : NETTCP: error during connection handshake
  • ora-29520 : name string resolved to a class in schema string that could not be accessed
  • ora-02026 : missing LINK keyword
  • ora-25209 : invalid value string, EXPIRATION should be non-negative or NEVER
  • ora-16758 : the specified apply instance is not running
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-14452 : attempt to create, alter or drop an index on temporary table already in use
  • ora-36670 : (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.
  • ora-07263 : sptpa: kill error.
  • ora-29541 : class string.string could not be resolved
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-12461 : undefined level string for policy string
  • ora-02086 : database (link) name is too long
  • ora-03287 : invalid FREELIST GROUP specified
  • ora-36960 : (XSFCAST27) The value of the string expression must be an odd number. You specified number.
  • ora-25313 : a queue may not subscribe to itself for propagation
  • ora-07595 : sppid: $GETJPIW failure
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-27076 : unable to set limit for open files
  • ora-35095 : (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.
  • ora-14635 : only one resulting subpartition can be specified for MERGE SUBPARTITIONS
  • ora-26727 : Cannot alter queue_to_queue property of existing propagation.
  • ora-31221 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.
  • ora-16219 : This database is not preparing to switch over.
  • ora-13767 : End snapshot ID must be greater than or equal to begin snapsho ID.
  • 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.