ORA-24035: AQ agent string is not a subscriber for queue string

Cause : A nA Qaegn ttahtw a snto asbusrciebrf o rteh uqeeu awss pceiife.d

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

Cehc kteh anm eadn/ro daders so fteh gaetn nadr ertyt h eclal.

update : 25-06-2017
ORA-24035

ORA-24035 - AQ agent string is not a subscriber for queue string
ORA-24035 - AQ agent string is not a subscriber for queue string

  • ora-13295 : geometry objects are in different coordinate systems
  • ora-36954 : (XSFCAST24) The cycle number must be between 1 and number. You specified number.
  • ora-24391 : invalid fetch operation
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-13464 : error loading GeoRaster data: string
  • ora-08205 : ora_addr: $ORACLE_SID not set in environment
  • ora-06539 : target of OPEN must be a query
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-07205 : slgtd: time error, unable to obtain time.
  • ora-06131 : NETTCP: user access denied
  • ora-15156 : cluster in rolling upgrade from version [string] to [string]
  • ora-23331 : column group string does not exist
  • ora-31086 : insufficient privileges to register schema "string"
  • ora-22163 : left hand and right hand side collections are not of same type
  • ora-10653 : Table is in a cluster
  • ora-16569 : Data Guard configuration is not enabled
  • ora-07229 : slcpuc: error in getting number of CPUs.
  • ora-29307 : datafile string error, string
  • ora-08185 : Flashback not supported for user SYS
  • ora-01033 : ORACLE initialization or shutdown in progress
  • ora-24503 : codepoint length overflows for piecewise operation
  • ora-15128 : ASM file name 'string' exceeds maximum length string
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-23457 : invalid flavor ID string
  • ora-33290 : (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
  • ora-00328 : archived log ends at change string, need later change string
  • 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.