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 : 18-08-2017

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-01352 : tablespace given for Logminer spill does not exist
  • ora-30483 : window functions are not allowed here
  • ora-36702 : (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.
  • ora-07609 : szprv: $HASH_PASSWORD failure
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-15036 : disk 'string' is truncated
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-29849 : error occurred in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-22151 : cannot resize non-zero variable-length array to zero elements
  • ora-07263 : sptpa: kill error.
  • ora-01176 : data dictionary has more than the string files allowed by the controlfie
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-02717 : osnpfs: incorrect number of bytes written
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-03245 : Tablespace has to be dictionary managed, online and permanent to be able to migrate
  • ora-00702 : bootstrap verison 'string' inconsistent with version 'string'
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-13017 : unrecognized line partition shape
  • ora-24802 : user defined lob read callback error
  • ora-12638 : Credential retrieval failed
  • ora-01931 : cannot grant string to a role
  • ora-00269 : specified log file is part of thread string not string
  • ora-27165 : tried to join thread that does not exist
  • ora-15081 : failed to submit an I/O operation to a disk
  • ora-19512 : file search failed
  • ora-15029 : disk 'string' is already mounted by this instance
  • ora-02169 : FREELISTS storage option not allowed
  • ora-01954 : DEFAULT ROLE clause not valid for CREATE USER
  • ora-02096 : specified initialization parameter is not modifiable with this option
  • ora-19590 : conversation already active
  • 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.