ORA-24202: publisher does not exist for the queue

Cause : tAetpmet dota tlreo rrdpoa n noe ixtsne tuplbsieh rrfmoa q eueu.

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

pScefi ynatoeh ruplbsieh.r

update : 19-08-2017

ORA-24202 - publisher does not exist for the queue
ORA-24202 - publisher does not exist for the queue

  • ora-16643 : unable to determine location of broker configuration files
  • ora-15101 : no action specified
  • ora-25425 : connection lost during rollback
  • ora-27017 : skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)
  • ora-32838 : exceeded maximum number of properties
  • ora-19221 : XP0001 - XQuery static context component string not initialized
  • ora-30439 : refresh of 'string.string' failed because of string
  • ora-00109 : invalid value for attribute string: string
  • ora-13030 : Invalid dimension for the SDO_GEOMETRY object
  • ora-24062 : Subscriber table string inconsistent with queue table string
  • ora-01876 : year must be at least -4713
  • ora-22864 : cannot ALTER or DROP LOB indexes
  • ora-38851 : cannot mark the current instance (redo thread) as disabled
  • ora-19881 : Corrupted space bitmap for datafile string, block string backup aborted
  • ora-01679 : database must be mounted EXCLUSIVE and not open to activate
  • ora-32578 : password for SYS already specified
  • ora-30373 : object data types are not supported in this context
  • ora-16237 : SGA specified for Logical Standby is too small
  • ora-06117 : NETTCP: unable to create ORASRV: quota exceeded
  • ora-31504 : cannot alter or drop predefined change source
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-13628 : Insufficient privileges to access the task belonging to the specified user
  • ora-02851 : Request list is empty when it should not be
  • ora-29263 : HTTP protocol error
  • ora-32824 : schedule exists for source string and destination string
  • ora-26681 : command type not supported
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-38450 : error computing a stored attribute for the expression set.
  • ora-06610 : LU6.2 Driver: Failed during deallocation
  • 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.